public void Update(EmpAllItem model)
{
Mapper.CreateMap <EmployeeItem, employee_master>();
employee_master objmaster = DbContext.employee_master.SingleOrDefault(m => m.id == model.EmployeeItem.id);
objmaster = Mapper.Map(model.EmployeeItem, objmaster);
DbContext.SaveChanges();
}
public EmployeeItem GetById(int id)
{
Mapper.CreateMap <employee_master, EmployeeItem>();
employee_master objmaster = DbContext.employee_master.SingleOrDefault(m => m.id == id);
EmployeeItem objmasterp = Mapper.Map <EmployeeItem>(objmaster);
return(objmasterp);
}
public int Insert(EmpAllItem model)
{
try
{
Mapper.CreateMap <EmployeeItem, employee_master>();
employee_master objEmp = Mapper.Map <employee_master>(model.EmployeeItem);
DbContext.employee_master.Add(objEmp);
DbContext.SaveChanges();
int p = DbContext.employee_master.Max(item => item.id);
if (p != 0)
{
//For inserting values in EmployeeRelative table
//model.EmpRelativeItem.EmpId = p;
//model.EmpContactItem.EmpId = p;
//model.EmpPassportItem.EmpId = p;
}
//Mapper.CreateMap<EmpRelativeItem, EmployeeRelative>();
//EmployeeRelative objRelative = Mapper.Map<EmployeeRelative>(model.EmpRelativeItem);
//DbContext.EmployeeRelatives.Add(objRelative);
//DbContext.SaveChanges();
// For inserting values in EmployeeContact table
//Mapper.CreateMap<EmpContactItem, EmployeeContact>();
//EmployeeContact objEmpCont = Mapper.Map<EmployeeContact>(model.EmpContactItem);
//DbContext.EmployeeContacts.Add(objEmpCont);
//DbContext.SaveChanges();
//// For inserting values in EmployeePassport Table
//Mapper.CreateMap<EmpPassportItem, EmployeePassport>();
//EmployeePassport objPassport = Mapper.Map<EmployeePassport>(model.EmpPassportItem);
//DbContext.EmployeePassports.Add(objPassport);
//DbContext.SaveChanges();
return(DbContext.employee_master.Max(item => item.id));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation(
"Class: {0}, Property: {1}, Error: {2}",
validationErrors.Entry.Entity.GetType().FullName,
validationError.PropertyName,
validationError.ErrorMessage);
}
}
return(1);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
DataClassesDataContext rt = new DataClassesDataContext();
employee_master em = new employee_master();
em = rt.employee_masters.Single(employee_master => employee_master.emp_code == Session["emp_code"].ToString() && employee_master.user_password == TextBox61.Text);
if (em.role == null)
{
Response.Write("<script>alert('Entered password is incorrect')</script>");
}
else
{
em.user_password = TextBox62.Text;
Response.Write("<script>alert('password chenged succesfully')</script>");
Panel2_CollapsiblePanelExtender.Collapsed = true;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
clsbusslayer obj = new clsbusslayer();
String role = obj.login(TextBox1.Text, TextBox2.Text);
if (role == "null")
{
Response.Write("<SCRIPT>alert('Username or password Is incorrect')</SCRIPT>");
}
else
{
DataClassesDataContext rt = new DataClassesDataContext();
employee_registration er = new employee_registration();
employee_master em = new employee_master();
em = rt.employee_masters.Single(employee_master => employee_master.username == TextBox1.Text);
Session["emp_code"] = em.emp_code;
er = rt.employee_registrations.Single(employee_registration => employee_registration.employee_code == em.emp_code);
Session["emp_name"] = er.full_name;
switch (role)
{
case "doctor":
Response.Redirect("~/doctor_module/doctor.aspx");
break;
case "admin":
Response.Redirect("~/admin_home.aspx");
break;
case "nurse":
Response.Redirect("~/nurse_module/Default.aspx");
break;
case "pathologist":
Response.Redirect("~/pathology/pathology_home.aspx");
break;
default:
Response.Write("<SCRIPT>alert('Username or password Is incorrect')</SCRIPT>");
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataClassesDataContext rt = new DataClassesDataContext();
employee_master em = new employee_master();
employee_registration er = new employee_registration();
em = rt.employee_masters.Single(employee_master => employee_master.emp_code == Session["emp_code"].ToString());
er = rt.employee_registrations.Single(employee_registration => employee_registration.employee_code == Session["emp_code"].ToString());
DropDownList15.SelectedValue = er.title;
TextBox56.Text = er.full_name;
DropDownList16.SelectedValue = er.department;
DropDownList17.SelectedValue = er.role;
TextBox57.Text = er.mobile_no;
TextBox58.Text = er.email_id;
TextBox59.Text = Convert.ToString(er.date_of_birth);
DropDownList18.SelectedValue = er.gender;
DropDownList19.SelectedValue = er.civil_status;
TextBox60.Text = er.tele_no;
}
protected void Button3_Click(object sender, EventArgs e)
{
DataClassesDataContext rt = new DataClassesDataContext();
employee_master em = new employee_master();
employee_registration er = new employee_registration();
em = rt.employee_masters.Single(employee_master => employee_master.emp_code == Session["emp_code"].ToString());
er = rt.employee_registrations.Single(employee_registration => employee_registration.employee_code == Session["emp_code"].ToString());
er.title = DropDownList15.SelectedValue;
er.full_name = TextBox56.Text;
er.department = DropDownList16.SelectedValue;
er.role = DropDownList17.SelectedValue;
er.mobile_no = TextBox57.Text;
er.email_id = TextBox58.Text;
er.date_of_birth = Convert.ToDateTime(TextBox59.Text);
er.gender = DropDownList18.SelectedValue;
er.civil_status = DropDownList19.SelectedValue;
er.tele_no = TextBox60.Text;
rt.SubmitChanges();
Response.Write("<script>alert('Profile Updated Succesfully')</script>");
}
