public ActionResult IpdCountElderly()
{
IpdCountModel model = new IpdCountModel();
IpdCountProviders IpdPro = new IpdCountProviders();
model.TotalIpdPatient = IpdPro.GetTotalIpdPatient();
model.TotalIpdMalePatient = IpdPro.GetTotalIpdMalePatient();
model.TotalIpdFemalePatient = IpdPro.GetTotalIpdFemalePatient();
return(View(model));
}
public ActionResult IpdCountElderly(string year, int month)
{
IpdCountModel model = new IpdCountModel();
IpdCountProviders IpdPro = new IpdCountProviders();
model = IpdPro.getjanuarycount(year, month);
model.TotalIpdPatient = IpdPro.GetTotalIpdPatient();
model.Year = year;
model.Month = month;
model.TotalIpdMalePatient = IpdPro.GetTotalIpdMalePatient();
model.TotalIpdFemalePatient = IpdPro.GetTotalIpdFemalePatient();
return(View(model));
}
public IpdCountModel getjanuarycount(string year, int Month)
{
DateTime startdate;
DateTime enddate;
int y = Convert.ToInt32(year);
EHMSEntities ent = new EHMSEntities();
IpdCountModel model = new IpdCountModel();
//for (int i = 1; i <= 12; i++)
//{
int lastdate = 0;
if (Month == 2)
{
lastdate = 28;
}
//else { lastdate = 30; }
else if (Month == 1 || Month == 3 || Month == 5 || Month == 7 || Month == 10 || Month == 12)
{
lastdate = 31;
}
else
{
lastdate = 30;
}
if (Month == 0)
{
startdate = Convert.ToDateTime(y + "/" + 1 + "/" + "1");
enddate = Convert.ToDateTime(y + "/" + 12 + "/" + "31");
}
else
{
startdate = Convert.ToDateTime(y + "/" + Month + "/" + "1");
enddate = Convert.ToDateTime(y + "/" + Month + "/" + lastdate);
}
var GetMaleCountFromEM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Male" && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 1
select b).Count();
var GetMaleCountFromOM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where b.RegistrationDate >= startdate && b.RegistrationDate <= enddate && b.Sex == "Male" && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 2
select b).Count();
var totalMalecountbetween = GetMaleCountFromEM + GetMaleCountFromOM;
model.MaleNobetn = totalMalecountbetween;
var GetFemaleCountFromEM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Female" && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 1
select b).Count();
var GetFemaleCountFromOM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Female" && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 2
select b).Count();
var totalFemalecountBetn = GetFemaleCountFromOM + GetFemaleCountFromEM;
model.FemaleNobetn = totalFemalecountBetn;
var GetMaleCountFromEMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Male" && b.AgeYear > 64 && l.DepartmentID == 1
select b).Count();
var GetMaleCountFromOMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Male" && b.AgeYear > 64 && l.DepartmentID == 2
select b).Count();
var totalMaleCountAbove = GetMaleCountFromEMAbove + GetMaleCountFromOMAbove;
model.MaleNoAbove = totalMaleCountAbove;
var GetFemaleCountFromEMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate.Date && l.RegistrationDate <= enddate && b.Sex == "Female" && b.AgeYear > 64 && l.DepartmentID == 1
select b).Count();
var GetFemaleCountFromOMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.Sex == "Female" && b.AgeYear > 64 && l.DepartmentID == 2
select b).Count();
var totalcountFemaleAbove = GetFemaleCountFromEMAbove + GetFemaleCountFromOMAbove;
model.FemaleNoAbove = totalcountFemaleAbove;
var GetTotalCountFromEM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 1
select b).Count();
var GetTotalCountFromOM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.AgeYear >= 60 && b.AgeYear <= 64 && l.DepartmentID == 2
select b).Count();
var totalcountBetween = GetTotalCountFromOM + GetTotalCountFromEM;
model.TotalNoBetn = totalcountBetween;
var GetTotalCountFromEMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.AgeYear > 64 && l.DepartmentID == 1
select b).Count();
var GetTotalCountFromOMAbove = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && b.AgeYear > 64 && l.DepartmentID == 2
select b).Count();
var totalcountAbove = GetTotalCountFromEM + GetTotalCountFromOM;
model.TotalNoAbove = totalMaleCountAbove;
var GetGrandTotalCountFromEM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && l.DepartmentID == 1 && b.AgeYear >= 60
select b).Count();
var GetGrandotalCountFromOM = (from b in ent.OpdMasters
join l in ent.IpdRegistrationMasters on b.OpdID equals l.OpdNoEmergencyNo
where l.RegistrationDate >= startdate && l.RegistrationDate <= enddate && l.DepartmentID == 2 && b.AgeYear >= 60
select b).Count();
var totalGrandcount = GetGrandTotalCountFromEM + GetGrandotalCountFromOM;
model.GrandTotalElder = totalGrandcount;
//}
return(model);
}
