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