public List <thongke_admin_luotxem_loaitt> thongke_detai_trongnam_hh()
{
using (sql_NCKHContext db = new sql_NCKHContext())
{
List <thongke_admin_luotxem_loaitt> result = new List <thongke_admin_luotxem_loaitt>();
List <Tbldetai> dt = db.Tbldetais.Where(x => x.Tinhtrang < 5 && x.Tinhtrang > 0).ToList();
DateTime date = DateTime.Now;
for (int i = 1; i <= 12; i++)
{
thongke_admin_luotxem_loaitt a = new thongke_admin_luotxem_loaitt();
a.id = i;
a.loaitt = "Tháng " + i;
a.soluong = dt.Where(x => x.Thoigianbd.Year == date.Year && x.Thoigianbd.Month == i).Count();
result.Add(a);
}
return(result);
}
}
public List <thongke_admin_luotxem_loaitt> thongke_admin_luotxem_loaitt()
{
List <thongke_admin_luotxem_loaitt> result = new List <thongke_admin_luotxem_loaitt>();
using (sql_NCKHContext db = new sql_NCKHContext())
{
List <Tblloaitt> dsltt = db.Tblloaitts.ToList();
List <Tbltintuc> dstt = db.Tbltintucs.ToList();
foreach (Tblloaitt ltt in dsltt)
{
thongke_admin_luotxem_loaitt a = new thongke_admin_luotxem_loaitt();
a.id = ltt.Id;
a.loaitt = ltt.Tenloaitt;
a.soluong = dstt.Where(x => x.Idloai == ltt.Id).Sum(x => x.Luotem);
result.Add(a);
}
}
return(result);
}
