public List <Prod_BH_List_DonBanHang_Result> ListDonBanHang(int page, TongHopDonBanHang TongHopDonBanHang) { var query = db.Database.SqlQuery <Prod_BH_List_DonBanHang_Result>("Prod_BH_List_DonBanHang @macongty,@username,@isadmin,@sotrang,@tukhoa", new SqlParameter("macongty", TongHopDonBanHang.macongty), new SqlParameter("username", TongHopDonBanHang.username), new SqlParameter("isadmin", TongHopDonBanHang.isadmin), new SqlParameter("sotrang", page), new SqlParameter("tukhoa", TongHopDonBanHang.tukhoa)); var result = query.ToList(); return(result); }
public string DemTongSoDonBanHang(TongHopDonBanHang TongHopDonBanHang) { var query = db.Database.SqlQuery <int>("Prod_BH_DemTongSoDonBanHang @username,@macongty,@isadmin", new SqlParameter("username", TongHopDonBanHang.username), new SqlParameter("macongty", TongHopDonBanHang.macongty), new SqlParameter("isadmin", TongHopDonBanHang.isadmin)); var result = query.FirstOrDefault(); string kq = result.ToString(); return(kq); }