public static SaferMatrixMap GetSaferMatrix(SearchCorporateER search) { int limit = 8; var mockSurveyList = GetSaferMatrixData(search); if (mockSurveyList.Count < 1) { return(null); } var saferMatrixMap = new SaferMatrixMap(); using (var dbmDbEntityContainer = new DBMEdition01_Entities()) { foreach (var safer in dbmDbEntityContainer.GetSafterMap()) { var shortList = mockSurveyList.Where(item => item.CorporateFinalScoreID == safer.ScoreID).DistinctBy(x => new { x.SiteID, x.StandardLabel }); shortList = GroupBySite(shortList); var shortListCount = shortList.Count(); var fullEP = ReturnCorpFindings(safer, shortList.Take(limit)); if (shortListCount > limit) { fullEP = string.Format("{0}+({1}) more EP(s)", fullEP, (shortList.Count() - limit).ToString()); } AssignEPValue(saferMatrixMap, fullEP, safer.ScoreID); } } return(saferMatrixMap); }
public static List <MockSurveyCorporateFindingsReport> GetSaferMatrixRDLC(SearchCorporateER search) { var saferMatrixList = new List <MockSurveyCorporateFindingsReport>(); var mockSurveyList = GetSaferMatrixData(search); int limit = int.MaxValue; var list = new List <MockSurveyCorporateFindingsReport>(); using (var dbmDbEntityContainer = new DBMEdition01_Entities()) { foreach (var safer in dbmDbEntityContainer.GetSafterMap()) { var shortList = mockSurveyList.Where(item => item.CorporateFinalScoreID == safer.ScoreID).DistinctBy(x => new { x.SiteID, x.StandardLabel }); shortList = GroupBySite(shortList); var shortListCount = shortList.Count(); MockSurveyCorporateFindingsReport addItem = ReturnCorpFindingsRDLC(safer, shortList.Take(limit)); if (shortListCount > limit) { addItem.FullEP = string.Format("{0}+({1}) more EP(s)", addItem.FullEP, (shortList.Count() - limit).ToString()); } list.Add(addItem); } } return(list); }
public static List <UserSiteByProduct> GetUserSitesByProdcut(int userID, int productID) { var result = new List <UserSiteByProduct>(); using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = dbmEntityContainter.GetUserSitesByProduct(userID, productID).ToList(); } return(result); }
public static List <MockSurvey> GetMultiSiteMockSurveys(String selectedSiteIDs, int statusID, int?programID = null) { var result = new List <MockSurvey>(); using (var dbmEditionContainer = new DBMEdition01_Entities()) { result = dbmEditionContainer.GetMockSurveysBySites(selectedSiteIDs, statusID, programID).ToList(); } return(result); }
public static List <CorpProgramFinding> GetCorpFindingByProgram(string siteIDs, string mockSurveyIDs, string mSTeamLeadIDs, string mSTeamMemberIDs, string programIDs, string standardTextIDs, string chapterIDs, string ePTextIDs, Nullable <System.DateTime> startDate, Nullable <System.DateTime> endDate, Nullable <bool> rFIInclude, Nullable <bool> onlyFSAEPs, Nullable <int> mockSurveyStatusID, DateTime?standardEffBeginDate = null) { var result = new List <CorpProgramFinding>(); using (var dbmEditionContainer = new DBMEdition01_Entities()) { result = dbmEditionContainer.GetCorpFindingByProgram(siteIDs, mockSurveyIDs, mSTeamLeadIDs, mSTeamMemberIDs, programIDs, standardTextIDs, chapterIDs, startDate, endDate, rFIInclude, onlyFSAEPs, mockSurveyStatusID, standardEffBeginDate).ToList(); } return(result); }
public static List <CorpProgramFinding> GetCorpFindingByProgram(SearchCorporateER search, DateTime?standardEffBeginDate = null) { var result = new List <CorpProgramFinding>(); using (var dbmEditionEntityContainer = new DBMEdition01_Entities()) { result = dbmEditionEntityContainer.GetCorpFindingByProgram(search.SelectedSiteIDs, search.SelectedMockSurveyIDs, search.SelectedMockSurveyLeadIDs, search.SelectedMockSurveyMemberIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.StartDate, search.EndDate, search.IncludeRFI, search.IncludeFsa, search.MockSurveyStatusID, standardEffBeginDate).ToList(); } return(result); }
public static List <Programs> GetProgramSites(String siteList) { var result = new List <Programs>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { result = DBMEdition01_Entities.GetProgrambySites(siteList, null).ToList(); } return(result); }
public static List <Standard> GetStandards(string programList, string chapterList) { var result = new List <Standard>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { result = DBMEdition01_Entities.GetStandardsByProgramsChapters(chapterList, programList).ToList(); } return(result); }
public static List <CMSSite> GetCMSSitesByProgramID(int ProgramID, int SubscriptionTypeID) { var result = new List <CMSSite>(); using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = dbmEntityContainter.GetCMSSitesByProgramID(ProgramID, SubscriptionTypeID).ToList(); } return(result); }
public static bool GetLicenseDetailsForCMSByUser(int userID, int SubscriptionTypeID) { bool result = false; using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = (bool)dbmEntityContainter.GetLicenseDetailsForCMSByUser(userID, SubscriptionTypeID).FirstOrDefault(); } return(result); }
public static List <Tag> GetTagsByProgramIDAndCoPID(string ProgramIDs, string CoPIDs) { var result = new List <Tag>(); using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = dbmEntityContainter.GetTagsByProgramIDAndCoPID(ProgramIDs, CoPIDs).ToList(); } return(result); }
public static User GetUserInfo(int UserID) { var result = new User(); using (var dbmeditionEntityContainer = new DBMEdition01_Entities()) { result = dbmeditionEntityContainer.GetUserInfo(UserID).First(); } return(result); }
public static string GetReportHcoIDs(string selectedSiteIDs) { string hcoIDs = string.Empty; using (var dbmEditionContainer = new DBMEdition01_Entities()) { hcoIDs = dbmEditionContainer.GetHcoIDs(selectedSiteIDs).FirstOrDefault(); } return(hcoIDs); }
public static List <Site> GetSitesByUser(int UserID, Nullable <bool> filteredsites = false) { var result = new List <Site>(); using (var dbmDbEntityContainer = new DBMEdition01_Entities()) { result = dbmDbEntityContainer.GetSelectSitesByUser(UserID).ToList(); } return(result); }
public static List <IdentifiedUser> GetIdentifiedUsers(string siteIDs, string programIDs, string coPIDs, string tagIDs) { var result = new List <IdentifiedUser>(); using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = dbmEntityContainter.GetIdentifiedUsers(siteIDs, programIDs, coPIDs, tagIDs).ToList(); } return(result); }
public static List <CorpUser> GetCorpUsersBySite(string userRoleName, string siteIDs, int StatusID) { var result = new List <CorpUser>(); using (var dbmEditionEntityContainer = new DBMEdition01_Entities()) { result = dbmEditionEntityContainer.GetCorpUsersBySite(userRoleName, siteIDs, StatusID).ToList(); } return(result); }
public static List <Chapter> GetChapters(String siteList, string programIDs) { var result = new List <Chapter>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { result = DBMEdition01_Entities.GetChapter(siteList, programIDs, null).ToList(); } return(result); }
public static List <CorpEPFinding> GetCorpFindingByEP(SearchCorporateER search, DateTime?standardEffBeginDate = null) { var result = new List <CorpEPFinding>(); using (var dbmEditionEntityContainer = new DBMEdition01_Entities()) { dbmEditionEntityContainer.Database.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["SPCmdTimeout"].ToString()); result = dbmEditionEntityContainer.GetCorpFindingByEP(search.SelectedSiteIDs, search.SelectedMockSurveyIDs, search.SelectedMockSurveyLeadIDs, search.SelectedMockSurveyMemberIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.StartDate, search.EndDate, search.IncludeRFI, search.IncludeFsa, search.MockSurveyStatusID, standardEffBeginDate).ToList(); } return(result); }
public static List <SaferMatrixSummaryByChapter> GetSaferMatrixSummaryByChapter(SearchCorporateER search) { var result = new List <SaferMatrixSummaryByChapter>(); using (var dbmDbEntityContainer = new DBMEdition01_Entities()) { result = dbmDbEntityContainer.GetSaferMatrixSummaryByChapter(search.SelectedSiteIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.SelectedEPIDs, int.Parse(search.ScoreType), search.StartDate, search.EndDate, search.MatrixID, search.IncludeFsa, search.MockSurveyStatusID, AppSession.CycleID).ToList(); } return(result); }
public static List <ScoredByUser> GetScoredByForEPs(int siteID, int selectedProgramID, string selectedChapterIDs, string selectedStandardIDs, string selectedScoreType) { var result = new List <ScoredByUser>(); //Added by kalaivani for getting the scored by users using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { var MockSurveyStatusID = (int)MockSurveyStatus.Publish_CCA_Recommendation; result = DBMEdition01_Entities.GetScoredByUsers(siteID, selectedProgramID, selectedChapterIDs, selectedStandardIDs, selectedScoreType, MockSurveyStatusID).ToList(); } return(result); }
public List <CMSComplianceExcel> GetCMSComplianceExcel(SearchCMSCompliance searchParams) { var result = new List <CMSComplianceExcel>(); using (var dbmEntityContainter = new DBMEdition01_Entities()) { result = dbmEntityContainter.GetCMSComplianceExcel(int.Parse(searchParams.SelectedSiteIDs), int.Parse(searchParams.ProgramIDs), searchParams.ComplianceValueList, searchParams.SelectedCoPIDs, searchParams.SelectedTagIDs, searchParams.SelectedIdentifiedByIDs, searchParams.PlanOfCorrection, searchParams.OrgCMSFindings, searchParams.CMSSurveyorFindings, searchParams.LinkedDocs, searchParams.StartDate, searchParams.EndDate, searchParams.StandardEffBeginDate, searchParams.CertificationID, Convert.ToBoolean(searchParams.chkIncludeTJC)).ToList(); } return(result); }
public static List <RFIEPFindingViewModel> GetCorpFindingByEP(SearchCorporateER search) { var result = new List <RFIEPFindingViewModel>(); //Added by Subramaniam R on 05 Oct 2016 for calling from DBMEdition entity. using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { result = DBMEdition01_Entities.GetRFIFindingByEP(search.SelectedSiteIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.StartDate, search.EndDate, search.IncludeFsa, search.IncludeRFI, search.IncludePre, search.IncludeFin) .ToList() .ConvertAll(x => new RFIEPFindingViewModel() { HCO_ID = x.HCO_ID, Program = x.Program, State = x.State, HospitalName = x.HospitalName, Chapter = x.Chapter, Standard = x.Standard, EP = x.EP, //Documentation = x.Documentation, TJCScore = x.TJCScore, TJCSAFERScoreLikelihood = x.TJCSAFERScoreLikelihood, TJCSAFERScoreScope = x.TJCSAFERScoreScope, TJCScoreDate = x.TJCScoreDate, PreliminaryScore = x.PreliminaryScore, PreliminarySAFERScoreLikelihood = x.PreliminarySAFERScoreLikelihood, PreliminarySAFERScoreScope = x.PreliminarySAFERScoreScope, PreliminaryScoreDate = x.PreliminaryScoreDate, FinalScore = x.FinalScore, FinalSAFERScoreLikelihood = x.FinalSAFERScoreLikelihood, FinalSAFERScoreScope = x.FinalSAFERScoreScope, FinalScoreDate = x.FinalScoreDate, TJCFinding = x.TJCFinding, PlanOfAction = x.PlanOfAction, SustainmentPlan = x.SustainmentPlan }).ToList(); return(result); } catch (Exception e) { string x = e.ToString(); } } return(result); }
public static string GetReportHcoIDs(string selectedSiteIDs) { string hcoIDs = string.Empty; using (var dbmDbEntityContainer = new DBMEdition01_Entities()) { try { hcoIDs = dbmDbEntityContainer.GetHcoIDs(selectedSiteIDs).FirstOrDefault(); } catch (Exception ex) { throw ex; } } return(hcoIDs); }
public static List<AssignmentStatusByUser_StandardData> GetAssignmentStatusByUser_StandardData(SearchAssignmentStatusByUser search) { var result = new List<AssignmentStatusByUser_StandardData>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { int SiteID = Convert.ToInt32(search.SelectedSiteIDs); int ProgramID = Convert.ToInt32(search.ProgramIDs); int ChapterID = Convert.ToInt32(search.SelectedChapterIDs); int SelectedAssignedToID = Convert.ToInt32(search.SelectedAssignedToIDs); result = DBMEdition01_Entities.GetAssignmentStatusByUser_StandardWise(SiteID, ProgramID, ChapterID, search.SelectedStandardIDs, search.SelectedScoreType, SelectedAssignedToID, search.IncludeFSAEPs, search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate, search.ScoreValueList).ToList(); result .Where(a => (decimal)(a.ScoreCompletePercentage.Value + a.ScoreNotCompletePercentage.Value + a.ScorePastDueDatePercentage.Value) > (decimal)100.00).ToList() .ForEach(delegate (AssignmentStatusByUser_StandardData userData) { decimal difference = (userData.ScoreCompletePercentage.Value + userData.ScoreNotCompletePercentage.Value + userData.ScorePastDueDatePercentage.Value) - 100; if (userData.ScoreCompletePercentage.Value > difference * 2) userData.ScoreCompletePercentage = userData.ScoreCompletePercentage.Value - difference; else if (userData.ScoreNotCompletePercentage.Value > difference * 2) userData.ScoreNotCompletePercentage = userData.ScoreNotCompletePercentage.Value - difference; else if (userData.ScorePastDueDatePercentage.Value > difference * 2) userData.ScorePastDueDatePercentage = userData.ScorePastDueDatePercentage.Value - difference; }); } catch (Exception ex) { throw ex; } return result; } }
public static List <RFIEPFinding> GetRfiEPDetails(SearchCorporateER search) { var result = new List <RFIEPFinding>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { result = DBMEdition01_Entities.GetRFIFindingByEP(search.SelectedSiteIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.StartDate, search.EndDate, search.IncludeFsa, search.IncludeRFI, search.IncludePre, search.IncludeFin).ToList(); return(result); } catch (Exception e) { string x = e.ToString(); } } return(result); }
public static List <RFIStandardFinding> GetRFIFindingByStandard(SearchCorporateER search) { var result = new List <RFIStandardFinding>(); //Added by Subramaniam R on 28th sep 2016 for calling from DBMEdition entity. using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { result = DBMEdition01_Entities.GetRFIFindingByStandard(search.SelectedSiteIDs, search.ProgramIDs, search.SelectedStandardIDs, search.SelectedChapterIDs, search.StartDate, search.EndDate, search.IncludeFsa, search.IncludeRFI, search.IncludePre, search.IncludeFin).ToList(); } catch (Exception ex) { throw ex; } return(result); } }
public static List<AssignedToUser> GetAssignmentAssignedTo(SearchAssignmentStatusByUser search) { var result = new List<AssignedToUser>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { result = DBMEdition01_Entities.GetUserAssignedToSiteIDAndAssignment(search.SelectedSiteIDs, search.ProgramIDs, search.SelectedChapterIDs, search.SelectedStandardIDs, search.SelectedScoreType, search.IncludeFSAEPs, search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate).ToList(); } catch (Exception ex) { throw ex; } return result; } }
public static List<AssignmentStatusByUser_EPData> GetAssignmentStatusByUser_EPData(SearchAssignmentStatusByUser search) { var result = new List<AssignmentStatusByUser_EPData>(); using (var DBMEdition01_Entities = new DBMEdition01_Entities()) { try { int ProgramID = Convert.ToInt32(search.ProgramIDs); result = DBMEdition01_Entities.GetAssignmentStatusByUser_EPWise(search.SelectedSiteIDs, ProgramID, search.SelectedChapterIDs, search.SelectedStandardIDs, search.SelectedScoreType, search.SelectedAssignedToIDs, search.IncludeFSAEPs, search.IncludeDocumentationRequired, search.IncludeNewChangedEPs, search.StartDate, search.EndDate, search.StandardEffBeginDate, search.ScoreValueList, search.LevelIdentifier).ToList(); } catch (Exception ex) { throw ex; } return result; } }
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); }