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