public TelContact FindByid(int id) { TelContact result = null; using (PersonsDBEntities DC = conn.GetContext()) { //-- SELECT * FROM vPhoneList WHERE PhobeID = phoneID result = (from r in DC.TelContacts where r.ID == id select r).FirstOrDefault(); } return(result); }
public TelContact FindBytelnumber(string tel) { TelContact result = null; using (PersonsDBEntities DC = conn.GetContext()) { //-- SELECT * FROM vPhoneList WHERE PhobeID = phoneID result = (from r in DC.TelContacts where r.TelNumber == tel select r).FirstOrDefault(); } return(result); }
protected void Button1_Click1(object sender, EventArgs e) { if (lblid.Text.Length > 0) { try { TelContactsRepository telir = new TelContactsRepository(); if ((TextBox2.Text.Length > 0) && (TextBox2.Text != lbltelnumber.Text)) { if (telir.FindBytelnumber(TextBox2.Text) != null) { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errRepeatetelTitle, Color.Red); return; } } TelContactsRepository ecrir = new TelContactsRepository(); TelContact tel = new TelContact(); tel.UserTypeID = DropDownList1.SelectedItem.Value.ToInt(); // tel.UserID = ddluserid.SelectedValue.ToInt(); tel.UserID = Session["newuserid"].ToString().ToInt(); tel.TelTypeID = Session["newteltype"].ToString().ToInt(); // tel.TelTypeID = ddlTeltype.SelectedValue.ToInt(); tel.ID = lblid.Text.ToInt(); if ((TextBox2.Text.Length > 0) && (TextBox2.Text != lbltelnumber.Text)) { tel.TelNumber = TextBox2.Text.Trim(); } ecrir.SavetelContact(tel); clearform(); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgUpdateSuccessfull, Color.Green); } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errUpdateFailed, Color.Red); } } }
public void SavetelContact(TelContact TelContact) { using (PersonsDBEntities DC = conn.GetContext()) { if (TelContact.ID > 0) { //==== UPDATE ==== DC.TelContacts.Attach(TelContact); DC.Entry(TelContact).State = EntityState.Modified; } else { //==== INSERT ==== DC.TelContacts.Add(TelContact); } DC.SaveChanges(); } }
protected void Button1_Click(object sender, EventArgs e) { TelContactsRepository tel = new TelContactsRepository(); if (tel.FindBytelnumber(TextBox1.Text) != null) { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errDuplicateUsername, Color.Red); return; } bool successfullCreateAccount = true; try { TelContact newcontact = new TelContact(); newcontact.UserTypeID = lblusertypeid.Text.ToInt(); newcontact.UserID = lbluserid.Text.ToInt(); newcontact.TelTypeID = ddlteltype.SelectedValue.ToInt(); newcontact.TelNumber = TextBox1.Text.Trim(); TelContactsRepository ecrir = new TelContactsRepository(); ecrir.SavetelContact(newcontact); ClearForm(); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgAddSuccessfull, Color.Green); } catch (System.Exception err) { successfullCreateAccount = false; PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errAddFailed, Color.Red); } if (successfullCreateAccount) { // ClearForm(); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgAddSuccessfull, Color.Green); } }
public void loadform() { try { TelContactsRepository ecrir = new TelContactsRepository(); TelContact Tel = ecrir.FindByid(Session["ID"].ToString().ToInt()); lblid.Text = Tel.ID.ToString(); lbluserid.Text = Session["UserID"].ToString(); lblusertypeid.Text = Session["UserTypeID"].ToString(); Session["TelType"] = Tel.TelTypeID.ToString(); lbltelnumber.Text = Tel.TelNumber.ToString(); Session["newTeltype"] = Tel.TelTypeID.ToString(); switch (Session["UserTypeID"].ToString()) { case "1": { VStudentsRepository vstdir = new VStudentsRepository(); VStudent std = vstdir.FindByid(Session["UserID"].ToString().ToInt()); Label9.Text = "دانشجو" + ":" + std.FirstName + " " + std.LastName; } break; case "2": { VLecturersRepository vlec = new VLecturersRepository(); VLecturer lec = vlec.FindByid(Session["UserID"].ToString().ToInt()); Label9.Text = "استاد" + ":" + lec.FirstName + " " + lec.LastName; } break; case "3": { VEmployeesRepository vlec = new VEmployeesRepository(); VEmployee emp = vlec.FindByid(Session["UserID"].ToString().ToInt()); Label9.Text = "کارمند" + ":" + emp.FirstName + " " + emp.LastName; } break; } TelTypesRepository etir = new TelTypesRepository(); TelType Teltype = etir.FindByid(Session["TelType"].ToString().ToInt()); if (Teltype != null) { lblTeltype.Text = Teltype.TelTypeTitle.ToString(); // Label7.Text = std.FirstName.ToString() + " " + std.LastName.ToString(); } else { Redirector.Goto(Redirector.PageName.errorpage); } TelTypesRepository etr = new TelTypesRepository(); DataTable dt2 = etr.GetAllTelType(); ddlteltype.Items.Clear(); foreach (DataRow dr in dt2.Rows) { ddlteltype.Items.Add(new ListItem(dr["TelTypeTitle"].ToString(), dr["TelTypeID"].ToString())); } } catch { Redirector.Goto(Redirector.PageName.errorpage); } }
public void LoadData(string id) { try { TelContactsRepository ecrir = new TelContactsRepository(); TelContact Tel = ecrir.FindByid(id.ToInt()); lblid.Text = Tel.ID.ToString(); Session["UserID"] = Tel.UserID.ToString(); Session["TelTypeID"] = Tel.TelTypeID.ToString(); Session["UserType"] = Tel.UserTypeID.ToString(); lbltelnumber.Text = Tel.TelNumber; Session["newuserid"] = Tel.UserID.ToString(); Session["newteltype"] = Tel.TelTypeID.ToString(); VStudentsRepository vstdir = new VStudentsRepository(); VStudent std = vstdir.FindByid(Session["UserID"].ToString().ToInt()); if (std != null) { Label7.Text = std.FirstName.ToString() + " " + std.LastName.ToString(); } else { Redirector.Goto(Redirector.PageName.errorpage); } TelTypesRepository etir = new TelTypesRepository(); TelType Teltype = etir.FindByid(Session["TelTypeID"].ToString().ToInt()); if (Teltype != null) { lblTeltype.Text = Teltype.TelTypeTitle.ToString(); // Label7.Text = std.FirstName.ToString() + " " + std.LastName.ToString(); } else { Redirector.Goto(Redirector.PageName.errorpage); } TelTypesRepository etr = new TelTypesRepository(); DataTable dt2 = etr.GetAllTelType(); ddlTeltype.Items.Clear(); foreach (DataRow dr in dt2.Rows) { ddlTeltype.Items.Add(new ListItem(dr["TelTypeTitle"].ToString(), dr["TelTypeID"].ToString())); } switch ((Session["UserType"].ToString())) { case "1": { DropDownList1.SelectedValue = "1"; VStudentsRepository vstd = new VStudentsRepository(); DataTable dtstd = vstd.GetAllstd(); ddluserid.Items.Clear(); foreach (DataRow dr in dtstd.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["StudentID"].ToString())); } } break; case "2": { DropDownList1.SelectedValue = "2"; VLecturersRepository vlrir = new VLecturersRepository(); DataTable dtlec = vlrir.GetAllLec(); ddluserid.Items.Clear(); foreach (DataRow dr in dtlec.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["LecturerID"].ToString())); } } break; case "3": { DropDownList1.SelectedValue = "3"; VEmployeesRepository verir = new VEmployeesRepository(); DataTable dtemp = verir.GetAllEmp(); ddluserid.Items.Clear(); foreach (DataRow dr in dtemp.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["EmployeeID"].ToString())); } } break; } } catch { Redirector.Goto(Redirector.PageName.errorpage); } }