1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 

private Task_GadgetDataContext db = new Task_GadgetDataContext(); 

string[] priorityDescription = { "Χαμηλή", "Κανονική", "Υψηλή" };
var OpenTaskList = (from t in db.Tasks
                                where t.status == 0
                                orderby t.priority descending
                                from p in db.Projects
                                where t.projectID == p.projectID
                                select new
                                {
                                    ProjectID = p.projectID,
                                    Name = p.name,
                                    PriorityDesc = priorityDescription[t.priority],
                                    t.taskID,
                                    t.name,
                                    t.projectID,
                                    t.category,
                                    t.status,
                                    t.imerominia_kataxorisis,
                                    t.priority
                                });

CollectionViewSource TaskViewSource = (CollectionViewSource)this.FindResource("TaskView");
TaskViewSource.Source = OpenTaskList;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace easytechGadget
{
    class OpenTask
    {
        public string ProjectName;
        public int PriorityDesc;
        public string TaskName;
        public DateTime Imerominia;

        public OpenTask() 
        { }

        public OpenTask(string ProjectName1, int PriorityDesc1, string TaskName1, DateTime Imerominia1)
        {
            ProjectName = ProjectName1;
            PriorityDesc = PriorityDesc1;
            TaskName = TaskName1;
            Imerominia = Imerominia1;
        }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 

var OpenTaskList = (from t in db.Tasks
                                where t.status == 0
                                orderby t.priority descending
                                from p in db.Projects
                                where t.projectID == p.projectID
                                select new OpenTask (p.name, t.priority, t.name, Convert.ToDateTime(t.imerominia_kataxorisis))
                                {
                                    //ProjectID = p.projectID,
                                    ProjectName = p.name,
                                    PriorityDesc = t.priority,
                                    //TaskID = t.taskID,
                                    TaskName = t.name,
                                    //TaskProjectID = t.projectID,
                                    //Category = t.category,
                                    //Status = t.status,
                                    Imerominia = Convert.ToDateTime(t.imerominia_kataxorisis),
                                    //Priority = t.priority
                                });


            CollectionViewSource TaskViewSource = (CollectionViewSource)this.FindResource("TaskView");
            TaskViewSource.Source = OpenTaskList;

1
2
3
4
5
6
7
8
9
 

<ListView x:Name="TasksOfProject"  AlternationCount="2"                IsSynchronizedWithCurrentItem="True"
                      ItemsSource="{Binding Source={StaticResource TasksOfProjectView}}" >
                        <ListView.View>
                            <GridView x:Name="TasksOfProjectGrid">
                                <GridViewColumn Header="id" DisplayMemberBinding="{Binding Path=taskID}" Width="10" />
                                <GridViewColumn Header="Περιγραφή" DisplayMemberBinding="{Binding Path=name}" Width="240" />
                            </GridView>
                        </ListView.View>
                    </ListView>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 

private project_managementDataContext ProjectFormDB = new project_managementDataContext();

        private CollectionViewSource TasksOfProjectViewSource;
        private BindingListCollectionView TasksOfProjectView;

        public ProjectForm()
        {
            InitializeComponent();
        }

        private void ProjectForm_Loaded(object sender, RoutedEventArgs e)
        {
            this.TasksOfProjectViewSource = (CollectionViewSource)this.FindResource("TasksOfProjectView");
TasksOfProjectView.Source = ProjectFormDB.Tasks;
            this.TasksOfProjectView = (BindingListCollectionView)this.TasksOfProjectViewSource.View;
         }