internal int UpdateEmployee(tbl_EmployeeInfo atbl_EmployeeInfo, string EID)
{
tbl_EmployeeInfo objtbl_EmployeeInfo = _context.tbl_EmployeeInfo.First(x => x.EID == EID);
objtbl_EmployeeInfo.EmployeeName = atbl_EmployeeInfo.EmployeeName;
objtbl_EmployeeInfo.Office_Id = atbl_EmployeeInfo.Office_Id;
objtbl_EmployeeInfo.Department_Id = atbl_EmployeeInfo.Department_Id;
_context.SaveChanges();
return(1);
}
protected void btnSave_Click(object sender, EventArgs e)
{
tbl_EmployeeInfo atbl_EmployeeInfo = new tbl_EmployeeInfo();
atbl_EmployeeInfo.EID = txtEID.Text;
atbl_EmployeeInfo.EmployeeName = txtEmployeeName.Text;
atbl_EmployeeInfo.Office_Id = Convert.ToInt16(ddlOfficeName.SelectedValue);
atbl_EmployeeInfo.Department_Id = Convert.ToInt16(ddlDepartmentName.SelectedValue);
int count = (from emp in context.tbl_EmployeeInfo
where emp.EID == atbl_EmployeeInfo.EID
select emp.EID).Count();
if (btnSave.Text == "Save")
{
if (count > 0)
{
lblMessage.Visible = true;
lblMessage.Text = "E-ID already exists!";
return;
}
aEmployeeSetup_BLL.SaveEmployee(atbl_EmployeeInfo);
//context.tbl_EmployeeInfo.Add(atbl_EmployeeInfo); //Add object into DBset
//context.SaveChanges(); // call SaveChanges method to save into database
lblMessage.Visible = true;
lblMessage.Text = "Data Save Successfully";
}
else
{
aEmployeeSetup_BLL.UpdateEmployee(atbl_EmployeeInfo, txtEID.Text);
lblMessage.Visible = true;
lblMessage.Text = "Data Update Successfully";
btnCancel.Visible = false;
//btnSave.Text = "Save";
}
Clearform();
GetAllEmployeeDetails();
}
internal int UpdateEmployee(tbl_EmployeeInfo atbl_EmployeeInfo, string EID)
{
return(objEmployeeSetup_DAL.UpdateEmployee(atbl_EmployeeInfo, EID));
}
internal int SaveEmployee(tbl_EmployeeInfo atbl_EmployeeInfo)
{
return(objEmployeeSetup_DAL.SaveEmployee(atbl_EmployeeInfo));
}
internal int SaveEmployee(tbl_EmployeeInfo atbl_EmployeeInfo)
{
_context.tbl_EmployeeInfo.Add(atbl_EmployeeInfo);
_context.SaveChanges();
return(1);
}
