private void btnAccept_Click(object sender, EventArgs e)
{
try
{
string where1 = "IDPhong = N'" + soPhongCu + "'";
DateTime checkIn = Convert.ToDateTime(SQLConnection.SelectOne("NgayDen", "PhieuDatPhong", where1));
DateTime checkOut = Convert.ToDateTime(SQLConnection.SelectOne("NgayDi", "PhieuDatPhong", where1));
int diffDays = SoNgayO(checkIn, checkOut);
string where2 = "IDPhong = N'" + cbPhongMoi.SelectedValue.ToString() + "'";
int tongPhongMoi = diffDays * Convert.ToInt32(SQLConnection.SelectOne("GiaPhong", "Phong", where2));
string _IDPhieuDatPhong = SQLConnection.SelectOne("IDPhieuDatPhong", "PhieuDatPhong", where1);
string where3 = "IDPhieuDatPhong = " + _IDPhieuDatPhong;
int phatDoiPhong = int.Parse(SQLConnection.SelectOne("PhiDoiPhong", "PhieuDatPhong", where1)) + int.Parse(SQLConnection.SelectTS("TS_DoiPhongPhat"));
int soLanDoiPhong = int.Parse(SQLConnection.SelectOne("SoLanDoiPhong", "PhieuDatPhong", where1)) + 1;
string val = "PhiDoiPhong = " + phatDoiPhong + ", SoLanDoiPhong = " + soLanDoiPhong +
", IDPhong = N'" + cbPhongMoi.SelectedValue.ToString() + "'" +
", TongCong = " + tongPhongMoi;
SQLConnection.Update("PhieuDatPhong", val, where3);
string valTrong = "TinhTrang = 0";
string valCoNguoi = "TinhTrang = 1";
SQLConnection.Update("Phong", valTrong, where1);
SQLConnection.Update("Phong", valCoNguoi, where2);
MessageBox.Show("Thành Công!", "Đổi phòng", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDatPhong_Click(object sender, EventArgs e)
{
try
{
string _IDKhachHang = cbCMND.SelectedIndex == 0 ? tbCMND.Text : cbCMND.SelectedValue.ToString();
bool selectedCB = cbCMND.SelectedIndex == 0 ? true : SQLConnection.isExist("KhachHang", "CMND", cbCMND.Text);
if (selectedCB && tbCMND.Text.All(char.IsDigit) && tbSDT.Text.All(char.IsDigit) && tbDatCoc.Text.All(char.IsDigit) && tbSLNguoi.Text.All(char.IsDigit))
{
if ((tbCMND.Text.Equals(string.Empty) || tbName.Text.Equals(string.Empty)) && cbCMND.SelectedIndex == 0)
{
MessageBox.Show("Hãy kiểm tra lại các trường vừa nhập\n\nError: Thiếu thông tin", "Lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string _IDPhong = cbSoPhong.Text;
string _IDMaGiamGia = cbCoupon.SelectedIndex == 0 ? "NULL" : cbCoupon.Text;
string _IDPhieuDatPhong = SQLConnection.IncrID("PhieuDatPhong", "IDPhieuDatPhong").ToString();
//Insert Khách Hàng
if (cbCMND.SelectedIndex == 0)
{
string loaiKH = cbType.SelectedIndex == 0 ? "0" : "1";
string insCol_KH = "IDKhachHang, TenKhachHang, CMND, SDT, Mail, LoaiKhachHang, IDPhieuDatPhong";
string insVal_KH = "'" + _IDKhachHang + "', N'" + tbName.Text + "', '" + tbCMND.Text + "', '" + tbSDT.Text + "', N'" +
tbEmail.Text + "', " + loaiKH + ", " + _IDPhieuDatPhong;
SQLConnection.Insert("KhachHang", insCol_KH, insVal_KH);
}
//Insert Phiếu đặt phòng
string insCol_PDP = "IDPhong, IDKhachHang, SLNguoi, NgayDen, SoTienCoc, IDMaGiamGia, NgayDi, TongCong, IDPhieuDatPhong, PhiDoiPhong, Phi_DichVu, Phi_MonAn, SoLanDoiPhong, DaThanhToan";
string insVal_PDP = "'" + _IDPhong + "', " + "'" + _IDKhachHang + "', " +
"" + tbSLNguoi.Text + ", '" + DateTime.Now.ToString() + "', " + tbDatCoc.Text + ", " +
"'" + _IDMaGiamGia + "', '" + dtpNgayDi.Value.ToString() + "', " + lblTongTien.Text + ", " + _IDPhieuDatPhong + ", 0, 0, 0, 0, 0";
SQLConnection.Insert("PhieuDatPhong", insCol_PDP, insVal_PDP);
if (cbCMND.SelectedIndex != 0)
{
SQLConnection.Update("KhachHang", "IDPhieuDatPhong = " + _IDPhieuDatPhong, "IDKhachHang = " + _IDKhachHang);
}
string updateVal = "TinhTrang = 1";
string updateWhere = "IDPhong LIKE '" + _IDPhong + "'";
SQLConnection.Update("Phong", updateVal, updateWhere);
MessageBox.Show("Thành Công!", "Đặt phòng", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
MessageBox.Show("Hãy kiểm tra lại các trường vừa nhập\n\nError: Sai định dạng", "Lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Hãy kiểm tra lại các trường vừa nhập\n\nError: " + ex.Message, "Lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
SQLConnection.Update("PhieuDatPhong", "DaThanhToan = 1", "IDPhieuDatPhong = " + _IDPhieuDatPhong);
SQLConnection.Update("Phong", "TinhTrang = 0", "IDPHONG LIKE '" + soPhongDat + "'");
SQLConnection.Update("KhachHang", "IDPhieuDatPhong = NULL", "IDKhachHang LIKE '" + _IDKhachHang + "'");
try
{
SQLConnection.Delete("Add_DichVu", "IDPhieuDatPhong = " + _IDPhieuDatPhong);
SQLConnection.Delete("Add_MonAn", "IDPhieuDatPhong = " + _IDPhieuDatPhong);
}
catch { }
InsertDTNgay();
CreateDTThang();
DialogResult result = MessageBox.Show("Thanh toán thành công!", "Thanh Toán", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
this.Close();
}
}