public bool ThemThongTinPhongDangSuDung(PhongDangSuDungDTO phong)
{
//Xu ly nghiep vu
if (_phongDAO.ThemThongTinPhongDangSuDung(phong))
{
return(true);
}
return(false);
}
//Dat Phong
private void button1_Click(object sender, EventArgs e)
{
//Cap nhat
if (
string.IsNullOrWhiteSpace(txtHoTen.Text) ||
string.IsNullOrWhiteSpace(txtCMND.Text) ||
string.IsNullOrWhiteSpace(txtSDT.Text) ||
string.IsNullOrWhiteSpace(txtNgaySinh.Text)
)
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin của dịch vụ", "Lỗi thông tin",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (!txtCMND.Text.All(char.IsDigit) || !txtSDT.Text.All(char.IsDigit))
{
MessageBox.Show("SDT và CMND phải là số", "Lỗi thông tin",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
KhachHangDTO _data = new KhachHangDTO();
_data.IdKhachHang = Global.Instance().idKhachHang().ToString();
_data.HoTen = txtHoTen.Text;
_data.NgaySinh = txtNgaySinh.Text;
_data.Cmnd = Int32.Parse(txtCMND.Text);
_data.Sdt = Int32.Parse(txtSDT.Text);
if (!_khBus.ThemThongTinKhachHang(_data))
{
MessageBox.Show("Đặt phòng cho kháchh hàng thất bại", "Thất bại",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Đặt phòng thành công", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Luu trạng thái Phong
_phongDTO.TrangThai = "Đang Sử Dụng";
_phongBus.CapNhatThongTinPhong(_phongDTO);
//Luu Phong duoc dat
PhongDangSuDungDTO _pdsdDTO = new PhongDangSuDungDTO();
_pdsdDTO.IdPhong = _phongDTO.IdPhong;
_pdsdDTO.ThoiGianBatDau = txtNgay.Text;
_pdsdDTO.IdKhachHang = _data.IdKhachHang;
_pdsdDTO.DsDichVu = "";
_pdsdDTO.GiaDichVu = 0.ToString();
_phongBus.ThemThongTinPhongDangSuDung(_pdsdDTO);
this.Hide();
TrangChu op = new TrangChu();
op.Show();
}
}
}
}
public bool ThemThongTinPhongDangSuDung(PhongDangSuDungDTO _phong)
{
DateTime dateValue;
if (DateTime.TryParse(_phong.ThoiGianBatDau, out dateValue))
{
string m = dateValue.ToString("yyyy-MM-dd'T'HH:mm:ss");
string query = string.Format("INSERT INTO phong_dangsudung (IDPhong, ThoiGianBatDau, IDKhachHang, DsDichVu,GiaDichVu) VALUES('{0}','{1}','{2}','{3}','{4}')", _phong.IdPhong, m, _phong.IdKhachHang, _phong.DsDichVu, _phong.GiaDichVu);
return(DBConnection.getInstance().Insert(query));
}
return(false);
}
public bool CapNhatThongTinPhongDangSuDung(PhongDangSuDungDTO _phong)
{
//var n = DateTime.Parse(_phong.ThoiGianBatDau);
DateTime dateValue;
if (DateTime.TryParse(_phong.ThoiGianBatDau, out dateValue))
{
string m = dateValue.ToString("yyyy-MM-dd'T'HH:mm:ss");
string query = string.Format("UPDATE phong_dangsudung SET ThoiGianBatDau = '{0}', IDKhachHang = '{1}', DsDichVu = '{2}', GiaDichVu = '{3}' WHERE IDPhong= '{4}'", m, _phong.IdKhachHang.ToString(), _phong.DsDichVu.ToString(), _phong.GiaDichVu, _phong.IdPhong.ToString());
return(DBConnection.getInstance().Update(query));
}
return(false);
}
//Phong Dang Su DUng
public PhongDangSuDungDTO LayThongTinPhongDangSuDung(string _id)
{
List <string[]> _list = new List <string[]>();
PhongDangSuDungDTO _data = new PhongDangSuDungDTO();
string query = string.Format("SELECT * FROM phong_dangsudung WHERE IDPhong='{0}'", _id);
_list = DBConnection.getInstance().Select(query);
_data.IdPhong = _list[0][0];
_data.ThoiGianBatDau = _list[0][1];
_data.IdKhachHang = Int32.Parse(_list[0][2]).ToString();
_data.DsDichVu = _list[0][3];
_data.GiaDichVu = _list[0][4];
return(_data);
}
private void CreateLableChiPhi()
{
this.panel6.Controls.Remove(cp);
PhongBUS _phongBus = new PhongBUS();
PhongDTO _phongDTO = _phongBus.LayThongTinPhong(idPhongClick);
cp = new Label();
cp.Location = new Point(35, 34);
cp.Size = new Size(0, 17);
cp.AutoSize = true;
cp.Font = new Font("Microsoft Sans Serif", 10, FontStyle.Bold | FontStyle.Italic);
if (_phongDTO.TrangThai == "Đang Sử Dụng")
{
PhongDangSuDungDTO phong = _phongBUS.LayThongTinPhongDangSuDung(idPhongClick);
int cpInt = Int32.Parse(phong.GiaDichVu) + (int)_phongDTO.Dongia;
cp.Text = _phongDTO.Dongia.ToString() + " + " + phong.GiaDichVu.ToString() + "DV";
}
else
{
cp.Text = _phongDTO.Dongia.ToString();
}
this.panel6.Controls.Add(cp);
}
private void button1_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if ((bool)row.Cells["Chọn"].Value)
{
dsDv += "," + row.Cells["ID Dịch Vụ"].Value.ToString();
}
//More code here
}
PhongBUS phongBus = new PhongBUS();
PhongDangSuDungDTO p = phongBus.LayThongTinPhongDangSuDung(idPhong);
int s;
if (p.GiaDichVu == "")
{
s = 0;
}
else
{
s = Int32.Parse(p.GiaDichVu);
}
p.GiaDichVu = (s + tongChiPhi).ToString();
p.DsDichVu += dsDv;
// string str = p.ThoiGianBatDau.ToString("mm/dd/yyyy");
phongBus.CapNhatThongTinPhongDangSuDung(p);
// Observer Pattern
TrangChu op = new TrangChu();
op.onSubmit(dsDv, tongChiPhi, idPhong);
this.Close();
op.Show();
//
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Control control = sender as Control;
string ds = "";
// _phongBUS
PhongDangSuDungDTO _pdsdDTO = _phongBUS.LayThongTinPhongDangSuDung(idPhongClick);
int index = _pdsdDTO.DsDichVu.IndexOf(control.Name.ToString());
// MessageBox.Show(index.ToString());
string[] array = _pdsdDTO.DsDichVu.Split(',');
var listString = new List <string>(array);
foreach (var item in listString)
{
if (item == control.Name)
{
listString.Remove(item);
DichVuBUS dvBus = new DichVuBUS();
DichVuDTO dvDTO = dvBus.LayThongTinDichVu(item);
_pdsdDTO.GiaDichVu = (Int32.Parse(_pdsdDTO.GiaDichVu) - (int)dvDTO.Gia).ToString();
break;
}
}
foreach (var item in listString)
{
ds += "," + item.ToString();
}
if (ds != "")
{
ds = ds.Remove(0, 1);
}
_pdsdDTO.DsDichVu = ds;
_phongBUS.CapNhatThongTinPhongDangSuDung(_pdsdDTO);
LoadDichDvu(_pdsdDTO.DsDichVu);
CreateLableChiPhi();
}
public bool CapNhatThongTinPhongDangSuDung(PhongDangSuDungDTO phong)
{
return(_phongDAO.CapNhatThongTinPhongDangSuDung(phong));
}
protected void pnlPhong_Click(object sender, EventArgs e)
{
this.panel5.Controls.Remove(_panelDivhVu);
Control control = sender as Control;
// string idPhong = sender;
//MessageBox.Show(control.Name);
_panelData.Controls.Remove(_panelActive);
idPhongClick = control.Name;
Control _controlParent = control.Parent;
_panelActive = new Panel();
_panelActive.Location = new Point(control.Parent.Location.X - 5, control.Parent.Location.Y - 5);
_panelActive.BackColor = Color.Orange;
_panelActive.Size = new Size(130, 130);
_panelData.Controls.Add(_panelActive);
CreateLableChiPhi();
//MessageBox.Show(control.Parent.Location.X.ToString());
PhongBUS _phongBus = new PhongBUS();
PhongDTO _phongDTO = _phongBus.LayThongTinPhong(idPhongClick);
txtIDPhong.Text = _phongDTO.IdPhong;
//Cong voi DIch vu
txtLoaiPhong.Text = _phongDTO.LoaiPhong.ToString();
txtTinhTrang.Text = _phongDTO.TrangThai;
if (_phongDTO.TrangThai == "Đang Sử Dụng")
{
trangThaiPhong = 1;
PhongDangSuDungDTO _p = _phongBUS.LayThongTinPhongDangSuDung(idPhongClick);
txtThoiGianDatPhong.Text = _p.ThoiGianBatDau;
KhachHangBUS _khBus = new KhachHangBUS();
KhachHangDTO _KhDTO = _khBus.LayThongTinKhachHang(_p.IdKhachHang.ToString());
txtTenKH.Text = _KhDTO.HoTen;
//Load Dich Vu
LoadDichDvu(_p.DsDichVu);
}
else
{
txtThoiGianDatPhong.Text = "Trống";
txtTenKH.Text = "Trống";
if (_phongDTO.TrangThai == "Còn Trống")
{
trangThaiPhong = 0;
}
else
{
trangThaiPhong = -1;
}
}
}
//Tra Phong
private void button11_Click(object sender, EventArgs e)
{
if (trangThaiPhong == 1)
{
PhongDTO phong = _phongBUS.LayThongTinPhong(idPhongClick);
DateTime dtNow = DateTime.Now;
PhongDangSuDungDTO _pdsdDTO = new PhongDangSuDungDTO();
_pdsdDTO = _phongBUS.LayThongTinPhongDangSuDung(idPhongClick);
string[] _array = _pdsdDTO.DsDichVu.Split(',');
DichVuBUS _dvBus = new DichVuBUS();
List <DichVuDTO> _dvDTO = new List <DichVuDTO>();
foreach (var item in _array)
{
DichVuDTO _dv = _dvBus.LayThongTinDichVu(item);
if (_dv != null)
{
_dvDTO.Add(_dv);
}
}
string idPhong = "\n ID Phòng: " + idPhongClick;
string tenPhong = "\n Tên Phòng: " + phong.TenPhong;
string ngayDatPhong = "\n Thời gian Đặt Phòng: " + txtThoiGianDatPhong.Text;
string ngayTraPhong = "\n Thời gian Trả Phòng: " + dtNow.ToString();
string dsDV_ThanhToan = "\n Danh sách dịch vụ sử dụng:";
int sDichVu = 0;
foreach (var item in _dvDTO)
{
dsDV_ThanhToan += "\n + " + item.TenDichVu;
sDichVu += (int)item.Gia;
}
DateTime dtBatDau = DateTime.Parse(txtThoiGianDatPhong.Text);
TimeSpan span = dtNow - dtBatDau;
double TongHoaDon = (span.TotalMinutes / 60) * (phong.Dongia) + sDichVu;
string s = Global.Instance().ConvertCurrency(TongHoaDon.ToString());
string chiphi = "\n Tổng hóa đơn: " + s + " VND";
DialogResult dialogResult = MessageBox.Show("Bạn muốn thanh toán hóa đơn với:" + idPhong + tenPhong + ngayDatPhong + ngayTraPhong + dsDV_ThanhToan + chiphi, "Thanh Toán", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
BaoBieuDTO baoBieu = new BaoBieuDTO();
baoBieu.IdBaoBieu = Global.Instance().idBaoBieu();
baoBieu.IdPhong = idPhongClick;
baoBieu.IdNhanVien = "1";
baoBieu.IdKhachHang = _pdsdDTO.IdKhachHang;
baoBieu.DsDichVu = _pdsdDTO.DsDichVu;
baoBieu.ThoiGianBatDau = txtThoiGianDatPhong.Text;
baoBieu.ThoiGianKetThuc = dtNow.ToString();
baoBieu.TongTien = (float)TongHoaDon;
BaoBieuBUS _baobieuBUs = new BaoBieuBUS();
_baobieuBUs.ThemThongTinBaoBieu(baoBieu);
_phongBUS.XoaThongTinPhongDangSuDung(idPhongClick);
//Cap nhat thong tin Phong
PhongDTO _phongCapNhat = _phongBUS.LayThongTinPhong(idPhongClick);
_phongCapNhat.TrangThai = "Còn Trống";
_phongBUS.CapNhatThongTinPhong(_phongCapNhat);
LoadData(state);
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
else
{
MessageBox.Show("Phòng đang sử dụng mới được trả phòng", "Thông báo");
}
}
