private DataTable ListBasicTimesheet(int nEmployeeID, DateTime startDate, DateTime endDate)
{
string cmdtxt = "SELECT * FROM Sv_StaffTimesheet "
+ "WHERE nEmployeeID = @nEmployeeID AND dtDate >= @startDate AND dtDate < @endDate and dtDate<=getdate()";
return(SqlHelperUtils.ExecuteDataTableText(cmdtxt,
new SqlParameter("@nEmployeeID", nEmployeeID),
new SqlParameter("@startDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, startDate),
new SqlParameter("@endDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, endDate)));
}
private DataTable ListBasicTimesheet(int nEmployeeID, string strBranchCode, DateTime startDate, DateTime endDate)
{
string cmdtxt = "SELECT * FROM SV_EMPLOYEE_TIMESHEET "
// string cmdtxt = "SELECT * FROM Sv_StaffTimesheet "
+ "WHERE nEmployeeID = @nEmployeeID and dtDate >= @startDate AND dtDate < @endDate"; //AND strBranchCode=@strBranchCode
return(SqlHelperUtils.ExecuteDataTableText(cmdtxt,
new SqlParameter("@nEmployeeID", nEmployeeID),
new SqlParameter("@strBranchCode", strBranchCode),
new SqlParameter("@startDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, startDate),
new SqlParameter("@endDate", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 23, 3, "", DataRowVersion.Proposed, endDate)));
}
