private void frmIsTakibi_Load(object sender, EventArgs e) { lblPrjAd.Text = projeAD; lblSurec.Text = prosesAD; Tarih(); using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { List <Users> users = db.Users.Where(k => k.UserRole > 2).ToList(); List <RoleNames> rols = db.RoleNames.ToList(); foreach (var item in users) { rols.Add(rols.Where(r => r.RoleNameID == item.UserRole).FirstOrDefault()); } List <Users> n_users = new List <Users>(); foreach (var y in users.Select(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault())) { cmbAnaliz.Properties.Items.Add(y); cmbTable.Properties.Items.Add(y); cmbProc.Properties.Items.Add(y); cmbDllL.Properties.Items.Add(y); cmbDllIs.Properties.Items.Add(y); cmbArayuz.Properties.Items.Add(y); cmbT1.Properties.Items.Add(y); cmbT2.Properties.Items.Add(y); cmbT3.Properties.Items.Add(y); cmbT4.Properties.Items.Add(y); cmbT5.Properties.Items.Add(y); } } }
private void btnSurecEkle_Click(object sender, EventArgs e) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { if (this.updateP == true) { var upd_list = db.Process.Where(p => p.ProcessID == this.prosesID).FirstOrDefault(); upd_list.ProcessName = txtSrcAd.Text; upd_list.StartDate = Convert.ToDateTime(lblBasDate.Text); upd_list.FinishDate = Convert.ToDateTime(lblEndDate.Text); upd_list.Duration = GunFarki(Convert.ToDateTime(lblBasDate.Text), Convert.ToDateTime(lblEndDate.Text)); upd_list.CompleteRate = Convert.ToInt32(nmbOran.Value); upd_list.Priority = Convert.ToInt32(cmbOncelik.Text); upd_list.Descriptions = txtAciklama.Text; upd_list.Notes = txtNot.Text; db.SaveChanges(); MessageBox.Show("Güncelleme işlemi Başarılı.."); } else { if (TxtKontrol()) { Process process = new Process(); process.CreateUserID = kID; process.ProcessName = txtSrcAd.Text; process.StartDate = Convert.ToDateTime(lblBasDate.Text); process.FinishDate = Convert.ToDateTime(lblEndDate.Text); process.Duration = GunFarki(Convert.ToDateTime(lblBasDate.Text), Convert.ToDateTime(lblEndDate.Text)); process.CompleteRate = Convert.ToInt32(nmbOran.Value); process.Priority = Convert.ToInt32(cmbOncelik.Text); process.Descriptions = txtAciklama.Text; process.Notes = txtNot.Text; process.ProjectID = pId; UserProcess up = new UserProcess(); up.UsersID = kID; if (this.prosesID != 0) { process.ParentID = this.prosesID; up.ProcessID = this.prosesID; up.UserRolesID = db.UserRoles.Where(u => u.UserID == kID).Select(r => r.UserRolesID).FirstOrDefault(); } else { process.ParentID = 0; } db.Process.Add(process); db.SaveChanges(); MessageBox.Show(process.ProcessName + " | Süreç Eklema Başarılı.."); } else { MessageBox.Show("Boş Alanlar Mevcut..!"); } } } }
private void CreateNodes(TreeList tl) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { List <Projects> projeler = new List <Projects>(); projeler = db.Projects.Where(k => k.CreateUserID == kID).ToList(); foreach (var item in projeler) { tl.BeginUnboundLoad(); // string surec=item.Process.Where(p=>p.ProjectID==item.ProjectID).Select(p=>p.ProcessName); // Create a root node . TreeListNode parentForRootNodes = null; TreeListNode rootNode = tl.AppendNode( new object[] { item.ProjectName, item.Process.Count, item.Users1.UserName + " " + item.Users1.UserSurname, item.StartDate.Value.ToShortDateString(), item.FinishDate.Value.ToShortDateString(), Aktiflik(item.isActive.Value), item.Budget + " TL", item.ProjectID }, parentForRootNodes); string[] prosses_header = { "Süreç Adı", "Tamamlanma Oranı" }; tl.AppendNode(prosses_header, rootNode); for (int i = 0; i < item.Process.Count; i++) { tl.AppendNode(new object[] { i + 1 + "-) " + item.Process.ToList()[i].ProcessName, "Tamamlanma: %" + item.Process.ToList()[i].CompleteRate }, rootNode); } tl.EndUnboundLoad(); } } }
private void frmMusteriPrjEkle_Load(object sender, EventArgs e) { dateBaslangic1.MinDate = DateTime.Now; dateBitis1.MinDate = DateTime.Now.AddDays(1); lblBasDate.Text = dateBaslangic1.MinDate.ToShortDateString(); lblEndDate.Text = dateBitis1.MinDate.ToShortDateString(); using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { foreach (var y in db.Users.Where(k => k.UserRole == 2).Select(k => k.UserName + " " + k.UserSurname)) { cmbProjeLider.Items.Add(y); } } using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { if (Pupdate == true) { dateBaslangic1.MinDate = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.StartDate).FirstOrDefault().Value; txtPrjAd.BackColor = Color.Yellow; txtPrjAd.Text = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.ProjectName).FirstOrDefault(); txtButce.Text = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.Budget).FirstOrDefault().ToString(); lblBasDate.Text = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.StartDate).FirstOrDefault().Value.ToShortDateString(); lblEndDate.Text = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.FinishDate).FirstOrDefault().Value.ToShortDateString(); dateBaslangic1.Value = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.StartDate).FirstOrDefault().Value; dateBitis1.Value = db.Projects.Where(p => p.ProjectID == IDupdate).Select(s => s.FinishDate).FirstOrDefault().Value; txtButce.BackColor = Color.Yellow; cmbProjeLider.SelectedItem = db.Projects.Where(p => p.ProjectID == IDupdate).Select(y => y.Users1.UserName + " " + y.Users1.UserSurname).FirstOrDefault(); } } }
private void btnSil_ItemClick(object sender, ItemClickEventArgs e) { if (treeList1.FocusedNode != null) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { DevExpress.XtraTreeList.Nodes.TreeListNode node = treeList1.FocusedNode; int PID = Convert.ToInt32(node.GetDisplayText(treeList1.VisibleColumns[7])); if (MessageBox.Show(node.GetDisplayText(treeList1.VisibleColumns[0]) + "\nprojesini silmek istiyor musunuz?", "Proje Silme", MessageBoxButtons.YesNo) == DialogResult.Yes) { /*Projects category = db.Projects.Where(c => c.ProjectID == PID).FirstOrDefault(); * db.Projects.DeleteOnSubmit(category); * db.SubmitChanges();*/ Projects p = db.Projects.Single(c => c.ProjectID == PID); db.Projects.Remove(p); db.SaveChanges(); this.Close(); frmMusteri m = new frmMusteri(this.kAd); m.Show(); } else { } } } else { MessageBox.Show("Lütfen Bir Proje Seçiniz.."); } }
private void btnAltSurecEkle_Click(object sender, EventArgs e) { if (lstProsses.SelectedItems.Count != 0) { int seciliid = lstProsses.Items.IndexOf(lstProsses.SelectedItems[0]); string prosesAd = lstProsses.Items[seciliid].Text; int seciliPrjID = Convert.ToInt32(lstProsses.Items.IndexOf(lstProsses.FocusedItem)); int prosesId = Convert.ToInt32(lstProsses.Items[seciliPrjID].SubItems[8].Text); YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1(); if (db.Process.Where(p => p.ProcessID == prosesId).Select(pro => pro.ParentID).FirstOrDefault() != 0) { MessageBox.Show("Seçilen süreç zaten 'alt süreç' olarak sistemde mevcut.."); } else { this.Close(); frmProssesEkle pr = new frmProssesEkle(kID, prosesAd, prjID, prosesId); pr.Show(); } } else { MessageBox.Show("Bir Süreç Seçiniz..!"); } }
public bool kayit(string adi, string soyadi, string kullaniciAdi, string sifre, string kullaniciRolu, DateTime tarih) { using (YazilimYonetimAraciEntities1 smt = new YazilimYonetimAraciEntities1()) { Users user = new Users(); string kAdi = smt.Users.Where(w => w.UserNickname == kullaniciAdi).Select(s => s.UserNickname).FirstOrDefault(); if (kAdi != null) { return(false); } else { user.UserName = adi; user.UserSurname = soyadi; user.UserNickname = kullaniciAdi; user.UserPassword = sifre; user.UserRole = Convert.ToInt32(smt.RoleNames.Where(k => k.RoleName == kullaniciRolu).Select(k => k.RoleNameID).FirstOrDefault()); user.UserCreatedDate = tarih; smt.Users.Add(user); smt.SaveChanges(); //rol kayıt UserRoles ur = new UserRoles(); ur.UserID = user.UsersID; ur.RoleNameID = user.UserRole; smt.UserRoles.Add(ur); smt.SaveChanges(); return(true); } } }
private void btnlLogin_Click(object sender, EventArgs e) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { string currentnick = db.Users.Where(k => k.UserNickname == txtNick.Text && k.UserPassword == txtPass.Text).Select(s => s.UserNickname).FirstOrDefault(); string currentpass = db.Users.Where(k => k.UserNickname == txtNick.Text && k.UserPassword == txtPass.Text).Select(s => s.UserPassword).FirstOrDefault(); if (currentnick == txtNick.Text && currentpass == txtPass.Text) { int rol = db.Users.Where(k => k.UserNickname == txtNick.Text && k.UserPassword == txtPass.Text).Select(s => s.UserRole).FirstOrDefault().Value; if (rol == 1) { frmMusteri musteri = new frmMusteri(txtNick.Text, this); musteri.Show(); } else if (rol == 2) { frmYonetici yonetici = new frmYonetici(txtNick.Text, this); yonetici.Show(); } else if (rol > 2) { Log.Giris(txtNick.Text, db.Users.Where(k => k.UserNickname == txtNick.Text).Select(s => s.UsersID).FirstOrDefault()); frmCalisan calisan = new frmCalisan(txtNick.Text, this); Log.LogEkle("\n<< Çalışan Ekranına Girildi >>\n"); calisan.Show(); } } else { MessageBox.Show("Böyle Bir Kullanıcı Yok"); } } }
private void btnGeri_Click(object sender, EventArgs e) { this.Close(); YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1(); string kad = db.Users.Where(k => k.UsersID == kID).Select(u => u.UserNickname).FirstOrDefault(); frmMusteri MUS = new frmMusteri(kad); MUS.Show(); }
public frmMusteri(string kullaniciAdi) { YazilimYonetimAraciEntities1 DB = new YazilimYonetimAraciEntities1(); kID = DB.Users.Where(k => k.UserNickname == kullaniciAdi).Select(k => k.UsersID).FirstOrDefault(); this.kAd = kullaniciAdi; InitializeComponent(); CreateColumns(treeList1); CreateNodes(treeList1); }
private void Kayit_Load(object sender, EventArgs e) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { foreach (var item in db.RoleNames) { cmbKullaniciRol.Items.Add(item.RoleName); } } }
private void chxAktiflik_CheckedChanged(object sender, EventArgs e) { int seciliPrjID = Convert.ToInt32(lstProsses.Items.IndexOf(lstProsses.FocusedItem)); YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1(); var upd_list = db.Projects.Where(p => p.ProjectID == prjID).FirstOrDefault(); upd_list.isActive = chxAktiflik.Checked; chxAktiflik.ForeColor = upd_list.isActive.Value ? Color.Green : Color.Red; db.SaveChanges(); }
private void ListeDoldur() { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { List <Process> surecler = new List <Process>(); surecler = db.Process.Where(k => k.ProjectID == prjID).ToList(); List <Process> ana_surecler = new List <Process>(); ana_surecler = db.Process.Where(k => k.ProjectID == prjID && k.ParentID == 0).ToList(); chxAktiflik.Checked = db.Projects.Where(p => p.ProjectID == prjID).Select(s => s.isActive.Value).FirstOrDefault(); int gecici = 0; for (int i = 0; i < ana_surecler.Count; i++) { List <Process> alt_surecler = new List <Process>(); alt_surecler = surecler.Where(p => p.ParentID == ana_surecler[i].ProcessID).ToList(); lstProsses.Items.Add(ana_surecler[i].ProcessName); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].StartDate.Value.ToShortDateString()); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].FinishDate.Value.ToShortDateString()); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].Duration.ToString()); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].CompleteRate.ToString()); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].Priority.ToString()); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].Notes); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].Descriptions); lstProsses.Items[i + gecici].SubItems.Add(ana_surecler[i].ProcessID.ToString()); //ALT SÜREÇLER if (alt_surecler != null) { for (int j = 0; j < alt_surecler.Count; j++) { lstProsses.Items.Add(" " + alt_surecler[j].ProcessName); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].StartDate.Value.ToShortDateString()); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].FinishDate.Value.ToShortDateString()); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].Duration.ToString()); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].CompleteRate.ToString()); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].Priority.ToString()); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].Notes); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].Descriptions); lstProsses.Items[i + gecici + 1].SubItems.Add(alt_surecler[j].ProcessID.ToString()); gecici++; } } } } }
public bool girisKontrol(string kullaniciAdi, string sifre) { using (YazilimYonetimAraciEntities1 smt = new YazilimYonetimAraciEntities1()) { string kAdi = smt.Users.Where(w => w.UserNickname == kullaniciAdi).Select(s => s.UserNickname).FirstOrDefault(); string sfr = smt.Users.Where(w => w.UserPassword == sifre).Select(s => s.UserPassword).FirstOrDefault(); if (kAdi == null || sfr == null) { return(false); } else { return(true); } } }
private void btnDegistir_ItemClick(object sender, ItemClickEventArgs e) { if (treeList1.FocusedNode != null) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { DevExpress.XtraTreeList.Nodes.TreeListNode node = treeList1.FocusedNode; int PID = Convert.ToInt32(node.GetDisplayText(treeList1.VisibleColumns[7])); this.Close(); frmMusteriPrjEkle pupdate = new frmMusteriPrjEkle(kID, true, PID); pupdate.ShowDialog(); } } else { MessageBox.Show("Lütfen Bir Proje Seçiniz.."); } }
public frmProssesEkle(int kID, string projead, int pId, int prosesID, bool up) { InitializeComponent(); this.kID = kID; lblProjeAd.Text = projead; this.pId = pId; this.prosesID = prosesID; this.updateP = up; YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1(); txtSrcAd.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.ProcessName).FirstOrDefault().ToString(); txtSrcAd.BackColor = Color.Yellow; lblBasDate.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.StartDate).FirstOrDefault().Value.ToShortDateString(); dateBaslangic1.Value = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.StartDate).FirstOrDefault().Value; lblEndDate.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.FinishDate).FirstOrDefault().Value.ToShortDateString(); dateBitis1.Value = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.FinishDate).FirstOrDefault().Value; txtSure.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.Duration).FirstOrDefault().ToString(); txtSure.BackColor = Color.Yellow; nmbOran.Value = Convert.ToDecimal(db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.CompleteRate).FirstOrDefault()); nmbOran.BackColor = Color.Yellow; cmbOncelik.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.Priority).FirstOrDefault().ToString(); cmbOncelik.BackColor = Color.Yellow; txtNot.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.Notes).FirstOrDefault(); txtNot.BackColor = Color.Yellow; txtAciklama.Text = db.Process.Where(p => p.ProcessID == prosesID).Select(pr => pr.Descriptions).FirstOrDefault(); txtAciklama.BackColor = Color.Yellow; btnSurecEkle.Text = "SÜREÇ GÜNCELLE"; }
public static void Cikis() { cikis = DateTime.Now.ToString(); using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { UserLogDetails ul = new UserLogDetails(); UserLogs u_l = new UserLogs(); ul.LogDate = DateTime.Now; ul.UserLogName = "Giriş: " + giris + Environment.NewLine + " | Çıkış: " + cikis + Environment.NewLine; u_l.UserLogDetails.Add(ul); db.Users.Where(u => u.UsersID == CurrentID).FirstOrDefault().UserLogs.Add(u_l); db.SaveChanges(); } yaz(log); log = ""; CurrentID = 0; giris = ""; cikis = ""; }
private void btnAltSurecDuzenle_Click(object sender, EventArgs e) { if (lstProsses.SelectedItems.Count != 0) { int seciliid = lstProsses.Items.IndexOf(lstProsses.SelectedItems[0]); string prosesAd = lstProsses.Items[seciliid].Text; int seciliPrjID = Convert.ToInt32(lstProsses.Items.IndexOf(lstProsses.FocusedItem)); int prosesId = Convert.ToInt32(lstProsses.Items[seciliPrjID].SubItems[8].Text); YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1(); this.Close(); frmProssesEkle pr = new frmProssesEkle(kID, prosesAd, prjID, prosesId, true); pr.Show(); } else { MessageBox.Show("Bir Süreç Seçiniz..!"); } }
private void btnKaydet_ItemClick(object sender, ItemClickEventArgs e) { if (cmbKontrol()) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { //ANALİZ WorkFollow wfAnaliz = new WorkFollow(); wfAnaliz.WorkFollowDetailsID = 1; wfAnaliz.ProcessID = prosesID; wfAnaliz.StartDate = dtAnaliz.Value; wfAnaliz.FinishDate = dtBAnaliz.Value; wfAnaliz.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbAnaliz.Text).Select(k => k.UsersID).FirstOrDefault(); wfAnaliz.CompleteRate = Convert.ToInt32(nmbAnaliz.Value); db.WorkFollow.Add(wfAnaliz); db.SaveChanges(); //TABLE WorkFollow wfTable = new WorkFollow(); wfTable.WorkFollowDetailsID = 2; wfTable.ProcessID = prosesID; wfTable.StartDate = dtTable.Value; wfTable.FinishDate = dtBTable.Value; wfTable.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbTable.Text).Select(k => k.UsersID).FirstOrDefault(); wfTable.CompleteRate = Convert.ToInt32(nmbTable.Value); db.WorkFollow.Add(wfTable); db.SaveChanges(); //PROC WorkFollow wfProc = new WorkFollow(); wfProc.WorkFollowDetailsID = 3; wfProc.ProcessID = prosesID; wfProc.StartDate = dtProc.Value; wfProc.FinishDate = dtBProc.Value; wfProc.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbProc.Text).Select(k => k.UsersID).FirstOrDefault(); wfProc.CompleteRate = Convert.ToInt32(nmbProc.Value); db.WorkFollow.Add(wfProc); db.SaveChanges(); //DLL LİSTE WorkFollow wfDLLliste = new WorkFollow(); wfDLLliste.WorkFollowDetailsID = 4; wfDLLliste.ProcessID = prosesID; wfDLLliste.StartDate = dtDllL.Value; wfDLLliste.FinishDate = dtBDllL.Value; wfDLLliste.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbDllL.Text).Select(k => k.UsersID).FirstOrDefault(); wfDLLliste.CompleteRate = Convert.ToInt32(nmbDllL.Value); db.WorkFollow.Add(wfDLLliste); db.SaveChanges(); //DLL İŞLEM WorkFollow wfDLLIslem = new WorkFollow(); wfDLLIslem.WorkFollowDetailsID = 5; wfDLLIslem.ProcessID = prosesID; wfDLLIslem.StartDate = dtDllI.Value; wfDLLIslem.FinishDate = dtBDllI.Value; wfDLLIslem.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbDllIs.Text).Select(k => k.UsersID).FirstOrDefault(); wfDLLIslem.CompleteRate = Convert.ToInt32(nmbDllI.Value); db.WorkFollow.Add(wfDLLIslem); db.SaveChanges(); //ARAYÜZ WorkFollow wfArayuz = new WorkFollow(); wfArayuz.WorkFollowDetailsID = 6; wfArayuz.ProcessID = prosesID; wfArayuz.StartDate = dtArayuz.Value; wfArayuz.FinishDate = dtBArayuz.Value; wfArayuz.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbArayuz.Text).Select(k => k.UsersID).FirstOrDefault(); wfArayuz.CompleteRate = Convert.ToInt32(nmbArayuz.Value); db.WorkFollow.Add(wfArayuz); db.SaveChanges(); //TEST1 WorkFollow wfTest_1 = new WorkFollow(); wfTest_1.WorkFollowDetailsID = 7; wfTest_1.ProcessID = prosesID; wfTest_1.StartDate = dtT1.Value; wfTest_1.FinishDate = dtBT1.Value; wfTest_1.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbT1.Text).Select(k => k.UsersID).FirstOrDefault(); wfTest_1.CompleteRate = Convert.ToInt32(nmbT1.Value); db.WorkFollow.Add(wfTest_1); db.SaveChanges(); //TEST2 WorkFollow wfTest_2 = new WorkFollow(); wfTest_2.WorkFollowDetailsID = 8; wfTest_2.ProcessID = prosesID; wfTest_2.StartDate = dtT2.Value; wfTest_2.FinishDate = dtBT2.Value; wfTest_2.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbT2.Text).Select(k => k.UsersID).FirstOrDefault(); wfTest_2.CompleteRate = Convert.ToInt32(nmbT2.Value); db.WorkFollow.Add(wfTest_2); db.SaveChanges(); //TEST3 WorkFollow wfTest_3 = new WorkFollow(); wfTest_3.WorkFollowDetailsID = 9; wfTest_3.ProcessID = prosesID; wfTest_3.StartDate = dtT3.Value; wfTest_3.FinishDate = dtBT3.Value; wfTest_3.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbT3.Text).Select(k => k.UsersID).FirstOrDefault(); wfTest_3.CompleteRate = Convert.ToInt32(nmbT3.Value); db.WorkFollow.Add(wfTest_3); db.SaveChanges(); //TEST4 WorkFollow wfTest_4 = new WorkFollow(); wfTest_4.WorkFollowDetailsID = 10; wfTest_4.ProcessID = prosesID; wfTest_4.StartDate = dtT4.Value; wfTest_4.FinishDate = dtBT4.Value; wfTest_4.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbT4.Text).Select(k => k.UsersID).FirstOrDefault(); wfTest_4.CompleteRate = Convert.ToInt32(nmbT4.Value); db.WorkFollow.Add(wfTest_4); db.SaveChanges(); //TEST5 WorkFollow wfTest_5 = new WorkFollow(); wfTest_5.WorkFollowDetailsID = 11; wfTest_5.ProcessID = prosesID; wfTest_5.StartDate = dtT5.Value; wfTest_5.FinishDate = dtBT5.Value; wfTest_5.UserID = db.Users.Where(k => k.UserName + " " + k.UserSurname + " - " + db.RoleNames.Where(r => r.RoleNameID == k.UserRole).Select(ro => ro.RoleName).FirstOrDefault() == cmbT5.Text).Select(k => k.UsersID).FirstOrDefault(); wfTest_5.CompleteRate = Convert.ToInt32(nmbT5.Value); db.WorkFollow.Add(wfTest_5); db.SaveChanges(); MessageBox.Show("Kaydedildi..."); } } else { MessageBox.Show("Lütfen Kişileri Boş Bırakmayın..."); } }
private void btnProjeEkle_Click(object sender, EventArgs e) { if (Pupdate) { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { var currentuser = db.Users.Where(k => k.UsersID == kID).Select(k => k.UserName + " " + k.UserSurname).FirstOrDefault(); if (TxtKontrol()) { Projects prj = db.Projects.Where(p => p.ProjectID == IDupdate).FirstOrDefault(); if (prj.Users1.UserName + " " + prj.Users1.UserSurname == cmbProjeLider.Text) { var currentprs = prj.Process; prj.Process = currentprs; } prj.ProjectName = txtPrjAd.Text; prj.Budget = Convert.ToDecimal(txtButce.Text); prj.isActive = false; prj.CreateUserID = kID; prj.ProjectUserID = db.Users.Where(k => k.UserName + " " + k.UserSurname == cmbProjeLider.Text).Select(k => k.UsersID).FirstOrDefault(); prj.StartDate = Convert.ToDateTime(lblBasDate.Text); prj.FinishDate = Convert.ToDateTime(lblEndDate.Text); db.SaveChanges(); MessageBox.Show("Projeniz Başarıyla Güncellendi..\n" + "Proje Adı: " + prj.ProjectName + "\nMüşteri: " + currentuser.ToString() + "\nProje Yöneticisi: " + db.Users.Where(y => y.UsersID == prj.ProjectUserID).Select(k => k.UserName + " " + k.UserSurname).FirstOrDefault()); } else { MessageBox.Show("Boş Alanlar Mevcut..!"); } } } else { using (YazilimYonetimAraciEntities1 db = new YazilimYonetimAraciEntities1()) { var currentuser = db.Users.Where(k => k.UsersID == kID).Select(k => k.UserName + " " + k.UserSurname).FirstOrDefault(); if (TxtKontrol()) { Projects prj = new Projects(); prj.ProjectName = txtPrjAd.Text; prj.Budget = Convert.ToDecimal(String.Format("{0:c}", txtButce.Text)); prj.isActive = false; prj.CreateUserID = kID; prj.ProjectUserID = db.Users.Where(k => k.UserName + " " + k.UserSurname == cmbProjeLider.Text).Select(k => k.UsersID).FirstOrDefault(); prj.StartDate = Convert.ToDateTime(lblBasDate.Text); prj.FinishDate = Convert.ToDateTime(lblEndDate.Text); db.Projects.Add(prj); db.SaveChanges(); MessageBox.Show("İsteğiniz Başarıyla Eklendi..\n" + "Proje Adı: " + prj.ProjectName + "\nMüşteri: " + currentuser.ToString() + "\nProje Yöneticisi: " + db.Users.Where(y => y.UsersID == prj.ProjectUserID).Select(k => k.UserName + " " + k.UserSurname).FirstOrDefault()); } else { MessageBox.Show("Boş Alanlar Mevcut..!"); } } } }