public List <ApiTracersBySiteProgramStatusReturnModel> GetTracersBySiteProgramStatus(int?programID, int?siteID, int?statusID, int?userID)
{
List <ApiTracersBySiteProgramStatusReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiTracersBySiteProgramStatus(siteID, programID, statusID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
// Fix for Bug 55857. Previous code had programID and siteID variables in reverse order.
sb.AppendFormat("EXEC dbo.apiTracersBySiteProgramStatus @ProgramID='{0}', @SiteID={1}, @StatusID={2}, @UserID={3}", programID, siteID, statusID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/GetTracersBySiteProgramStatus";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(null);
}
}