public void ListTimesheetDetail(int nEmployeeID, string strBranchCode, DateTime startDate, DateTime endDate)
{
DataSet dsTimesheeDetail = SqlHelperUtils.ExecuteDatasetSP("pr_SelectTimesheetDetail",
new SqlParameter("@inEmployeeID", nEmployeeID),
new SqlParameter("@dtStartDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, startDate),
new SqlParameter("@dtEndDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, endDate));
myDetailTable = dsTimesheeDetail.Tables[1];
AddDetailRowChangeEvent();
}
public void ListTimesheetDetail(int nEmployeeID, DateTime startDate, DateTime endDate, out DataTable timesheetTable,
out DataTable timecardTable)
{
DataSet dsTimesheeDetail = SqlHelperUtils.ExecuteDatasetSP("pr_SelectTimesheetDetail",
new SqlParameter("@inEmployeeID", nEmployeeID),
new SqlParameter("@dtStartDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, startDate),
new SqlParameter("@dtEndDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, endDate));
timesheetTable = dsTimesheeDetail.Tables[0];
timecardTable = dsTimesheeDetail.Tables[1];
}
public DataSet PrintCV(int nCaseID)
{
DataSet myDataSet = SqlHelperUtils.ExecuteDatasetSP("pr_CVPrint", new SqlParameter("@inCaseID", nCaseID));
myDataSet.Tables[0].TableName = PRINTCVTABLENAME;
myDataSet.Tables[1].TableName = PRINTCVACTIONTABLENAME;
myDataSet.Relations.Add("MemoRecipient", myDataSet.Tables[PRINTCVTABLENAME].Columns["nCaseID"],
myDataSet.Tables[PRINTCVACTIONTABLENAME].Columns["nCaseID"], true);
return(myDataSet);
}
public bool CheckDupMobileNo(string strMobileNo)
{
DataSet ContactDataSet = SqlHelperUtils.ExecuteDatasetSP("sp_tblContacts_chkDupMobileNo", new SqlParameter("@strMobileNo", strMobileNo));
bool nStatus = Convert.ToBoolean(ContactDataSet.Tables[0].Rows[0]["nStatus"]);
if (nStatus)
{
return(true);
}
else
{
return(false);
}
}
private void GetLatenessData()
{
SqlParameter paramEmployeeID = new SqlParameter("@inEmployeeID", nEmployeeID);
SqlParameter paramStartDate = new SqlParameter("@ddtStartDate", startDate);
SqlParameter paramEndDate = new SqlParameter("@ddtEndDate", endDate);
myResultDataSet = SqlHelperUtils.ExecuteDatasetSP("pr_SelectLatenessTable", paramEmployeeID, paramStartDate,
paramEndDate);
myResultDataSet.Tables[0].TableName = ROSTERTABLE;
myResultDataSet.Tables[1].TableName = TIMECARDTABLE;
myResultDataSet.Tables[2].TableName = LEAVETABLE;
myResultDataSet.Tables[TIMECARDTABLE].DefaultView.Sort = "dtDate, strBranchCode";
}
public DataSet PrintMemo(int nMemoID)
{
DataSet myDataSet = SqlHelperUtils.ExecuteDatasetSP("pr_MemoPrint", new SqlParameter("@inMemoID", nMemoID));
myDataSet.Tables[0].TableName = PRINTMEMOTABLENAME;
myDataSet.Tables[1].TableName = PRINTRECIPIENTTABLENAME;
myDataSet.Tables[2].TableName = PRINTREPLIESTABLENAME;
myDataSet.Relations.Add("MemoRecipient", myDataSet.Tables[PRINTMEMOTABLENAME].Columns["nMemoID"],
myDataSet.Tables[PRINTRECIPIENTTABLENAME].Columns["nMemoID"], true);
myDataSet.Relations.Add("MemoReplies", myDataSet.Tables[PRINTMEMOTABLENAME].Columns["nMemoID"],
myDataSet.Tables[PRINTREPLIESTABLENAME].Columns["nMemoID"], true);
return(myDataSet);
}
public bool GetMemberNRIC(string strNricfin, string strMobileNo)
{
DataSet ContactDataSet = SqlHelperUtils.ExecuteDatasetSP("sp_tblContacts_VerifyNRICMobileNo",
new SqlParameter("@strNRICFIN", strNricfin),
new SqlParameter("@strMobileNo", strMobileNo));
bool nStatus = Convert.ToBoolean(ContactDataSet.Tables[0].Rows[0]["nStatus"]);
if (nStatus)
{
return(true);
}
else
{
return(false);
}
}
public bool ValidatePH(int nEmployeeID, DateTime startDate)
{
DataSet PHDataSet = SqlHelperUtils.ExecuteDatasetSP("dw_ComparePH",
new SqlParameter("@nEmployeeID",
nEmployeeID),
new SqlParameter("@dtDate",
startDate));
int nClaim = Convert.ToInt32(PHDataSet.Tables[0].Rows[0]["nClaim"]);
int nUsage = Convert.ToInt32(PHDataSet.Tables[1].Rows[0]["nUsage"]);
if (nClaim > nUsage)
{
return(true);
}
else
{
return(false);
}
}
public void UpdateMiscLeave(int nLeaveID, int nEmployeeID, DataRow rEmployeeInfo, string strLeaveCode, string strRemarks,
bool isFullDay, DateTime startDate, DateTime endDate, bool showNotEnoughBalance)
{
if (string.Compare(strLeaveCode, "AL", true) == 0 || string.Compare(strLeaveCode, "OFF", true) == 0)
{
throw new Exception("Annual Leave or Time Off Leave is not until this Misc Leave.");
}
if (!ACMS.Convert.ToBoolean(rEmployeeInfo["fMaternityLeave"]) &&
(string.Compare(strLeaveCode, "MTL", true) == 0 || string.Compare(strLeaveCode, "MT3", true) == 0))
{
throw new Exception("You are not allow to apply Maternity Leave.");
}
if (!ACMS.Convert.ToBoolean(rEmployeeInfo["fChildCareLeave"]) && string.Compare(strLeaveCode, "CHD", true) == 0)
{
throw new Exception("You are not allow to apply ChildCare Leave.");
}
DateTime employeeStartDate;
if (rEmployeeInfo["dtEmployeeStartDate"] != DBNull.Value)
{
employeeStartDate = Convert.ToDateTime(rEmployeeInfo["dtEmployeeStartDate"]);
}
else
{
employeeStartDate = new DateTime(DateTime.Today.Year, 1, 1);
}
int nYearID = Ultis.NYearID(employeeStartDate, startDate);
double nLeaveQty;
if (isFullDay)
{
nLeaveQty = 1.0;
}
else
{
nLeaveQty = 0.5;
}
if (!ACMS.Convert.ToBoolean(rEmployeeInfo["fProbation"]) ||
(ACMS.Convert.ToBoolean(rEmployeeInfo["fProbation"]) && string.Compare("CHD", strLeaveCode, true) == 0))
{
DataSet leaveDataSet = SqlHelperUtils.ExecuteDatasetSP("pr_GetUpdateMiscLeaveBalanceInfo",
new SqlParameter("@inEmployeeID", nEmployeeID),
new SqlParameter("@inLeaveID", nLeaveID),
new SqlParameter("@inYearID", nYearID),
new SqlParameter("@sstrLeaveCode", strLeaveCode));
double nLeaveBalance = 0;
if (leaveDataSet.Tables[0].Rows.Count > 0)
{
nLeaveBalance = Convert.ToDouble(leaveDataSet.Tables[0].Rows[0]["nUnusedLeaveQuantity"]);
}
else
{
nLeaveBalance = Convert.ToDouble(leaveDataSet.Tables[1].Rows[0]["nMaxDays"]);
}
if (showNotEnoughBalance && nLeaveQty > nLeaveBalance)
{
throw new Exception("Not enough Misc balance.");
}
if (nLeaveBalance >= nLeaveQty)
{
EditLeave(nLeaveID, nEmployeeID, nYearID, strRemarks, nLeaveQty, 0, 0, 0, isFullDay, startDate,
endDate);
}
else if (nLeaveBalance >= 0)
{
EditLeave(nLeaveID, nEmployeeID, nYearID, strRemarks, nLeaveBalance,
nLeaveQty - nLeaveBalance, 0, 0, isFullDay, startDate, endDate);
}
else
{
EditLeave(nLeaveID, nEmployeeID, nYearID, strRemarks, 0, nLeaveQty, 0, 0, isFullDay, startDate,
endDate);
}
}
else
{
EditLeave(nLeaveID, nEmployeeID, nYearID, strRemarks, 0, nLeaveQty, 0, 0, isFullDay, startDate,
endDate);
}
}
