public BaoGia_All PrintBanHang(string masobh)
{
var data = db.Database.SqlQuery <GetAll_ThongTinChungDonBanHang_Result>("GetAll_ThongTinChungDonBanHang @masoBH", new SqlParameter("masoBH", masobh));
var resultdata = data.FirstOrDefault();
var query = db.Database.SqlQuery <GetAll_ChiTiet_DonBanHang_Result>("GetAll_ChiTiet_DonBanHang @masoBH", new SqlParameter("masoBH", masobh));
var resultquery = query.ToList();
BaoGia_All banhang = new BaoGia_All();
banhang.BanHang = resultdata;
banhang.CTBanHang = resultquery;
return(banhang);
}
public BaoGia_All PrintBaoGia(string sobaogia)
{
var data = db.Database.SqlQuery <Prod_BH_GetThongTinBaoGia_Result>("Prod_BH_GetThongTinBaoGia @so_bao_gia", new SqlParameter("so_bao_gia", sobaogia));
var resultdata = data.FirstOrDefault();
var query = db.Database.SqlQuery <Prod_BH_GetThongTin_CT_BaoGia_Result>("Prod_BH_GetThongTin_CT_BaoGia @so_bao_gia", new SqlParameter("so_bao_gia", sobaogia));
var resultquery = query.ToList();
BaoGia_All baogia = new BaoGia_All();
baogia.BG = resultdata;
baogia.CTBG = resultquery;
return(baogia);
}