public List <CTTinNhan> ChiTietTinNhan(int id)
{
context = new ContextNhaTro();
var ID = new SqlParameter("@id", id);
return(context.Database.SqlQuery <CTTinNhan>(@"TKChiTietTinNhan @id", ID).ToList());
}
public int ThongKeTinNhan(int id)
{
context = new ContextNhaTro();
var ID = new SqlParameter("@id", id);
TKTinNhan tinNhan = context.Database.SqlQuery <TKTinNhan>(@"ThongKeTinNhan @id", ID).SingleOrDefault();
return(tinNhan.SoTinNhan);
}
public XLThongKe XuLyThongKe(int id)
{
context = new ContextNhaTro();
List <DSBaiDang> dSBaiDangs = context.Database.SqlQuery <DSBaiDang>(@"ThongKe").ToList();
XLThongKe xLThongKe = new XLThongKe();
xLThongKe.doanhsothang = xLThongKe.TinhDSThang(dSBaiDangs);
xLThongKe.doanhsonam = xLThongKe.TinhDSNam(dSBaiDangs);
xLThongKe.kyvong = xLThongKe.KyVong(dSBaiDangs);
xLThongKe.tinnhan = ThongKeTinNhan(id);
return(xLThongKe);
}
public DangKy()
{
context = new ContextNhaTro();
}
public DangBai()
{
context = new ContextNhaTro();
}
public ThongTInTK()
{
context = new ContextNhaTro();
}
public LayChiTietBD()
{
context = new ContextNhaTro();
}
public LayBaiDang()
{
context = new ContextNhaTro();
}
public ThongKe()
{
context = new ContextNhaTro();
context.Database.SqlQuery <DSBaiDang>(@"ThongKe").ToList();
}
public TinNhan()
{
context = new ContextNhaTro();
}
public User()
{
context = new ContextNhaTro();
tAIKHOAN = new TAIKHOAN();
taiKhoans = context.TAIKHOANs.SqlQuery(@"select * from taikhoan").ToList();
}
public List <DSBaiDang> DsBaiDang()
{
context = new ContextNhaTro();
return(context.Database.SqlQuery <DSBaiDang>(@"ThongKe").ToList());
}
public ThongKe()
{
context = new ContextNhaTro();
}