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