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