public bool AddNewEmployeeMaster(FormViewParameter Parameter, DataTable dtQualification)
{
IGRSS.DataAccessLayer.Employee.EmployeeMasterRow row = (IGRSS.DataAccessLayer.Employee.EmployeeMasterRow)Parameter.Values;
DataTable dt = IgrssAdapters.EmployeeMaster.SelectEmployeeDetailsByEmpNo(row.EmployeeNo);
if (dt.Rows.Count == 0)
{
Guid EmployeeId = Guid.NewGuid();
string curUser = Thread.CurrentPrincipal.Identity.Name;
try
{
IgrssAdapters.EmployeeMaster.InsertEmployeeMaster(EmployeeId,
row.EmployeeNo,
row.FirstName,
row.MiddleName,
row.PostalAddress,
row.PermanentAddress,
row.DateOfBirth,
row.FatherName,
row.Height,
row.VisibleMarks,
row.OfficeID,
row.DepartmentID,
row.DesignationID,
row.Salary,
row.Allowances,
row.StartDate,
curUser,
DateTime.Now);
foreach (DataRow drQualifications in dtQualification.Rows)
{
IgrssAdapters.EmployeeQualifications.InsertEmployeeQualification(Guid.NewGuid(), EmployeeId, (Guid)drQualifications["QualificationID"], (string)drQualifications["Details"], curUser, DateTime.Now);
}
}
catch (Exception ex)
{
if (ExceptionPolicy.HandleException(ex, "DAL"))
{
throw;
}
}
return(true);
}
else
{
return(false);
}
}
public bool UpdateEmployeeMaster(Guid EmployeeID, FormViewParameter Parameters, DataTable QualificationDetails)
{
string curUser = Thread.CurrentPrincipal.Identity.Name;
try
{
IGRSS.DataAccessLayer.Employee.EmployeeMasterRow row = (IGRSS.DataAccessLayer.Employee.EmployeeMasterRow)Parameters.Values;
IgrssAdapters.EmployeeMaster.UpdateEmployeeMaster(EmployeeID,
row.EmployeeNo,
row.FirstName,
row.MiddleName,
row.PostalAddress,
row.PermanentAddress,
row.DateOfBirth,
row.FatherName,
row.Height,
row.VisibleMarks,
row.OfficeID,
row.DepartmentID,
row.DesignationID,
row.Salary,
row.Allowances,
row.StartDate,
row.EndDate,
curUser,
DateTime.Now);
IgrssAdapters.EmployeeQualifications.DeleteEmployeeQualification(EmployeeID);
foreach (DataRow drQualifications in QualificationDetails.Rows)
{
IgrssAdapters.EmployeeQualifications.InsertEmployeeQualification((Guid)drQualifications["EmployeeQualiID"], EmployeeID, (Guid)drQualifications["QualificationID"], "", curUser, DateTime.Now);
}
}
catch (Exception ex)
{
if (ExceptionPolicy.HandleException(ex, "DAL"))
{
throw;
}
}
return(true);
}
