protected void rpDepartmentList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Update") { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); VW_FIRMDEPARTMENT department = db.VW_FIRMDEPARTMENT.SingleOrDefault(t => t.ID == id); RECID = department.ID; hdnDepartmentID.Value = e.CommandArgument.ToString(); txtUpdateFirm.Text = department.FIRMNAME; txtUpdateBranch.Text = department.FIRMBRANCHNAME; txtUpdateDeparment.Text = department.NAME; } ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true); upModalUpdate.Update(); } else if (e.CommandName == "Delete")//Eğer buton Delete butonu ise bunu yapacak. { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); FIRMDEPARTMENT department = db.FIRMDEPARTMENT.SingleOrDefault(t => t.ID == id); //SinglorDefault tek veri çekmek için kulladığımız deyim //FIRMBRANCH test = (from t in db.FIRMBRANCH where t.ID == id select t).SingleOrDefault(); db.FIRMDEPARTMENT.Remove(department); //silmek için kullandın removeyi db.SaveChanges(); FillDepartment(); UpdatePanel.Update(); } } }
//Buraya Kadar Firmaları seçtikten sonra Şubeleri Daha Sonra Bölümleri Seçmemizi Sağladık protected void rpWorkingList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Update") { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); VW_FIRMDEPARTMENTMEMBER departmentMember = db.VW_FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == id); RECID = departmentMember.ID; hdnDepartmentID.Value = e.CommandArgument.ToString(); lblFirmUpdate.Text = departmentMember.FIRMNAME; lblPersonel.Text = departmentMember.FULLNAME; lblBranchUpdate.Text = departmentMember.FIRMBRANCHNAME; FillDrp(DrpDepartmentUpdate, db.VW_FIRMDEPARTMENT.Where(t => t.FIRMBRANCHID == departmentMember.FIRMBRANCHID).ToList(), "ID", "NAME", "Seçiniz"); DrpDepartmentUpdate.SelectedValue = departmentMember.FIRMDEPARTMENTID.ToString();//Drop seçileceği zaman; seçilmeden önceki hangi bölüme ait ise o bölüm seçili olarak gelmesini sağlıyor. departmentMember.ISACTIVE = dropmdlcd.SelectedValue == "0"; } ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true); upModalUpdate.Update(); } else if (e.CommandName == "Delete")//Eğer buton Delete butonu ise bunu yapacak. { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); FIRMDEPARTMENTMEMBER department = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.MEMBERID == id); //SinglorDefault tek veri çekmek için kulladığımız deyim //FIRMBRANCH test = (from t in db.FIRMBRANCH where t.ID == id select t).SingleOrDefault(); db.FIRMDEPARTMENTMEMBER.Remove(department); //silmek için kullandın removeyi db.SaveChanges(); FillDepartment(); UpdatePanel.Update(); } } }
protected void btnAddDepartment_Click(object sender, EventArgs e) { if (ValidateDepartment()) { using (db = new novartz_stajyer1Entities()) { FIRMDEPARTMENT rec = null; if (DEPARTMENTID != Guid.Empty) { rec = db.FIRMDEPARTMENT.SingleOrDefault(t => t.ID == DEPARTMENTID); } else { rec = new FIRMDEPARTMENT(); rec.ID = Guid.NewGuid(); } rec.FIRMID = RECID; rec.FIRMBRANCHID = Guid.Parse(drpDepBranch.SelectedValue); rec.NAME = txtDepName.Text; if (DEPARTMENTID == Guid.Empty) { db.FIRMDEPARTMENT.Add(rec); } MessageBox("İşleminiz Başarılı"); db.SaveChanges(); InitPage(false); upDepartment.Update(); } } }
public void DepartmentRegistration(string name)// Bölüm eklemek için Oluşturduğumuz fonksiyon. { FIRMDEPARTMENT rec = null; using (db = new novartz_stajyer1Entities()) { rec = new FIRMDEPARTMENT(); rec.ID = Guid.NewGuid(); rec.NAME = name; rec.FIRMID = Guid.Parse(drpFirms.SelectedValue); if (!dvBranch.Visible || drpBranch.SelectedValue == "0") { rec.FIRMBRANCHID = null; } else { rec.FIRMBRANCHID = Guid.Parse(drpBranch.SelectedValue); } db.FIRMDEPARTMENT.Add(rec); db.SaveChanges(); FillDepartment(); upDepartmentList.Update(); }; MessageBox("İşleminiz Başarılı"); }
protected void btnSaveFirmDepartmentMember_Click(object sender, EventArgs e)//Yeni çalışan ekle kısmını yaptım kayıt yapıyor seçilen kısıma.. { if (ValidateRecord()) { Guid id = Guid.NewGuid(); MEMBER member = null; using (db = new novartz_stajyer1Entities()) { member = new MEMBER { NAME = txtmdlName.Text, SURNAME = txtmdlSurname.Text, LOGINNAME = txtmdlMail.Text, BIRDDATE = Convert.ToDateTime(txtmdlBirtday.Text), PHONE = txtmdlPhone.Text, PASWORD = txtmdlPassword.Text, GENDER = Convert.ToBoolean(drpmdlGender.SelectedValue == "1"),//Bayan ise true olarak çalışıyor TYPEMEMBERID = Convert.ToByte(drpmdltypmember.SelectedValue), CANLOGIN = true, ID = id }; db.MEMBER.Add(member); db.SaveChanges(); }; if (drpmdltypmember.SelectedValue == "3") { FIRMRESPONSIBLE rsp = null; using (db = new novartz_stajyer1Entities()) { Guid id3 = Guid.NewGuid(); rsp = new FIRMRESPONSIBLE { ID = id3, FIRMID = Guid.Parse(DrpFirm.SelectedValue), MEMBERID = id }; db.FIRMRESPONSIBLE.Add(rsp); db.SaveChanges(); } } FIRMDEPARTMENTMEMBER rec = null; using (db = new novartz_stajyer1Entities()) { Guid id2 = Guid.NewGuid(); rec = new FIRMDEPARTMENTMEMBER { ID = id2, FIRMDEPARTMENTID = Guid.Parse(DrpDepartment.SelectedValue), ISACTIVE = dropmdlcd.SelectedValue == "1", MEMBERID = id }; db.FIRMDEPARTMENTMEMBER.Add(rec); db.SaveChanges(); }; MessageBox("İşleminiz Başarılı"); } }
protected void rpFirmBranchList_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "Update": if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { using (db = new novartz_stajyer1Entities()) { Guid selectedBranchID = Guid.Parse(e.CommandArgument.ToString()); lblBranchIsUpdate.Text = "Güncelleyiniz"; FIRMBRANCH rec = db.FIRMBRANCH.SingleOrDefault(t => t.ID == selectedBranchID); if (rec != null) { FillDrp(drpBranchC, db.CITY.ToList(), "ID", "NAME"); txtBranchName.Text = rec.NAME; txtBranchAddr.Text = rec.ADRESS; txtBranchPho.Text = rec.PHONE; txtBranchEm.Text = rec.EMAIL; if (rec.CITYID.HasValue) { FillDrp(drpBranchCD, db.CITYDISTRICT.Where(t => t.CITYID == rec.CITYID).ToList(), "ID", "NAME", "Seçiniz"); drpBranchC.SelectedValue = rec.CITYID.ToString(); } if (rec.CITYDISTRICTID.HasValue) { drpBranchCD.SelectedValue = rec.CITYDISTRICTID.ToString(); } BRANCHID = selectedBranchID; ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenBranchModal", "$('#mdlNewBranch').modal('show');", true); upMdlNewBranch.Update(); } } } break; case "Delete": using (db = new novartz_stajyer1Entities()) { Guid selectedBranchID = Guid.Parse(e.CommandArgument.ToString()); FIRMBRANCH rec = db.FIRMBRANCH.SingleOrDefault(t => t.ID == selectedBranchID); if (rec != null) { db.FIRMBRANCH.Remove(rec); db.SaveChanges(); InitPage(false); upMdlNewBranch.Update(); } } break; } }
protected void rpBranchList_ItemCommand(object source, RepeaterCommandEventArgs e)//Repaetr içindeki Butonları temsil eder... { if (e.CommandName == "Update") { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); VW_FIRMBRANCH branch = db.VW_FIRMBRANCH.SingleOrDefault(t => t.ID == id); RECID = branch.ID; hdnBranchID.Value = e.CommandArgument.ToString(); txtBranchName.Text = branch.NAME; txtBranchPhone.Text = branch.PHONE; txtBranchAdress.Text = branch.ADRESS; txtBranchMail.Text = branch.EMAIL; if (branch.CITYID.HasValue) { drpBranchCity.SelectedValue = branch.CITYID.ToString(); drpBranchCity_SelectedIndexChanged(null, null); if (branch.CITYDISTRICTID.HasValue) { drpBranchDiscrit.SelectedValue = branch.CITYDISTRICTID.ToString(); } } } ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true); } else if (e.CommandName == "Delete")//Eğer buton Delete butonu ise bunu yapacak. { using (db = new novartz_stajyer1Entities()) { Guid id = Guid.Parse(e.CommandArgument.ToString()); FIRMBRANCH branch = db.FIRMBRANCH.SingleOrDefault(t => t.ID == id); //SinglorDefault tek veri çekmek için kulladığımız deyim //FIRMBRANCH test = (from t in db.FIRMBRANCH where t.ID == id select t).SingleOrDefault(); db.FIRMBRANCH.Remove(branch); //silmek için kullandın removeyi db.SaveChanges(); FillBranch(); UpdatePanel.Update(); } } //else if (e.CommandName == "Delete")//Eğer buton Delete butonu ise bunu yapacak. //{ // using (db = new novartz_stajyer1Entities()) // { // Guid id = Guid.Parse(e.CommandArgument.ToString()); // FIRMBRANCH branch = db.FIRMBRANCH.SingleOrDefault(t => t.ID == id);//SinglorDefault tek veri çekmek için kulladığımız deyim // //FIRMBRANCH test = (from t in db.FIRMBRANCH where t.ID == id select t).SingleOrDefault(); // db.FIRMBRANCH.Remove(branch);//silmek için kullandın removeyi // db.SaveChanges(); // FillBranch(); // UpdatePanel.Update(); // } //} }
protected void btnUpdateSaveServer_Click(object sender, EventArgs e) { using (db = new novartz_stajyer1Entities()) { FIRMDEPARTMENT rec = db.FIRMDEPARTMENT.SingleOrDefault(t => t.ID == RECID); rec.NAME = txtUpdateDeparment.Text; db.SaveChanges(); FillDepartment(); UpdatePanel.Update(); } }
protected void btnUpdateSaveServer_Click(object sender, EventArgs e)//Güncelleme Bölümünde kaydetme işlemini yaptık... { using (db = new novartz_stajyer1Entities()) { FIRMDEPARTMENTMEMBER rec = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == RECID); rec.FIRMDEPARTMENTID = Guid.Parse(DrpDepartmentUpdate.SelectedValue); rec.ISACTIVE = Convert.ToBoolean(DrpcdUpdate.SelectedValue == "1"); db.SaveChanges(); FillDepartment(); UpdatePanel.Update(); } }
protected void btnAddBranch_Click(object sender, EventArgs e) { if (ValidateBranch()) { using (db = new novartz_stajyer1Entities()) { FIRMBRANCH rec = null; if (BRANCHID != Guid.Empty) { rec = db.FIRMBRANCH.SingleOrDefault(t => t.ID == BRANCHID); } else { rec = new FIRMBRANCH(); rec.ID = Guid.NewGuid(); rec.FIRMID = RECID; } rec.NAME = txtBranchName.Text; rec.ADRESS = txtBranchAddr.Text; rec.PHONE = txtBranchPho.Text; rec.EMAIL = txtBranchEm.Text; if (drpBranchC.SelectedValue == "0") { rec.CITYID = null; } else { rec.CITYID = Convert.ToByte(drpBranchC.SelectedValue); } if (drpBranchCD.SelectedValue == "0") { rec.CITYDISTRICTID = null; } else { rec.CITYDISTRICTID = Convert.ToInt16(drpBranchCD.SelectedValue); } if (BRANCHID == Guid.Empty) { db.FIRMBRANCH.Add(rec); } MessageBox("İşleminiz Başarılı"); db.SaveChanges(); InitPage(false); upBranch.Update(); } } }
public void BranchRegistration(string name)//******// { FIRMBRANCH rec = null; using (db = new novartz_stajyer1Entities()) { rec = new FIRMBRANCH { NAME = name, FIRMID = Guid.Parse(drpFirm.SelectedValue), ID = Guid.NewGuid() }; db.FIRMBRANCH.Add(rec); db.SaveChanges(); }; MessageBox("İşleminiz Başarılı"); FillBranch(); }
protected void btnAddDepartmentMember_Click(object sender, EventArgs e) { if (ValidateDepartmentMember()) { Guid id = Guid.NewGuid(); MEMBER member = null; using (db = new novartz_stajyer1Entities()) { member = new MEMBER { NAME = txtDepMemberName.Text, SURNAME = txtDepMemberSurname.Text, LOGINNAME = txtDepMemberEmail.Text, BIRDDATE = Convert.ToDateTime(txtDepMemberBirthday.Text), PHONE = txtDepMemberTelephone.Text, PASWORD = txtDepMemberPassword.Text, CANLOGIN = true, GENDER = drpDepMemberGender.SelectedValue == "1", TYPEMEMBERID = 2, ID = id, }; db.MEMBER.Add(member); db.SaveChanges(); }; FIRMDEPARTMENTMEMBER rec = null; using (db = new novartz_stajyer1Entities()) { Guid id2 = Guid.NewGuid(); rec = new FIRMDEPARTMENTMEMBER { ID = id2, FIRMDEPARTMENTID = Guid.Parse(drpDepMemberDepartment.SelectedValue), ISACTIVE = drpDepMemberStatus.SelectedValue == "1", MEMBERID = id }; db.FIRMDEPARTMENTMEMBER.Add(rec); db.SaveChanges(); InitPage(false); upDepartmentMember.Update(); }; MessageBox("İşleminiz Başarılı"); } }
protected void btnNewRandevu_Click(object sender, EventArgs e) { if (ValidateNewReservation()) { RESERVATION rec = new RESERVATION(); using (db = new novartz_stajyer1Entities()) { rec.ID = Guid.NewGuid(); rec.MEMBERID = TEMPRESERVATION.MEMBERID; rec.TYPERESERVATIONSTATUSID = TEMPRESERVATION.TYPERESERVATIONSTATUSID; rec.FIRMDEPARTMENTMEMBERID = TEMPRESERVATION.FIRMDEPARTMENTMEMBERID; rec.DATE = TEMPRESERVATION.DATE; db.RESERVATION.Add(rec); db.SaveChanges(); TEMPRESERVATION = new RESERVATION(); } } }
protected void rpFirmDepartmentList_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "Update": if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { using (db = new novartz_stajyer1Entities()) { Guid selectedDepartmentID = Guid.Parse(e.CommandArgument.ToString()); lblDepartmentIsUpdate.Text = "Güncelleyiniz"; FIRMDEPARTMENT rec = db.FIRMDEPARTMENT.SingleOrDefault(t => t.ID == selectedDepartmentID); if (rec != null) { drpDepBranch.SelectedValue = rec.FIRMBRANCHID.ToString(); txtDepName.Text = rec.NAME; DEPARTMENTID = selectedDepartmentID; ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenDepartmentModal", "$('#mdlNewDepartment').modal('show');", true); upDepartment.Update(); } } } break; case "Delete": using (db = new novartz_stajyer1Entities()) { Guid selectedDepartmentID = Guid.Parse(e.CommandArgument.ToString()); FIRMDEPARTMENT rec = db.FIRMDEPARTMENT.SingleOrDefault(t => t.ID == selectedDepartmentID); if (rec != null) { db.FIRMDEPARTMENT.Remove(rec); db.SaveChanges(); InitPage(false); upDepartment.Update(); } } break; } }
protected void btnSave_Click(object sender, EventArgs e) { using (db = new novartz_stajyer1Entities()) { FIRM rec = db.FIRM.SingleOrDefault(t => t.ID == RECID); rec.NAME = txtFirmName.Text; rec.DESCRIPTION = txtFirmOwner.Text; rec.TYPESEKTORID = Convert.ToByte(drpFirmSector.SelectedValue); rec.ADRESS = txtFirmAddress.Text; rec.PHONE = txtFirmPhone.Text; rec.EMAIL = txtFirmEmail.Text; rec.CITYID = Convert.ToByte(drpFirmCity.SelectedValue); //byte gönderdiğin için onu byte çevirmesi lazım rec.CITYDISTRICTID = Convert.ToInt16(drpFirmCityDistrict.SelectedValue); // citydistrictid smallint olduğu için toınt16 ya çevirdik bytedan büyük7 //db.FIRM.Add(rec); bu fonksiyonu eklersen de yeni kayıt ekleme yapar db.SaveChanges(); } InitPage(false); }
public void MemberRegistion(string name, string lastname, string phone, string mail, string password) { MEMBER rec = null; using (db = new novartz_stajyer1Entities()) { rec = new MEMBER { NAME = name, SURNAME = lastname, PHONE = phone, LOGINNAME = mail, PASWORD = password, TYPEMEMBERID = 1, // todo: typemember drp den seçilecek ID = Guid.NewGuid() }; db.MEMBER.Add(rec); db.SaveChanges(); }; }
protected void btnUpdateSaveServer_Click(object sender, EventArgs e)//Bilgileri Güncelleme işlemini yapıyoruz Burada.... { if (ValidateRecord()) { using (db = new novartz_stajyer1Entities()) { FIRMBRANCH branch = db.FIRMBRANCH.SingleOrDefault(t => t.ID == RECID); branch.NAME = txtBranchName.Text; branch.PHONE = txtBranchPhone.Text; branch.EMAIL = txtBranchMail.Text; branch.ADRESS = txtBranchAdress.Text; if (drpBranchCity.SelectedValue != "0") { branch.CITYID = Convert.ToByte(drpBranchCity.SelectedValue); } else { branch.CITYID = null; } if (drpBranchCity.SelectedValue != "0") { branch.CITYDISTRICTID = Convert.ToInt16(drpBranchDiscrit.SelectedValue); } else { branch.CITYDISTRICTID = null; } db.SaveChanges(); FillBranch(); UpdatePanel.Update(); } MessageBox("Güncellendi Bilgileriniz..."); } else { ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true); } }
public void FirmRegistion(string Firmname, string Firmowner, string sector, string city, string citydistrict, string address, string phone, string mail) { FIRM rec = null; using (db = new novartz_stajyer1Entities()) { rec = new FIRM { ID = Guid.NewGuid(), NAME = Firmname, DESCRIPTION = Firmowner, PHONE = phone, EMAIL = mail, TYPESEKTORID = Convert.ToByte(sector), CITYID = Convert.ToByte(city), CITYDISTRICTID = Convert.ToInt16(citydistrict), ADRESS = address }; db.FIRM.Add(rec); db.SaveChanges(); }; }
protected void rpFirmDepMemberList_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "Update": if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { using (db = new novartz_stajyer1Entities()) { Guid selectedMemberID = Guid.Parse(e.CommandArgument.ToString()); lblDepartmentMemberIsUpdate.Text = "Güncelleyiniz"; VW_FIRMDEPARTMENTMEMBER rec = db.VW_FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == selectedMemberID); if (rec != null) { FillDrp(drpDepMemberBranch, db.FIRMBRANCH.Where(d => d.FIRMID == RECID).ToList(), "ID", "NAME", "Şubesizler"); if (rec.FIRMBRANCHID.HasValue) { drpDepMemberBranch.SelectedValue = rec.FIRMBRANCHID.Value.ToString(); } drpDepMemberBranch_SelectedIndexChanged(null, null); drpDepMemberDepartment.SelectedValue = rec.FIRMDEPARTMENTID.ToString(); txtDepMemberTelephone.Text = rec.PHONE; txtDepMemberName.Text = rec.NAME; txtDepMemberSurname.Text = rec.SURNAME; txtDepMemberBirthday.Text = rec.BIRDDATE.ToString(); if (rec.GENDER.HasValue) { drpDepMemberGender.SelectedValue = rec.GENDER.Value ? "1" : "0"; } drpDepMemberStatus.SelectedValue = rec.ISACTIVE ? "1" : "0"; drpDepMemEmail.Text = rec.LOGINNAME; DEPARTMENTMEMBERID = selectedMemberID; ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenDepartmentMemberModal", "$('#mdlNewDepartmentMember').modal('show');", true); upMdlNewDepartmentMember.Update(); } } } break; case "Delete": // OLMADI BU KISIMM!!! using (db = new novartz_stajyer1Entities()) { Guid selectedMemberID = Guid.Parse(e.CommandArgument.ToString()); FIRMDEPARTMENTMEMBER rec = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == selectedMemberID); if (rec != null) { //hata kontrolü yap 547 db.FIRMDEPARTMENTMEMBER.Remove(rec); db.SaveChanges(); // InitPage(false); // upMdlNewDepartmentMember.Update(); } MEMBER mem = db.MEMBER.SingleOrDefault(t => t.ID == rec.MEMBERID); if (mem != null) { db.MEMBER.Remove(mem); db.SaveChanges(); InitPage(false); upDepartmentMember.Update(); } } break; } }