public void updateEmployee(AllEmployeeDetails Emp)
{
var emp = _dbcontext.AllEmployeeDetails.Where(e => e.EmployeeID == Emp.EmployeeID).FirstOrDefault();
emp.FirstName = Emp.FirstName;
emp.FullName = Emp.FullName;
emp.Address = Emp.Address;
emp.Email = Emp.Email;
emp.PersonalEmailId = Emp.PersonalEmailId;
emp.Mobile = Convert.ToInt32(Emp.Mobile);
emp.PhoneNo = Convert.ToInt32(Emp.PhoneNo);
emp.EmployeeCode = Convert.ToInt32(Emp.EmployeeCode);
emp.DOB = Emp.DOB;
emp.JoiningDate = Emp.JoiningDate;
emp.Gender = Emp.Gender;
emp.ReportingManager = Emp.ReportingManager;
emp.JobId = Convert.ToInt32(Emp.JobId);
emp.RoleId = Convert.ToInt32(Emp.RoleId);
emp.DepartmentId = Convert.ToInt32(Emp.DepartmentId);
emp.UserName = Emp.UserName;
//emp.EMP_GENDER = Emp.EMP_GENDER;
// var entry = _dbcontext.Entry(Emp);
//entry.CurrentValues.SetValues(Emp);
_dbcontext.SaveChanges();
}
protected void btnsave_Click(object sender, EventArgs e)
{
//getdepartmentId
employeeRepository = new EmployeeRepository();
var departmentList = employeeRepository.getAllDepartment();
var jobRoleList = employeeRepository.getAlljobDescription();
var departmentid = departmentList.Where(d => d.DEP_NAME == ddlDepartmentList.SelectedItem.ToString()).Select(d => d.DEP_ID).FirstOrDefault();
var jobid = jobRoleList.Where(j => j.JOB_ROLE == ddlJobRole.SelectedItem.ToString()).Select(j => j.JOB_ID).FirstOrDefault();
var reportingManagerList = employeeRepository.getmanager();
var reportingManagerId = reportingManagerList.Where(r => r.FullName == ddlReportingManager.SelectedItem.ToString()).Select(r => r.EmployeeID).FirstOrDefault();
var rolelist = employeeRepository.getallrole();
var roleid = rolelist.Where(r => r.RoleName == ddlRoleList.SelectedItem.ToString()).Select(r => r.RoleId).FirstOrDefault();
//getjobid
AllEmployeeDetails objEmployee = new AllEmployeeDetails();
objEmployee.DepartmentId = Convert.ToInt32(departmentid);
objEmployee.JobId = Convert.ToInt32(jobid);
objEmployee.FirstName = txtname.Text;
objEmployee.LastName = txtSurname.Text;
objEmployee.FullName = txtname.Text + " " + txtSurname.Text;
objEmployee.Address = txtaddress.Text;
objEmployee.Email = txtemail.Text;
objEmployee.PersonalEmailId = txtpersonalemail.Text;
objEmployee.Mobile = Convert.ToInt32(txtmobile.Text);
objEmployee.PhoneNo = Convert.ToInt32(txtphone.Text);
objEmployee.EmployeeCode = Convert.ToInt32(txtempcode.Text);
objEmployee.DOB = Convert.ToDateTime(txtDOB.Text);
objEmployee.JoiningDate = Convert.ToDateTime(txtJoiningDate.Text);
objEmployee.Gender = ddlGender.SelectedValue;
objEmployee.ReportingManager = Convert.ToInt32(reportingManagerId);
objEmployee.UserName = txtusername.Text;
objEmployee.RoleId = Convert.ToInt32(roleid);
if (btnsave.Text == "Save")
{
employees.InsertIntoEmployee(objEmployee);
Response.Redirect("EmployeeList.aspx");
}
else
{
int EmployeeID = 0;
if (!String.IsNullOrEmpty(Request.QueryString["EMP_ID"].ToString()))
{
EmployeeID = Convert.ToInt32(Request.QueryString["EMP_ID"]);
}
objEmployee.EmployeeID = EmployeeID;
employees.updateEmployee(objEmployee);
Response.Redirect("EmployeeList.aspx");
}
}
protected void viewEmployee(int EmployeeID)
{
AllEmployeeDetails objemployee = employees.getEmployee(EmployeeID);
// Label1.Text = objemployee.EMP_ID;
lblName.Text = objemployee.FirstName;
lblFullName.Text = objemployee.FullName;
lblAddress.Text = objemployee.Address;
lblEmail.Text = objemployee.Email;
lblPersonalEmail.Text = objemployee.PersonalEmailId;
lblMobileNumber.Text = Convert.ToString(objemployee.Mobile);
lblGender.Text = objemployee.Gender;
lblDOB.Text = Convert.ToString(objemployee.DOB);
lblJoiningDate.Text = Convert.ToString(objemployee.JoiningDate);
lblCode.Text = Convert.ToString(objemployee.EmployeeCode);
}
protected void showEmployee(int EmployeeID)
{
AllEmployeeDetails objEmployee = employees.getEmployee(EmployeeID);
txtname.Text = objEmployee.FirstName;
// txtfullname.Text = objEmployee.FullName;
txtaddress.Text = objEmployee.Address;
txtemail.Text = objEmployee.Email;
txtpersonalemail.Text = objEmployee.PersonalEmailId;
txtmobile.Text = Convert.ToString(objEmployee.Mobile);
txtphone.Text = Convert.ToString(objEmployee.PhoneNo);
txtempcode.Text = Convert.ToString(objEmployee.EmployeeCode);
txtDOB.Text = objEmployee.DOB.ToString();
txtJoiningDate.Text = objEmployee.JoiningDate.ToString();
ddlGender.SelectedValue = objEmployee.Gender;
}
public void InsertIntoEmployee(AllEmployeeDetails Emp)
{
_dbcontext.AllEmployeeDetails.Add(Emp);
_dbcontext.SaveChanges();
}
