//Sirket adina ve isciye gore axtarisin olunmasi private void BtnTaskAxtar_OnClick(object sender, RoutedEventArgs e) { dgDashboard.Items.Clear(); //textbox bos buraxilmamasi if (string.IsNullOrEmpty(txtTaskAxtar.Text)) { MessageBox.Show("Nə axtarmaq istədiyinizi yazın", "Bildiriş", MessageBoxButton.OK, MessageBoxImage.Information); return; } List <Model.Task> tasks = db.Tasks.Where(t => (t.Customer.CustomerName.Contains(txtTaskAxtar.Text) || ((t.User.Name + " " + t.User.Surname).Contains(txtTaskAxtar.Text)))).ToList(); //admindirse hamsi gelecek if (db.Users.FirstOrDefault(x => x.UserId == currentUserID).RoleID == 1) { foreach (Model.Task task in tasks) { VwTask vw = new VwTask { Description = task.Description, DeadLine = task.DeadlineTime.ToString("dd/MM/yyyy"), Id = task.TaskId, CreateAt = task.CreationAt, Company = task.Customer.CustomerName, FullName = task.User.Surname + " " + task.User.Name, Finished = task.FinishTime == false ? "Bitməyib":"Bitib" }; dgDashboard.Items.Add(vw); } } List <Model.Task> tas = db.Tasks.Where(t => (t.Customer.CustomerName.Contains(txtTaskAxtar.Text) || t.User.UserName.Contains(txtTaskAxtar.Text)) && t.UserID == currentUserID).ToList(); //moderatordusa ancaq oz yazdigi if (db.Users.FirstOrDefault(x => x.UserId == currentUserID).RoleID == 2) { foreach (Model.Task task in tas) { string ok = task.FinishTime == false ? "Bitmeyib" : "Bitib"; VwTask vw = new VwTask { Description = task.Description, DeadLine = task.DeadlineTime.ToString("dd/MM/yyyy"), Id = task.TaskId, CreateAt = task.CreationAt, Company = task.Customer.CustomerName, FullName = task.User.Surname + " " + task.User.Name, Finished = ok }; dgDashboard.Items.Add(vw); } } }
//datagrid doldurulmasi public void FillDasboard() { CRMEntities dbt = new CRMEntities(); dgDashboard.Items.Clear(); //admindirse hamsi gelecek if (db.Users.FirstOrDefault(x => x.UserId == currentUserID).RoleID == 1) { List <Model.Task> taks = dbt.Tasks.Where(x => x.FinishTime == false).ToList(); foreach (Model.Task task in taks) { string ok = task.FinishTime == false ? "Bitməyib" : "Bitib"; VwTask vw = new VwTask { Description = task.Description, DeadLine = task.DeadlineTime.ToString("dd/MM/yyyy"), Id = task.TaskId, CreateAt = task.CreationAt, Company = task.Customer.CustomerName, FullName = task.User.Surname + " " + task.User.Name, Finished = ok }; dgDashboard.Items.Add(vw); } } //moderatordusa ancaq oz yazdigi if (db.Users.FirstOrDefault(x => x.UserId == currentUserID).RoleID == 2) { List <Model.Task> ta = db.Tasks.Where(x => (x.UserID == currentUserID) && (x.FinishTime == false)).ToList(); foreach (Model.Task task in ta) { string ok = task.FinishTime == false ? "Bitməyib" : "Bitib"; VwTask vw = new VwTask { Description = task.Description, DeadLine = task.DeadlineTime.ToString("dd/MM/yyyy"), Id = task.TaskId, CreateAt = task.CreationAt, Company = task.Customer.CustomerName, FullName = task.User.Surname + " " + task.User.Name, Finished = ok }; dgDashboard.Items.Add(vw); } } }
//datagrid takslarin update olunmasi private void dgDashboard_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e) { if (dgDashboard.SelectedItem != null) { VwTask vwTask = dgDashboard.SelectedItem as VwTask; Task task = new Task(this); TextRange textRange = new TextRange(task.rtbDescript.Document.ContentStart, task.rtbDescript.Document.ContentEnd); task.Title = "Yenilə"; task.UserID = currentUserID; textRange.Text = vwTask.Description; task.UpdateTaskButton(); task.TaskModel = db.Tasks.Find(vwTask.Id); string Username = db.Users.FirstOrDefault(x => x.UserId == currentUserID).UserName; Logger.Write("success", Username + " taskda yeniləmək metodu çağırdı"); task.ShowDialog(); } }