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