private void bt_Them_Click(object sender, EventArgs e)
{
List <DTO_DichVu> lsobj_dv = new List <DTO_DichVu>();
string result = this.bus_dv.SelectAll(lsobj_dv);
var selectitemDV = from x in lsobj_dv
where x.Tendv == DropDown_DV.selectedValue
select new
{
MaDV = x.Madv,
TenDV = x.Tendv,
GiaDV = x.Giadv
};
foreach (var item in selectitemDV)
{
DTO_CTDV obj_ctdv = new DTO_CTDV();
obj_ctdv.Macthd = get_MaCTHD;
obj_ctdv.Madv = item.MaDV;
if (bus_ctdv.Insert(obj_ctdv) != "0")
{
MessageBox.Show("Đã thêm dịch vụ này", "Lỗi thêm dịch vụ");
return;
}
GUI_NghiepVuPhong.GUI_ListDV x1DV = new GUI_NghiepVuPhong.GUI_ListDV();
x1DV.lb_MaDV.Text = item.MaDV;
x1DV.lb_TenDV.Text = item.TenDV;
x1DV.lb_GiaDV.Text = item.GiaDV;
panel_ListDV.Controls.Add(x1DV);
x1DV.Dock = DockStyle.Top;
x1DV.Message = obj_ctdv.Macthd;
}
}
private void ShowThanhToan()
{
panelshow_ListDV.Controls.Clear();
List <DTO_LoaiPhong> lsobj_lp = new List <DTO_LoaiPhong>();
List <DTO_Phong> lsobj_p = new List <DTO_Phong>();
List <DTO_CTHD> lsobj_cthd = new List <DTO_CTHD>();
List <DTO_CTDV> lsobj_ctdv = new List <DTO_CTDV>();
List <DTO_DichVu> lsobj_dv = new List <DTO_DichVu>();
string result = bus_cthd.selectAll(lsobj_cthd);
string result1 = bus_p.SelectAll(lsobj_p);
string result2 = bus_lp.SelectAll(lsobj_lp);
string result3 = bus_ctdv.SelectAll(lsobj_ctdv);
string result4 = bus_dv.SelectAll(lsobj_dv);
var query = (from lp in lsobj_lp
join p in lsobj_p on lp.Malp equals p.Malp
join cthd in lsobj_cthd on p.Sophong equals cthd.Sophong
select new
{
TenLP = lp.Tenlp,
GiaLP = lp.Gia
});
foreach (var item in query)
{
txbTT_LoaiPhong.Text = item.TenLP;
txbTT_Gia.Text = item.GiaLP;
}
tongtien = tongtien + Convert.ToInt32(txbTT_Gia.Text);
var query2 = (from dv in lsobj_dv
join ctdv in lsobj_ctdv on dv.Madv equals ctdv.Madv
where ctdv.Macthd == get_MaCTHD
select new
{
TenDV = dv.Tendv,
MaDV = dv.Madv,
GiaDV = dv.Giadv
}
);
foreach (var item in query2)
{
GUI_NghiepVuPhong.GUI_ListDV x1DV = new GUI_NghiepVuPhong.GUI_ListDV();
x1DV.lb_MaDV.Text = item.MaDV;
x1DV.lb_TenDV.Text = item.TenDV;
x1DV.lb_GiaDV.Text = item.GiaDV;
tongtien = tongtien + Convert.ToInt32(x1DV.lb_GiaDV.Text);
x1DV.bt_Xoa.Visible = false;
panelshow_ListDV.Controls.Add(x1DV);
x1DV.Dock = DockStyle.Top;
}
}
