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; } }