//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 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; } }