public static List <LeaveTypeSettings> GetLeaveBalanceByEmployee(int EmployeeID) { try { DataTable _LeaveBalance = LeaveBalanceDataAccess.GetInstance.GetLeaveBalanceByEmployee(EmployeeID); List <LeaveTypeSettings> _LeaveBalanceList = new List <LeaveTypeSettings>(); foreach (DataRow DtRow in _LeaveBalance.Rows) { LeaveTypeSettings _LeaveTypeSettings = new LeaveTypeSettings(); _LeaveTypeSettings.LeaveTypeID = int.Parse(DtRow["LeaveTypeID"].ToString()); _LeaveTypeSettings.LeaveTypeDescription = DtRow["LeaveTypeDescription"].ToString(); _LeaveTypeSettings.LeaveTypeAlias = DtRow["LeaveTypeAlias"].ToString(); _LeaveTypeSettings.TotalNumberOfLeavesElligibleToAvail = int.Parse(DtRow["TotalNumberOfLeavesElligibleToAvail"].ToString()); _LeaveTypeSettings.NumberOfConsecutiveDaysAllowed = int.Parse(DtRow["NumberOfConsecutiveDaysAllowed"].ToString()); _LeaveTypeSettings.AccountingYear = DtRow["AccountingYear"].ToString(); _LeaveTypeSettings.Quarter = DtRow["Quarter"].ToString(); _LeaveBalanceList.Add(_LeaveTypeSettings); } return(_LeaveBalanceList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public static int UpdateLeaveTypeSettings(LeaveTypeSettings _LeaveTypeSettings) { try { return(LeaveTypeSettingDataAccess.GetInstance.UpdateLeaveTypeSettings(_LeaveTypeSettings)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int InsertLeaveTypeSettings(LeaveTypeSettings _LeaveTypeSettings) { try { return(LeaveTypeSettingIntegration.InsertLeaveTypeSettings(_LeaveTypeSettings)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public static LeaveTypeSettings SetLeaveTypeSettings(DataRow LeaveTypeSettingsRow) { try { LeaveTypeSettings _LeaveTypeSettings = new LeaveTypeSettings(); if (LeaveTypeSettingsRow != null) { _LeaveTypeSettings.LeaveTypeSettingID = int.Parse(LeaveTypeSettingsRow["LeaveTypeSettingID"].ToString()); _LeaveTypeSettings.LeaveTypeID = int.Parse(LeaveTypeSettingsRow["LeaveTypeID"].ToString()); _LeaveTypeSettings.LeaveTypeDescription = LeaveTypeSettingsRow["LeaveTypeDescription"].ToString(); _LeaveTypeSettings.LeaveTypeAlias = LeaveTypeSettingsRow["LeaveTypeAlias"].ToString(); _LeaveTypeSettings.NumberOfDaysAllowed = int.Parse(LeaveTypeSettingsRow["NumberOfDaysAllowed"].ToString()); _LeaveTypeSettings.NumberOfConsecutiveDaysAllowed = int.Parse(LeaveTypeSettingsRow["NumberOfConsecutiveDaysAllowed"].ToString()); _LeaveTypeSettings.ForGender = LeaveTypeSettingsRow["ForGender"].ToString(); _LeaveTypeSettings.CreditPeriodInMonths = int.Parse(LeaveTypeSettingsRow["CreditPeriodInMonths"].ToString()); _LeaveTypeSettings.MaximumAccumulatedDays = int.Parse(LeaveTypeSettingsRow["MaximumAccumulatedDays"].ToString()); _LeaveTypeSettings.CalculationMode = int.Parse(LeaveTypeSettingsRow["CalculationMode"].ToString()); _LeaveTypeSettings.IsTransferrable = bool.Parse(LeaveTypeSettingsRow["IsTransferrable"].ToString()); _LeaveTypeSettings.IsEncashable = bool.Parse(LeaveTypeSettingsRow["IsEncashable"].ToString()); _LeaveTypeSettings.EffectiveDate = DateTime.Parse(LeaveTypeSettingsRow["EffectiveDateFrom"].ToString()); _LeaveTypeSettings.CreditInterval = LeaveTypeSettingsRow["LeaveCreditInterval"].ToString(); _LeaveTypeSettings.Quarter1 = int.Parse(LeaveTypeSettingsRow["Quarter1"].ToString()); _LeaveTypeSettings.Quarter2 = int.Parse(LeaveTypeSettingsRow["Quarter2"].ToString()); _LeaveTypeSettings.Quarter3 = int.Parse(LeaveTypeSettingsRow["Quarter3"].ToString()); _LeaveTypeSettings.Quarter4 = int.Parse(LeaveTypeSettingsRow["Quarter4"].ToString()); _LeaveTypeSettings.OfficeID = int.Parse(LeaveTypeSettingsRow["OfficeID"].ToString()); _LeaveTypeSettings.OfficeName = LeaveTypeSettingsRow["OfficeName"].ToString(); } else { _LeaveTypeSettings.LeaveTypeSettingID = -1; _LeaveTypeSettings.NumberOfDaysAllowed = 0; _LeaveTypeSettings.NumberOfConsecutiveDaysAllowed = 0; _LeaveTypeSettings.ForGender = "BOTH"; } return(_LeaveTypeSettings); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int UpdateLeaveTypeSettings(LeaveTypeSettings _LeaveTypeSettings) { 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("@LeaveTypeSettingID", SqlDbType.Int, _LeaveTypeSettings.LeaveTypeSettingID)); SqlCmd.Parameters.Add(GetParameter("@LeaveTypeID", SqlDbType.Int, _LeaveTypeSettings.LeaveTypeID)); SqlCmd.Parameters.Add(GetParameter("@NumberOfDaysAllowed", SqlDbType.Int, _LeaveTypeSettings.NumberOfDaysAllowed)); SqlCmd.Parameters.Add(GetParameter("@NumberOfConsecutiveDaysAllowed", SqlDbType.Int, _LeaveTypeSettings.NumberOfConsecutiveDaysAllowed)); SqlCmd.Parameters.Add(GetParameter("@ForGender", SqlDbType.VarChar, _LeaveTypeSettings.ForGender)); SqlCmd.Parameters.Add(GetParameter("@CreditPeriodInMonths", SqlDbType.Int, _LeaveTypeSettings.CreditPeriodInMonths)); SqlCmd.Parameters.Add(GetParameter("@MaximumAccumulatedDays", SqlDbType.Int, _LeaveTypeSettings.MaximumAccumulatedDays)); SqlCmd.Parameters.Add(GetParameter("@CalculationMode", SqlDbType.Int, _LeaveTypeSettings.CalculationMode)); SqlCmd.Parameters.Add(GetParameter("@IsTransferrable", SqlDbType.Bit, _LeaveTypeSettings.IsTransferrable)); SqlCmd.Parameters.Add(GetParameter("@IsEncashable", SqlDbType.Int, _LeaveTypeSettings.IsEncashable)); SqlCmd.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.DateTime, _LeaveTypeSettings.EffectiveDate)); SqlCmd.Parameters.Add(GetParameter("@LeaveCreditInterval", SqlDbType.VarChar, _LeaveTypeSettings.CreditInterval)); SqlCmd.Parameters.Add(GetParameter("@Quarter1", SqlDbType.Int, _LeaveTypeSettings.Quarter1)); SqlCmd.Parameters.Add(GetParameter("@Quarter2", SqlDbType.Int, _LeaveTypeSettings.Quarter2)); SqlCmd.Parameters.Add(GetParameter("@Quarter3", SqlDbType.Int, _LeaveTypeSettings.Quarter3)); SqlCmd.Parameters.Add(GetParameter("@Quarter4", SqlDbType.Int, _LeaveTypeSettings.Quarter4)); SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.CompanyID)); SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, _LeaveTypeSettings.IsActive)); SqlCmd.Parameters.Add(GetParameter("@IsDeleted", SqlDbType.Bit, _LeaveTypeSettings.IsDeleted)); SqlCmd.Parameters.Add(GetParameter("@DateModified", SqlDbType.DateTime, DateTime.Now)); SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); SqlCmd.CommandText = "pHRM_LeaveTypeSettings_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)); } }
public static List <LeaveTypeSettings> GetLeaveTypeSettingsList(string searchText = null, bool showDeleted = false) { try { List <LeaveTypeSettings> LeaveTypeSettingsList = new List <LeaveTypeSettings>(); DataTable LeaveTypeTable = new DataTable(); LeaveTypeTable = LeaveTypeSettingDataAccess.GetInstance.GetLeaveTypeSettingsList(searchText, showDeleted); foreach (DataRow dr in LeaveTypeTable.Rows) { LeaveTypeSettings _LeaveTypeSettings = new LeaveTypeSettings(); _LeaveTypeSettings.LeaveTypeSettingID = int.Parse(dr["LeaveTypeSettingID"].ToString()); _LeaveTypeSettings.LeaveTypeID = int.Parse(dr["LeaveTypeID"].ToString()); _LeaveTypeSettings.LeaveTypeDescription = dr["LeaveTypeDescription"].ToString(); _LeaveTypeSettings.LeaveTypeAlias = dr["LeaveTypeAlias"].ToString(); _LeaveTypeSettings.OfficeID = int.Parse(dr["OfficeID"].ToString()); _LeaveTypeSettings.OfficeName = dr["OfficeName"].ToString(); _LeaveTypeSettings.CreditInterval = dr["LeaveCreditInterval"].ToString(); _LeaveTypeSettings.Quarter1 = int.Parse(dr["Quarter1"].ToString()); _LeaveTypeSettings.Quarter2 = int.Parse(dr["Quarter2"].ToString()); _LeaveTypeSettings.Quarter3 = int.Parse(dr["Quarter3"].ToString()); _LeaveTypeSettings.Quarter4 = int.Parse(dr["Quarter4"].ToString()); _LeaveTypeSettings.IsActive = Boolean.Parse(dr["IsActive"].ToString()); LeaveTypeSettingsList.Add(_LeaveTypeSettings); } return(LeaveTypeSettingsList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }