private void cboPhongChuyen_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int maPhongMoi = (int)cboPhongChuyen.SelectedValue;
int maPhongCu = Int32.Parse(txtSoPhong.Tag.ToString());
if (QLThuePhong.updateTrangThaiPhong(maPhongCu, -1) && QLThuePhong.updateTrangThaiPhong(maPhongMoi, 1))
{
MessageBox.Show("Chuyển Thành Công!");
lblPhongChuyen.Visible = false;
cboPhongChuyen.Visible = false;
btnDatPhong.Enabled = true;
btnChuyenPhong.Enabled = false;
btnThayDoiThongTin.Enabled = false;
btnInPhieuThuePhong.Enabled = false;
}
else
{
MessageBox.Show("Có Lỗi Trong Quá Trình Chuyển Phòng!");
}
loadGalleryPhong();
}
catch (Exception)
{
cboPhongChuyen.SelectedValue = null;
throw;
}
}
public void loadGalleryPhong()
{
dt = QLThuePhong.getAll();
galleryControl1.Gallery.Groups[0].Items.Clear();
Bitmap image;
foreach (DataRow dr in dt.Rows)
{
int tinhTrang = Int32.Parse(dr["TinhTrangPhong"].ToString());
if (tinhTrang == 1)
{
image = new Bitmap(Properties.Resources.close);
}
else if (tinhTrang == 0)
{
image = new Bitmap(Properties.Resources.checkInRom);
}
else
{
image = new Bitmap(Properties.Resources.open);
}
GalleryItem item = new GalleryItem(image, dr["TenPhong"].ToString(), dr["MoTaPhong"].ToString() == "" ? "Ghi Chú" : dr["MoTaPhong"].ToString());
item.Tag = dr["MaPhong"].ToString() + "_" + dr["TinhTrangPhong"].ToString().Trim();
galleryControl1.Gallery.Groups[0].Items.Add(item);
}
}
private void btnChuyenPhong_Click(object sender, EventArgs e)
{
dt = QLThuePhong.getAll();
lblPhongChuyen.Visible = true;
cboPhongChuyen.DataSource = dt;
cboPhongChuyen.DisplayMember = "TenPhong";
cboPhongChuyen.ValueMember = "MaPhong";
cboPhongChuyen.Visible = true;
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrWhiteSpace(DTRent.getAllWhere("PHIEUTHUE", "MaPhieuThue = " + txtMaPhieuThue.Text.ToString()).Rows[0]["NgayKetThuc"].ToString()))
{
DTRent.update("NgayKetThuc = '" + DateTime.ParseExact(dtNgayTra.Text, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd HH:mm:ss") + "'", "MaPhieuThue = " + txtMaPhieuThue.Text.ToString());
}
loadHoaDon();
DTBill.update("TinhTrang = 2", "MaHoaDon = " + txtSoBill.Text);
Phong.update("PHONG", "TinhTrangPhong = -1", "MaPhong = " + txtSoPhong.Tag.ToString());
DTRent.update("TinhTrangPhieuThue = 2", "MaPhieuThue = " + txtMaPhieuThue.Text.ToString());
//load lại danh sách phòng
dt = QLThuePhong.getAll();
galleryControl1.Gallery.Groups[0].Items.Clear();
Bitmap image;
foreach (DataRow dr in dt.Rows)
{
int tinhTrang = Int32.Parse(dr["TinhTrangPhong"].ToString());
if (tinhTrang == 1)
{
image = new Bitmap(Properties.Resources.close);
}
else if (tinhTrang == 0)
{
image = new Bitmap(Properties.Resources.checkInRom);
}
else
{
image = new Bitmap(Properties.Resources.open);
}
GalleryItem item = new GalleryItem(image, dr["TenPhong"].ToString(), dr["MoTaPhong"].ToString() == "" ? "Ghi Chú" : dr["MoTaPhong"].ToString());
item.Tag = dr["MaPhong"].ToString() + "_" + dr["TinhTrangPhong"].ToString().Trim();
galleryControl1.Gallery.Groups[0].Items.Add(item);
}
MessageBox.Show("Thanh Toán Thành Công!");
}
catch (Exception)
{
MessageBox.Show("Lỗi Trong Quá trình thanh toán");
throw;
}
}
