public static List <DepartmentCheck> GetChecksGivenReportID(int departmentID)
{
var departmentChex = new DepartmentCheck();
List <DepartmentCheck> CARSdepartmentChex = repository.Query <DepartmentCheck>(@"exec tsprod.dbo." + SPDebug + " @TranType='GetChecksGivenReportID', @reportID=" + departmentID, departmentChex).ToList();
repository.Close();
return(CARSdepartmentChex);
}
public static List <DepartmentCheck> GetCARSDepartmentCheck()
{
var departmentChex = new DepartmentCheck();
List <DepartmentCheck> CARSdepartmentChex = repository.Query <DepartmentCheck>(@"exec tsprod.dbo." + SPDebug + " @TranType='GetAllDepartmentChecks'", departmentChex).ToList();
repository.Close();
return(CARSdepartmentChex);
}
