public static List <EpExcelDetails> GetEPExcelDetails(SearchEPScoringParams search)
{
var result = new List <EpExcelDetails>();
using (var DBMEdition01_Entities = new DBMEdition01_Entities())
{
DBMEdition01_Entities.Database.CommandTimeout = 6000;
try
{
string ChapterList = string.Empty;
string StandardList = string.Empty;
string ScoredByList = string.Empty;
ChapterList = (search.ChapterAll == 1) ? null : search.ChapterList;
StandardList = (search.StandardAll == 1) ? null : search.StandardList;
ScoredByList = (search.ScoredByAll == 1) ? null : search.ScoredByList;
result = DBMEdition01_Entities.GetEPExcelDetails(search.SiteID,
search.ProgramID, ChapterList, StandardList, search.ScoreTypeList,
search.ScoreValueList, ScoredByList, search.NotScoredInPeriod, search.FSA,
search.DocRequiredValue, search.NewChangedEPs, search.PlanOfAction, search.OrgFindings,
search.OrgNotes, search.LinkedDocs, search.DateStart, search.DateEnd,
search.StandardEffBeginDate, search.CertificationID, search.chkIncludeCMS).ToList()
.ConvertAll(x => new EpExcelDetails()
{
HCOID = x.HCOID,
SiteName = x.SiteName,
StandardLabel = x.StandardLabel,
EPLabel = x.EPLabel,
EPText = x.EPText,
EPTextID = x.EPTextID,
ScoreTypeName = x.ScoreTypeName,
ScoreName = x.ScoreName,
Likelihood = x.Likelihood,
Scope = x.Scope,
ScoreDate = x.ScoreDate,
FullName = x.FullName,
Findings = x.Findings,
OrgNotes = x.OrgNotes,
POA = x.POA,
DocumentList = x.DocumentList,
CompliantDate = x.CompliantDate,
MOS = x.MOS,
FSA = x.FSA,
dcm_fl = x.dcm_fl,
esp1_fl = x.esp1_fl,
NewEP = x.NewEP,
TagCode = x.TagCode,
CopText = x.CopText,
ProgramCode = x.ProgramCode,
ProgramName = x.ProgramName,
ChapterName = x.ChapterName,
SiteID = x.SiteID
}).ToList();
}
catch (Exception e)
{
string x = e.ToString();
}
}
return(result);
}