public int AddTraPhong(BEL_TraPhong tp) { string sql = "INSERT INTO [dbo].[TraPhong] VALUES( @matraphong , @makh , @sophong , @ngaytra )"; int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { tp.Matraphong, tp.Makh, tp.Sophong, tp.Ngaytra }); return(result); }
public rpHoaDon(string makh, string sophong, BEL_DatPhong dp, BEL_KhachHang kh, BEL_TraPhong tp, BEL_HoaDonThue hd) { InitializeComponent(); this.makh = makh; this.sophong = sophong; this.dp = dp; this.kh = kh; this.tp = tp; this.hd = hd; }
public List <BEL_TraPhong> LoadListTraPhong() { List <BEL_TraPhong> list = new List <BEL_TraPhong>(); DataTable data = DAL_TraPhong.Instance.LoadListTraPhong(); foreach (DataRow row in data.Rows) { BEL_TraPhong item = new BEL_TraPhong(row); list.Add(item); } return(list); }
private void btnTPXuat_Click(object sender, EventArgs e) { if (cbbTPSoPhong.Text != "" && txtTPMaTP.Text != "") { if (BAL_TraPhong.Instansce.KiemTraTonTai(txtTPMaTP.Text) == false) { string sophong = cbbTPSoPhong.Text; BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong); BEL_KhachHang kh = BAL_KhachHang.Instance.LoadKhachHangTheoMa(dp.MaKH); BEL_TraPhong tp = new BEL_TraPhong(txtTPMaTP.Text, kh.MaKH, dp.SoPhong, DateTime.Now); BEL_HoaDonThue hd = BAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(dp.MaDatPhong); BEL_HoaDonDichVu dv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(kh.MaKH); if (dv != null) { if (txtTPThanhTien.Text == "0") { hd.Tongtien = (float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien); } else { if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc) { hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien); } else { hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc) + float.Parse(dv.Thanhtien); } } } else { if (txtTPThanhTien.Text == "0") { hd.Tongtien = (float.Parse(txtTPThanhTien.Text)); } else { if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc) { hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text)); } else { hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc); } } } hd.Matraphong = txtTPMaTP.Text; rpHoaDon rp = new rpHoaDon(dp.MaKH, sophong, dp, kh, tp, hd); rp.ShowDialog(); } else { MessageBox.Show("Trùng mã đặt phòng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy điền đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool AddTraPhong(BEL_TraPhong tp) { int result = DAL_TraPhong.Instance.AddTraPhong(tp); return(result > 0); }