//
// GET: /Hypertension/Create
public ActionResult Create()
{
TayBacDBContext dbContext = new TayBacDBContext();
List <object> ls = new List <object>();
HospitalModels hp_model = new HospitalModels();
huyetap ha = new huyetap();
benhnhan pa = new benhnhan();
KhoaModels kh_model = new KhoaModels();
GiuongModels gi_model = new GiuongModels();
List <benhvien> lsbv = hp_model.getAll();
List <khoa> lskhoa = new List <khoa>();
if (lsbv.Count() > 0)
{
lskhoa = kh_model.getListByIdBV(lsbv.First().idbv);
}
List <giuong> lsgiuong = new List <giuong>();
if (lskhoa.Count() > 0)
{
lsgiuong = gi_model.getListByIdKhoa(lskhoa.First().idkhoa);
}
ls.Add(lsbv);
ls.Add(ha);
ls.Add(pa);
ls.Add(lskhoa);
ls.Add(lsgiuong);
return(View(ls));
}
//
//[Permission(Constants.G_ADMIN), Permission(Constants.G_MANAGER)]
public ActionResult jsonStatHistory()
{
TayBacDBContext dbContext = new TayBacDBContext();
var bn_huyetapp = from ha in dbContext.huyetaps
join bs in dbContext.benhsus on ha.idbs equals bs.idbs
join bn in dbContext.benhnhans on bs.idbn equals bn.idbn
group bn.idbn by ha.HA_II_B_1 into g
select new
{
HA_II_B_1 = g.Key,
num = g.Count()
};
return(Json(bn_huyetapp.ToList(), JsonRequestBehavior.AllowGet));
}
//
// GET: /Bloodpressure/Edit/5
public ActionResult Edit(string id)
{
TayBacDBContext dbContext = new TayBacDBContext();
List <object> ls = new List <object>();
HospitalModels hp_model = new HospitalModels();
HuyetapModels ha_model = new HuyetapModels();
huyetap ha = ha_model.getByID(id);
benhnhan pa = new benhnhan();
KhoaModels kh_model = new KhoaModels();
GiuongModels gi_model = new GiuongModels();
List <benhvien> lsbv = hp_model.getAll();
List <khoa> lskhoa = new List <khoa>();
if (lsbv.Count() > 0)
{
lskhoa = kh_model.getListByIdBV(lsbv.First().idbv);
}
List <giuong> lsgiuong = new List <giuong>();
if (lskhoa.Count() > 0)
{
lsgiuong = gi_model.getListByIdKhoa(lskhoa.First().idkhoa);
}
//
BenhsuModels bs_model = new BenhsuModels();
benhsu bs_data = bs_model.getByID(ha.idbs);
PatientModels pa_model = new PatientModels();
benhnhan pa_data = pa_model.detail(bs_data.idbn);
benhvien bv_data = hp_model.details(pa_data.idbv);
pa_data.benhvien = bv_data;
bs_data.benhnhan = pa_data;
ha.benhsu = bs_data;
//
ls.Add(lsbv);
ls.Add(ha);
ls.Add(pa);
ls.Add(lskhoa);
ls.Add(lsgiuong);
return(View(ls));
}
//Apis
//get json list huyet ap
// GET: /Hypertension/lshuyetap
public ActionResult lshuyetap()
{
TayBacDBContext dbContext = new TayBacDBContext();
var bn_huyetapp = from ha in dbContext.huyetaps
join bs in dbContext.benhsus on ha.idbs equals bs.idbs
join bn in dbContext.benhnhans on bs.idbn equals bn.idbn
select new
{
bn_ten = bn.tenbn,
bn_ns = bn.ngaysinh,
bn_gioitinh = bn.gioitinh,
bn_nghenghiep = bn.nghenghiep,
HA_I = ha.HA_I,
HA_II_A = ha.HA_II_A
};
return(Json(bn_huyetapp.ToList(), JsonRequestBehavior.AllowGet));
}
//
// GET: /Hypertension/
public ActionResult Index()
{
TayBacDBContext dbContext = new TayBacDBContext();
var bn_huyetapp = (from ha in dbContext.huyetaps
join bs in dbContext.benhsus on ha.idbs equals bs.idbs
join bn in dbContext.benhnhans on bs.idbn equals bn.idbn
select new HuyetapViewModel
{
idbn = bn.idbn,
tenbn = bn.tenbn,
idbs = bs.idbs,
gioitinh = bn.gioitinh,
ngaysinh = bn.ngaysinh,
dantoc = bn.dantoc,
idhuyetap = ha.idhuyetap,
HA_I = ha.HA_I,
HA_II_A = ha.HA_II_A
}).ToList();
return(View(bn_huyetapp));
}
public KhoaModels()
{
dbContext = new TayBacDBContext();
}
public HuyenModels()
{
dbContext = new TayBacDBContext();
}
public UserModels()
{
dbContext = new TayBacDBContext();
}
public GiuongModels()
{
dbContext = new TayBacDBContext();
}
//
public ActionResult jsonStatIndexs()
{
TayBacDBContext dbContext = new TayBacDBContext();
var bn_huyetapp = (from ha in dbContext.huyetaps
join bs in dbContext.benhsus on ha.idbs equals bs.idbs
join bn in dbContext.benhnhans on bs.idbn equals bn.idbn
//group bn.idbn by ha.HA_III_1_1 into g
select new
{
HA_III_1_1 = ha.HA_III_1_1, //mach
HA_III_1_2 = ha.HA_III_1_2, //nhiet do
HA_III_1_3_1 = ha.HA_III_1_3_1, // huyet ap
HA_III_1_3_2 = ha.HA_III_1_3_2, // huyet ap
HA_III_1_4 = ha.HA_III_1_4, // nhip tho
HA_III_1_5 = ha.HA_III_1_5, // can nang
HA_III_1_6 = ha.HA_III_1_6 //chieu cao
}).ToList();
//mach
int HA_III_1_1_nhanh = 0;
int HA_III_1_1_binhthuong = 0;
int HA_III_1_1_cham = 0;
//nhiet do
//huyet ap
//nhip tho
int HA_III_1_4_cham = 0;
int HA_III_1_4_binhthuong = 0;
int HA_III_1_4_nhanh = 0;
//BMI
int BMI_gay = 0;
int BMI_binhthuong = 0;
int BMI_thuacan = 0;
foreach (var item in bn_huyetapp)
{
//mach
if (item.HA_III_1_1 > 100)//nhanh
{
HA_III_1_1_nhanh++;
}
else if (item.HA_III_1_1 >= 60 && item.HA_III_1_1 <= 100) // binh thuong
{
HA_III_1_1_binhthuong++;
}
else if (item.HA_III_1_1 < 60) //cham
{
HA_III_1_1_cham++;
}
//nhip tho
if (item.HA_III_1_4 < 15)
{
HA_III_1_4_cham++;
}
else if (item.HA_III_1_4 >= 15 && item.HA_III_1_4 <= 18)
{
HA_III_1_4_binhthuong++;
}
else if (item.HA_III_1_4 > 18)
{
HA_III_1_4_nhanh++;
}
//BMI
Double bmi = Convert.ToDouble(item.HA_III_1_5) / Math.Pow(Convert.ToDouble(item.HA_III_1_6), Convert.ToDouble(2));
if (bmi < 18.5)
{
BMI_gay++;
}
else if (bmi >= 18.5 && bmi <= 24.99)
{
BMI_binhthuong++;
}
else if (bmi >= 25)
{
BMI_thuacan++;
}
}
List <Array> ls_indexs = new List <Array>();
int[] mach = new int[3];
mach[0] = HA_III_1_1_nhanh;
mach[1] = HA_III_1_1_binhthuong;
mach[2] = HA_III_1_1_cham;
ls_indexs.Add(mach);
//
int[] nhiptho = new int[3];
nhiptho[0] = HA_III_1_4_nhanh;
nhiptho[1] = HA_III_1_4_binhthuong;
nhiptho[2] = HA_III_1_4_cham;
ls_indexs.Add(nhiptho);
//BMI
int[] arr_bmi = new int[3];
arr_bmi[0] = BMI_thuacan;
arr_bmi[1] = BMI_binhthuong;
arr_bmi[2] = BMI_gay;
ls_indexs.Add(arr_bmi);
return(Json(ls_indexs, JsonRequestBehavior.AllowGet));
}
public HospitalModels()
{
dbContext = new TayBacDBContext();
}
public DoctorModels()
{
dbContext = new TayBacDBContext();
}
public BenhsuModels()
{
dbContext = new TayBacDBContext();
}
public LoginModels()
{
dbContext = new TayBacDBContext();
}
public TinhModels()
{
dbContext = new TayBacDBContext();
}
public PatientModels()
{
dbContext = new TayBacDBContext();
}
