private void FillDepartment()//Firma Seçtiğimiz yer Firma seçmemizi sağlıyor.
{
using (db = new novartz_stajyer1Entities())
{
if (drpFirms.SelectedValue != "0")
{
Guid id = Guid.Empty;
if (dvBranch.Visible && drpBranch.SelectedValue != "0")
{
id = Guid.Parse(drpBranch.SelectedValue);
rpDepartmentList.DataSource = db.VW_FIRMDEPARTMENT.Where(t => t.FIRMBRANCHID == id).ToList();
}
else
{
id = Guid.Parse(drpFirms.SelectedValue);
rpDepartmentList.DataSource = db.VW_FIRMDEPARTMENT.Where(t => t.FIRMID == id).ToList();
}
rpDepartmentList.DataBind();
}
else
{
MessageBox("Firma seçiniz!");
}
}
}
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 Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (IsAdmin || IsFirmResponsible)
{
using (db = new novartz_stajyer1Entities())
{
if (IsFirmResponsible)
{
List <VW_FIRM> list;
list = db.VW_FIRM.Where(t => t.FIRMRESPONSIBLEID == CURRENTMEMBER.ID).ToList();
FillDrp(drpFirm, list, "ID", "NAME", "Seçiniz");
}
else
{
FillDrp(drpFirm, db.FIRM.ToList(), "ID", "NAME", "Seçiniz");
}
FillDrp(drpBranchCity, db.CITY.ToList(), "ID", "NAME", "Seçiniz");
FillDrp(drpBranchSektor, db.TYPESEKTOR.ToList(), "ID", "NAME", "Seçiniz");
drpBranchDiscrit.Items.Insert(0, new ListItem("Seçiniz..", "0"));
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
if (!Page.IsPostBack)
{
if (IsValidQueryString("ID"))
{
Guid ID = Guid.Empty;
if (Guid.TryParse(Request.QueryString["ID"], out ID))
{
RECID = ID;
}
}
if (RECID != Guid.Empty)
{
VW_MEMBER rec = db.VW_MEMBER.Where(a => a.ID == RECID).FirstOrDefault();
txtUserName.Text = rec.NAME;
txtUserSurname.Text = rec.SURNAME;
txtUserEmail.Text = rec.LOGINNAME;
txtUserPhone.Text = rec.PHONE;
txtUserPassword.Text = rec.PASWORD;
}
}
}
}
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 DrpFirm_SelectedIndexChanged(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
Guid firmID = Guid.Parse(DrpFirm.SelectedValue);
List <FIRMBRANCH> branchList = db.FIRMBRANCH.Where(t => t.FIRMID == firmID).ToList();
//List<FIRMDEPARTMENT> departmentlist = db.FIRMDEPARTMENT.Where(t => t.FIRMBRANCHID == firmID).ToList();
List <FIRMDEPARTMENT> DepartmentList = db.FIRMDEPARTMENT.Where(t => t.FIRMID == firmID).ToList();
if (branchList.Count > 0)//Şubeleri varsa
{
FillDrp(DrpBranch, branchList, "ID", "NAME", "Seçiniz");
dvDocList.Visible = true;
//if (departmentlist.Count > 0)//Şubelerin bölümleri varsa
//{
// FillDrp(DrpDepartment, departmentlist, "ID", "NAME", "Seçiniz");
// dvDoclistDeparment.Visible = true;
//}
//else//Şubelerin Bölümleri yoksa
//{
// dvDoclistDeparment.Visible = false;
//}
UpdatePanel.Update();
}
else// şubeleri yoksa
{
//FillDrp(DrpDepartment, DepartmentList, "ID", "NAME", "Seçiniz");
//dvDoclistDeparment.Visible = true;
//dvDocList.Visible = false;
//UpdatePanel.Update();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (IsValidQueryString("ID"))
{
Guid ID = Guid.Empty;
if (Guid.TryParse(Request.QueryString["ID"], out ID))
{
using (db = new novartz_stajyer1Entities())
{
FillDrp(DrpDepartment, db.FIRMDEPARTMENT.Where(t => t.FIRMID == ID).ToList(), "ID", "NAME", "Seçiniz");
FIRM firm = db.FIRM.SingleOrDefault(t => t.ID == ID);
RECID = firm.ID;
lblNAME.Text = firm.NAME;
TEMPRESERVATION.MEMBERID = CURRENTMEMBER.ID;
TEMPRESERVATION.TYPERESERVATIONSTATUSID = (byte)1; // Yeni randevu
}
}
}
else
{
Response.Redirect("/Firm/FirmList.aspx");
}
}
}
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();
}
}
}
private void FillDepartment()//Firma Seçtiğimizde Listelememizi Sağlıyor.repater içini sağlıyor..
{
using (db = new novartz_stajyer1Entities())
{
if (DrpFirm.SelectedValue != "0")
{
Guid id = Guid.Empty;
if (dvDocList.Visible && DrpBranch.SelectedValue != "0")
{
id = Guid.Parse(DrpBranch.SelectedValue);
rpWorkingList.DataSource = db.VW_FIRMDEPARTMENTMEMBER.Where(t => t.FIRMBRANCHID == id).ToList();
rpWorkingList.DataSource = db.VW_FIRMDEPARTMENTMEMBER.Where(t => t.FIRMBRANCHID == id).ToList();
}
else if (dvDocList.Visible && DrpBranch.SelectedValue == "0" || DrpDepartment.SelectedValue == "0")
{
id = Guid.Parse(DrpFirm.SelectedValue);
rpWorkingList.DataSource = db.VW_FIRMDEPARTMENTMEMBER.Where(t => t.FIRMID == id).ToList();
}
else
{
id = Guid.Parse(DrpDepartment.SelectedValue);
rpWorkingList.DataSource = db.VW_FIRMDEPARTMENTMEMBER.Where(t => t.FIRMDEPARTMENTID == id).ToList();
}
rpWorkingList.DataBind();
}
else
{
MessageBox("Firma seçiniz!");
UpdatePanel.Update();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (IsAdmin || IsFirmResponsible)
{
using (db = new novartz_stajyer1Entities())
{
if (IsFirmResponsible)
{
List <VW_FIRM> list;
list = db.VW_FIRM.Where(t => t.FIRMRESPONSIBLEID == CURRENTMEMBER.ID).ToList();
FillDrp(DrpFirm, list, "ID", "NAME", "Seçiniz");
}
else
{
FillDrp(DrpFirm, db.FIRM.ToList(), "ID", "NAME", "Seçiniz");
}
dvDocList.Visible = false;
dvDoclistDeparment.Visible = false;
UpdatePanel.Update();
}
}
}
}
//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 btnSaveFirmDepartmentMember_Click(object sender, EventArgs e)//Yeni çalışan ekle kısmını yaptım kayıt yapıyor seçilen kısıma..
{
if (ValidateRecord())
{
Guid id = Guid.NewGuid();
MEMBER member = null;
using (db = new novartz_stajyer1Entities())
{
member = new MEMBER
{
NAME = txtmdlName.Text,
SURNAME = txtmdlSurname.Text,
LOGINNAME = txtmdlMail.Text,
BIRDDATE = Convert.ToDateTime(txtmdlBirtday.Text),
PHONE = txtmdlPhone.Text,
PASWORD = txtmdlPassword.Text,
GENDER = Convert.ToBoolean(drpmdlGender.SelectedValue == "1"),//Bayan ise true olarak çalışıyor
TYPEMEMBERID = Convert.ToByte(drpmdltypmember.SelectedValue),
CANLOGIN = true,
ID = id
};
db.MEMBER.Add(member);
db.SaveChanges();
};
if (drpmdltypmember.SelectedValue == "3")
{
FIRMRESPONSIBLE rsp = null;
using (db = new novartz_stajyer1Entities())
{
Guid id3 = Guid.NewGuid();
rsp = new FIRMRESPONSIBLE
{
ID = id3,
FIRMID = Guid.Parse(DrpFirm.SelectedValue),
MEMBERID = id
};
db.FIRMRESPONSIBLE.Add(rsp);
db.SaveChanges();
}
}
FIRMDEPARTMENTMEMBER rec = null;
using (db = new novartz_stajyer1Entities())
{
Guid id2 = Guid.NewGuid();
rec = new FIRMDEPARTMENTMEMBER
{
ID = id2,
FIRMDEPARTMENTID = Guid.Parse(DrpDepartment.SelectedValue),
ISACTIVE = dropmdlcd.SelectedValue == "1",
MEMBERID = id
};
db.FIRMDEPARTMENTMEMBER.Add(rec);
db.SaveChanges();
};
MessageBox("İşleminiz Başarılı");
}
}
protected void drpBranchC_SelectedIndexChanged(object sender, EventArgs e) //bu kısma ihtiyacım var mı????
{
using (db = new novartz_stajyer1Entities())
{
byte cityID = Convert.ToByte(drpBranchC.SelectedValue);
FillDrp(drpBranchCD, db.CITYDISTRICT.Where(t => t.CITYID == cityID).ToList(), "ID", "NAME", "Seçiniz..");
}
}
protected void drpBranchCity_SelectedIndexChanged(object sender, EventArgs e)//İl-ilçe Birbirlerini Getirmesini Sağlar...
{
using (db = new novartz_stajyer1Entities())
{
byte cityID = Convert.ToByte(drpBranchCity.SelectedValue);
FillDrp(drpBranchDiscrit, db.CITYDISTRICT.Where(t => t.CITYID == cityID).ToList(), "ID", "NAME", "Seçiniz");
ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
rpFirmList.DataSource = db.FIRM.ToList();
rpFirmList.DataBind();
}
}
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;
}
}
public MEMBER GetMemberByLoginname(string loginname, string password)
{
MEMBER rec = null;
using (db = new novartz_stajyer1Entities())
{
rec = db.MEMBER.Where(a => a.LOGINNAME == loginname && a.PASWORD == password).FirstOrDefault();
}
return(rec);
}
protected void btnNewDepartment_Click(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
lblDepartmentIsUpdate.Text = "Giriniz";
FillDrp(drpDepBranch, db.FIRMBRANCH.Where(d => d.FIRMID == RECID).ToList(), "ID", "NAME", "Seçiniz..");
ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenDepartmentModal", "$('#mdlNewDepartment').modal('show');", true);
upMdlNewDepartment.Update();
}
}
public bool MEMBERControl(string mail)
{
MEMBER sonuc = null;
using (db = new novartz_stajyer1Entities())
{
sonuc = db.MEMBER.SingleOrDefault(u => u.LOGINNAME == mail);
}
return(sonuc != null);
}
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 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 btnNewDepartmentMember_Click(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
lblDepartmentMemberIsUpdate.Text = "Giriniz";
FillDrp(drpDepMemberBranch, db.FIRMBRANCH.Where(d => d.FIRMID == RECID).ToList(), "ID", "NAME", "Şubesizler");
drpDepMemberBranch_SelectedIndexChanged(null, null);
ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenDepartmentMemberModal", "$('#mdlNewDepartmentMember').modal('show');", true);
upMdlNewDepartmentMember.Update();
}
}
protected void btnUpdateSaveServer_Click(object sender, EventArgs e)//Güncelleme Bölümünde kaydetme işlemini yaptık...
{
using (db = new novartz_stajyer1Entities())
{
FIRMDEPARTMENTMEMBER rec = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == RECID);
rec.FIRMDEPARTMENTID = Guid.Parse(DrpDepartmentUpdate.SelectedValue);
rec.ISACTIVE = Convert.ToBoolean(DrpcdUpdate.SelectedValue == "1");
db.SaveChanges();
FillDepartment();
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();
}
}
}
protected void drpDepMemberBranch_SelectedIndexChanged(object sender, EventArgs e)
{
Guid?branchID = null;
if (drpDepMemberBranch.SelectedValue != "0")
{
branchID = Guid.Parse(drpDepMemberBranch.SelectedValue);
}
using (db = new novartz_stajyer1Entities())
{
FillDrp(drpDepMemberDepartment, db.FIRMDEPARTMENT.Where(d => d.FIRMBRANCHID == branchID).ToList(), "ID", "NAME", "Seçiniz..");
}
}
protected void drpFirmCity_SelectedIndexChanged(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
byte cityID = Convert.ToByte(drpFirmCity.SelectedValue);
drpFirmCityDistrict.DataSource = db.CITYDISTRICT.Where(t => t.CITYID == cityID).ToList();
drpFirmCityDistrict.DataValueField = "ID";
drpFirmCityDistrict.DataTextField = "NAME";
drpFirmCityDistrict.DataBind();
drpFirmCityDistrict.Items.Insert(0, new ListItem("Seçiniz..", "0"));
upFirmCityDistrict.Update();
}
}
protected void Modalbutonn_Click(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
if (drpFirm.SelectedValue == "0")
{
MessageBox("Firma seçiniz!");
}
else
{
lblFirmName.Text = drpFirm.SelectedItem.Text; //Drop Listlerde Name ksımlarını yazdırmamızı Sağlar.
ScriptManager.RegisterStartupScript(this, GetType(), "", "$('#modal-table').modal('show');", true);
}
}
}
protected void btnNewBranch_Click(object sender, EventArgs e)
{
using (db = new novartz_stajyer1Entities())
{
drpBranchCD.Items.Clear();
txtBranchName.Text = string.Empty;
txtBranchAddr.Text = string.Empty;
txtBranchPho.Text = string.Empty;
txtBranchEm.Text = string.Empty;
lblBranchIsUpdate.Text = "Giriniz";
FillDrp(drpBranchC, db.CITY.ToList(), "ID", "NAME", "Seçiniz..");
ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenBranchModal", "$('#mdlNewBranch').modal('show');", true);
upMdlNewBranch.Update();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Reservastion-user"] != null) //Cookie işlemi yapmak için nesnein null olup olmadığına bakıyoruz.
{
string cookieData = Request.Cookies["Reservastion-user"].Value; //Cookie değerini stringe dönüştürdük. Value olarak aldık.
Guid cookieID = Guid.Parse(cookieData); //stringi Guid ettik.
MEMBER rec = null;
using (db = new novartz_stajyer1Entities())
{
rec = db.MEMBER.Where(a => a.ID == cookieID).FirstOrDefault();//tablodan ID çektik sayfaya yönlendirdik.
CURRENTMEMBER = rec;
Response.Redirect("/Default.aspx");
}
}
}
private void FillBranch()//Firma Seçtiğimiz yer Firma seçmemizi sağlıyor.
{
using (db = new novartz_stajyer1Entities())
{
if (drpFirm.SelectedValue != "0")
{
Guid id = Guid.Parse(drpFirm.SelectedValue);
rpBranchList.DataSource = db.VW_FIRMBRANCH.Where(t => t.FIRMID == id).ToList();
rpBranchList.DataBind();
}
else
{
MessageBox("Firma seçiniz!");
}
}
}
