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