// GET: GetSummaryDetails
public JsonResult GetSummaryDetails(int hospitalId, string hospitalDate, int EpiWeek, int EpiYear)
{
var HospitalDate = DateTime.Parse(hospitalDate);
//var casesummary = db.CaseSummaries.FirstOrDefault(s=>s.HosiptalId == hospitalId && s.StartDateOfWeek == HospitalDate);
var casesummary = db.CaseSummaries.FirstOrDefault(s => s.HosiptalId == hospitalId && s.EpiYear == EpiYear && s.EW == EpiWeek);
var user = UserManager.FindById(User.Identity.GetUserId());
if (casesummary == null)
{
casesummary = new CaseSummary()
{
StartDateOfWeek = HospitalDate,
HosiptalId = hospitalId,
EW = EpiWeek,
EpiYear = EpiYear,
CaseSummaryDetails = new List <CaseSummaryDetail>()
};
db.Entry(casesummary).State = EntityState.Added;
var AgeGroupbyCountry = db.CatAgeGroup.Where(i => i.id_country == user.Institution.CountryID).OrderBy(z => z.id_conf_country).ToList();
foreach (CatAgeGroup agegroup in AgeGroupbyCountry)
{
casesummary.CaseSummaryDetails.Add(
new CaseSummaryDetail()
{
AgeGroup = agegroup.id_conf_country,
ETINumFem = 0,
ETINumMaso = 0,
ETINumST = 0,
ETINumEmerFem = 0,
ETINumEmerMaso = 0,
ETINumEmerST = 0,
ETIDenoFem = 0,
ETIDenoMaso = 0,
ETIDenoST = 0,
HospFem = 0,
HospMaso = 0,
HospST = 0,
HospSARIFem = 0, //#### CAFQ: 181101
HospSARIMaso = 0,
HospSARIST = 0,
UCIFem = 0,
UCIMaso = 0,
UCIST = 0,
UCISARIFem = 0, //#### CAFQ: 181101
UCISARIMaso = 0,
UCISARIST = 0,
DefFem = 0,
DefMaso = 0,
DefST = 0,
DefSARIFem = 0, //#### CAFQ: 181101
DefSARIMaso = 0,
DefSARIST = 0,
NeuFem = 0,
NeuMaso = 0,
NeuST = 0,
CCSARIFem = 0,
CCSARIMaso = 0,
CCSARIST = 0,
VentFem = 0,
VentMaso = 0,
VentST = 0
}
);
}
db.SaveChanges();
}
var casesummaryDetails = casesummary.CaseSummaryDetails.OrderBy(z => z.AgeGroup).ToArray();
// (
// from casesummary in db.CaseSummaries as IEnumerable<CaseSummary>
// where casesummary
// select casesummary.CaseSummaryDetails
// );
// CaseSummaryDetails = db.FluCases.GroupBy(o=>o.AgeGroup).Select( f => new {
// AgeGroup = f.Key,
// Hospfem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.HospAmDate.HasValue ? 1 : 0),
// HospMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.HospAmDate.HasValue ? 1 : 0),
// ICUfem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.ICUAmDate.HasValue ? 1 : 0),
// ICUMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.ICUAmDate.HasValue ? 1 : 0),
// Deffem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.Destin.Equals("D") ? 1 : 0),
// DefMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.Destin.Equals("D") ? 1 : 0)
// }
return(Json(casesummaryDetails, JsonRequestBehavior.AllowGet));
}
// GET: GetSummaryDetails
public JsonResult GetSummaryDetails(int hospitalId, string hospitalDate)
{
var HospitalDate = DateTime.Parse(hospitalDate);
var casesummary = db.CaseSummaries.FirstOrDefault(s=>s.HosiptalId == hospitalId && s.StartDateOfWeek == HospitalDate);
if (casesummary == null)
{
casesummary = new CaseSummary(){
StartDateOfWeek = HospitalDate,
HosiptalId = hospitalId,
CaseSummaryDetails = new List<CaseSummaryDetail>()
};
db.Entry(casesummary).State = EntityState.Added;
foreach (AgeGroup agegroup in (AgeGroup[])Enum.GetValues(typeof(AgeGroup)) )
{
casesummary.CaseSummaryDetails.Add(
new CaseSummaryDetail()
{
AgeGroup = agegroup,
ETINumFem = 0,
ETINumMaso = 0,
ETINumST = 0,
ETINumEmerST = 0,
ETIDenoFem = 0,
ETIDenoMaso = 0,
ETIDenoST = 0,
HospFem = 0,
HospMaso = 0,
HospST = 0,
UCIFem = 0,
UCIMaso = 0,
UCIST = 0 ,
DefFem = 0,
DefMaso = 0,
DefST = 0 ,
NeuFem = 0 ,
NeuMaso = 0,
NeuST = 0,
CCSARIFem = 0,
CCSARIMaso = 0,
CCSARIST = 0,
VentFem = 0,
VentMaso = 0,
VentST = 0
}
);
}
db.SaveChanges();
}
var casesummaryDetails = casesummary.CaseSummaryDetails.ToArray();
// (
// from casesummary in db.CaseSummaries as IEnumerable<CaseSummary>
// where casesummary
// select casesummary.CaseSummaryDetails
// );
// CaseSummaryDetails = db.FluCases.GroupBy(o=>o.AgeGroup).Select( f => new {
// AgeGroup = f.Key,
// Hospfem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.HospAmDate.HasValue ? 1 : 0),
// HospMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.HospAmDate.HasValue ? 1 : 0),
// ICUfem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.ICUAmDate.HasValue ? 1 : 0),
// ICUMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.ICUAmDate.HasValue ? 1 : 0),
// Deffem = f.Sum(i => i.Gender == Gender.Female && i.CaseHospital.Destin.Equals("D") ? 1 : 0),
// DefMaso = f.Sum(i => i.Gender == Gender.Male && i.CaseHospital.Destin.Equals("D") ? 1 : 0)
// }
return Json(casesummaryDetails, JsonRequestBehavior.AllowGet);
}
