public int DeleteEmployeeServiceDetails(EmployeeServiceDetails _EmployeeServiceDetails)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("EmployeeServiceDetailsID", SqlDbType.Int, _EmployeeServiceDetails.EmployeeServiceDetailsID));
SqlCmd.Parameters.Add(GetParameter("ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_EmployeeServiceDetails_Delete";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <EmployeeServiceDetails> SetEmployeeServiceDetails(DataTable DtTable)
{
try
{
List <EmployeeServiceDetails> _EmployeeList = new List <EmployeeServiceDetails>();
foreach (DataRow DtRow in DtTable.Rows)
{
EmployeeServiceDetails EmployeeServiceDetails = new EmployeeServiceDetails();
EmployeeServiceDetails.EmployeeServiceDetailsID = int.Parse(DtRow["EmployeeServiceDetailsID"].ToString());
EmployeeServiceDetails.Employee.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
EmployeeServiceDetails.Employee.EmployeeName = DtRow["EmployeeName"].ToString();
EmployeeServiceDetails.Employee.DepartmentID = int.Parse(DtRow["DepartmentID"].ToString());
EmployeeServiceDetails.Employee.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
EmployeeServiceDetails.Employee.DesignationID = int.Parse(DtRow["DesignationID"].ToString());
EmployeeServiceDetails.Employee.DesignationDescription = DtRow["DesignationDescription"].ToString();
if (DtRow["PostingDate"].ToString() + "" != "")
{
EmployeeServiceDetails.PostingDate = DateTime.Parse(DtRow["PostingDate"].ToString());;
}
//EmployeeServiceDetails.PostingOffice = MicroOfficeIntegration.GetMicroOfficesById(int.Parse(DtRow["OfficeID"].ToString()));
EmployeeServiceDetails.PostingOffice.OfficeID = int.Parse(DtRow["PostingOfficeID"].ToString());
EmployeeServiceDetails.PostingOffice.OfficeName = DtRow["OfficeName"].ToString();
EmployeeServiceDetails.ReferenceLetterNumber = DtRow["ReferenceLetterNumber"].ToString();
EmployeeServiceDetails.Remarks = DtRow["Remarks"].ToString();
if (DtRow["ReportingToEffectiveDateFrom"].ToString() + "" != "")
{
EmployeeServiceDetails.ReportingToEffectiveDateFrom = DateTime.Parse(DtRow["ReportingToEffectiveDateFrom"].ToString());
}
if (DtRow["ReportingToEmployeeID"].ToString() + "" != "")
{
EmployeeServiceDetails.ReportingToEmployee = EmployeeIntegration.GetEmployeeDetailsByID(int.Parse(DtRow["ReportingToEmployeeID"].ToString()));
}
EmployeeServiceDetails.ServiceStatus = DtRow["ServiceStatus"].ToString();
EmployeeServiceDetails.ServiceType = DtRow["ServiceType"].ToString();
EmployeeServiceDetails.IsActive = Boolean.Parse(DtRow["IsActive"].ToString());
EmployeeServiceDetails.IsDeleted = Boolean.Parse(DtRow["IsDeleted"].ToString());
_EmployeeList.Add(EmployeeServiceDetails);
}
return(_EmployeeList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int DeleteEmployeeServiceDetais(EmployeeServiceDetails _EmployeeServiceDetails)
{
try
{
return(EmployeeServiceDetailsIntegration.DeleteEmployeeServiceDetails(_EmployeeServiceDetails));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int UpdateEmployeeServiceDetails(EmployeeServiceDetails _EmployeeServiceDetails)
{
try
{
return(EmployeeServiceDetailsDataAccess.GetInstance.UpdateEmployeeServiceDetails(_EmployeeServiceDetails));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int UpdateEmployeeServiceDetails(EmployeeServiceDetails _EmployeeServiceDetails)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("EmployeeServiceDetailsID", SqlDbType.Int, _EmployeeServiceDetails.EmployeeServiceDetailsID));
SqlCmd.Parameters.Add(GetParameter("EmployeeID", SqlDbType.Int, _EmployeeServiceDetails.Employee.EmployeeID));
SqlCmd.Parameters.Add(GetParameter("PostingDate", SqlDbType.DateTime, DateTime.Parse(_EmployeeServiceDetails.PostingDate.ToString()).ToString("yyyy/MM/dd")));
SqlCmd.Parameters.Add(GetParameter("PostingOfficeID", SqlDbType.Int, _EmployeeServiceDetails.PostingOffice.OfficeID));
SqlCmd.Parameters.Add(GetParameter("DesignationID", SqlDbType.Int, _EmployeeServiceDetails.Designation.DesignationID));
SqlCmd.Parameters.Add(GetParameter("DepartmentID", SqlDbType.Int, _EmployeeServiceDetails.Deparment.DepartmentID));
SqlCmd.Parameters.Add(GetParameter("ServiceType", SqlDbType.VarChar, _EmployeeServiceDetails.ServiceType));
SqlCmd.Parameters.Add(GetParameter("ServiceStatusChangeRequestDate", SqlDbType.DateTime, DateTime.Parse(_EmployeeServiceDetails.ServiceStatusChangeRequestDate.ToString()).ToString("yyyy/MM/dd")));
SqlCmd.Parameters.Add(GetParameter("ServiceStatusLastWorkingDate", SqlDbType.DateTime, DateTime.Parse(_EmployeeServiceDetails.ServiceStatusLastWorkingDate.ToString()).ToString("yyyy/MM/dd")));
SqlCmd.Parameters.Add(GetParameter("ServiceStatus", SqlDbType.VarChar, _EmployeeServiceDetails.ServiceStatus));
SqlCmd.Parameters.Add(GetParameter("ReferenceLetterNumber", SqlDbType.VarChar, _EmployeeServiceDetails.ReferenceLetterNumber));
SqlCmd.Parameters.Add(GetParameter("Remarks", SqlDbType.VarChar, _EmployeeServiceDetails.Remarks));
if (_EmployeeServiceDetails.ReportingToEmployee.EmployeeID > -1)
{
SqlCmd.Parameters.Add(GetParameter("ReportingToEmployeeID", SqlDbType.Int, _EmployeeServiceDetails.ReportingToEmployee.EmployeeID));
//SqlCmd.Parameters.Add(GetParameter("ReportingToEffectiveDateFrom", SqlDbType.Date, _EmployeeServiceDetails.ReportingToEffectiveDateFrom));
SqlCmd.Parameters.Add(GetParameter("ReportingToEffectiveDateFrom", SqlDbType.Date, DateTime.Today));
}
SqlCmd.Parameters.Add(GetParameter("ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_EmployeeServiceDetails_Update";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
