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