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