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