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)); } }