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