private void loadHoaDon()
{
try
{
double giaPhong = 100000;
dtHoaDon = DTBill.getAllWhere("HOADON", "PHONG = " + txtSoPhong.Tag.ToString() + " AND (TinhTrang = 0 OR TinhTrang = 1)");
string maHD = dtHoaDon.Rows[0]["MaHoaDon"].ToString();
txtSoBill.Text = dtHoaDon.Rows[0]["MaHoaDon"].ToString();
txtPhiDichVu.Text = dtHoaDon.Rows[0]["TongGia"].ToString();
DataTable dtRent = DTRent.getAllWhere("PHIEUTHUE", "MaPhieuThue = " + txtMaPhieuThue.Text);
DateTime dateNgayThue = DateTime.ParseExact(dtRent.Rows[0]["NgayBatDau"].ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
DateTime dateNgayTra = DateTime.ParseExact(dtRent.Rows[0]["NgayKetThuc"].ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
double tienThuePhong = Math.Floor((dateNgayTra - dateNgayThue).TotalHours / 24 * giaPhong);
txtTienThuePhong.Text = tienThuePhong.ToString();
double phuThu = dtKH.Rows[0]["LoaiKHID"].ToString() == "1" ? 0 : (tienThuePhong * 0.1);
txtPhuThu.Text = phuThu.ToString();
txtVAT.Text = ((Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong) * 0.1).ToString();
txtTongTien.Text = (Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong + ((Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong) * 0.1) + phuThu).ToString();
}
catch (Exception)
{
MessageBox.Show("Vui lòng chọn mũi giờ Việt Nam!");
throw;
}
}
private void btnThemDV_Click(object sender, EventArgs e)
{
string maDV = txtDichVuSelect.Text;
if (String.IsNullOrEmpty(maDV))
{
MessageBox.Show("Bạn phải chọn 1 dịch vụ khi thêm!");
}
else
{
string[] values = { txtSoBill.Text, maDV, DateTime.Now.ToString("yyyy-MM-dd"), txtSoPhong.Tag.ToString() };
if (DTBillDetail.create(values))
{
//
//DataRow dr = new DataRow(txtSoBill.Text, maDV, DateTime.Now.ToString("yyyy-MM-dd"), txtSoPhong.Tag.ToString());
DataTable dtCTHD = DTBillDetail.getAllWhere("CHITIETHOADON", "MAHD = " + txtSoBill.Text + " AND Phong = " + txtSoPhong.Tag.ToString());
if (dtCTHD.Rows.Count != 0)
{
string[] arrayDV = new string[dtCTHD.Rows.Count];
for (int i = 0; i < dtCTHD.Rows.Count; i++)
{
arrayDV[i] = dtCTHD.Rows[i]["MaDichVu"].ToString();
}
dtDVSD = DTService.getAllWhere("DICHVU", "MaDichVu in (" + String.Join(",", arrayDV) + ")");
DataColumn[] keysDVSD = new DataColumn[1];
keysDVSD[0] = dtDVSD.Columns[0];
dtDVSD.PrimaryKey = keysDVSD;
gridControlDVSuDung.DataSource = dtDVSD;
decimal giaDVselected = 0;
foreach (DataRow item in dtDVSD.Rows)
{
if (item["MaDichVu"].ToString() == maDV)
{
giaDVselected = Decimal.Parse(item["Gia"].ToString());
}
}
DataTable dtHD = DTBill.getAllWhere("HOADON", "MaHoaDon = " + dtCTHD.Rows[0]["MaHD"].ToString());
if (DTBill.update("TongGia = " + (Decimal.Parse(dtHD.Rows[0]["TongGia"].ToString()) + giaDVselected), "MaHoaDon = " + dtCTHD.Rows[0]["MaHD"].ToString()))
{
//HD
loadHoaDon();
}
else
{
MessageBox.Show("Lỗi Khi cập nhật hóa đơn!");
}
}
else
{
dtDVSD = new DataTable();
gridControlDVSuDung.DataSource = dtDVSD;
}
}
else
{
MessageBox.Show("Lỗi không thêm được dịch vụ!");
}
}
}
