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 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 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 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();
}
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 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..!");
}
}
}
}
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...");
}
}