private void TruyenDataVao()
{
_ChiTietDTO = _bus.LayThongTinBaoBieu(this._Id);
lblIDBaoBieu.Text = _ChiTietDTO.IdBaoBieu;
lblIDPhong.Text = _ChiTietDTO.IdPhong;
lblThoiGianDatPhong.Text = _ChiTietDTO.ThoiGianBatDau;
lblThoiGianTraPhong.Text = _ChiTietDTO.ThoiGianKetThuc;
lblChiPhi.Text = Global.Instance().ConvertCurrency(_ChiTietDTO.TongTien.ToString()) + " VND";
PhongBUS phongBus = new PhongBUS();
PhongDTO _phong = phongBus.LayThongTinPhong(_ChiTietDTO.IdPhong);
lblIDPhong.Text = _phong.IdPhong;
lblLoaiPhong.Text = _phong.LoaiPhong.ToString();
KhachHangBUS khBus = new KhachHangBUS();
KhachHangDTO _kh = khBus.LayThongTinKhachHang(_ChiTietDTO.IdKhachHang);
lblTenKhach.Text = _kh.HoTen;
lblCMNDKhach.Text = _kh.Cmnd.ToString();
string[] _arrayDV = _ChiTietDTO.DsDichVu.Split(',');
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.DataSource = dsDichVu(_arrayDV);
//dataGridView1.Columns[0].Visible = false;
}
public List <BaoBieuDTO> LayThongTinBaoBieuTheoIDKhachHang(string _id)
{
List <string[]> _list = new List <string[]>();
List <BaoBieuDTO> _data = new List <BaoBieuDTO>();
string query = string.Format("SELECT * FROM baobieu WHERE IDKhachHang ='{0}'", _id);
_list = DBConnection.getInstance().Select(query);
foreach (var item in _list)
{
BaoBieuDTO _temp = new BaoBieuDTO();
_temp.IdBaoBieu = item[0];
_temp.IdPhong = item[1];
_temp.IdNhanVien = item[2];
_temp.IdKhachHang = item[3];
_temp.ThoiGianBatDau = item[4];
_temp.ThoiGianKetThuc = item[5];
_temp.DsDichVu = item[6];
_temp.TongTien = Int32.Parse(item[7]);
_data.Add(_temp);
}
return(_data);
}
public bool ThemThongTinBaoBieu(BaoBieuDTO dv)
{
//Xu ly nghiep vu
if (_dao.ThemThongTinBaoBieu(dv))
{
return(true);
}
return(false);
}
private void btnChiTiet_Click(object sender, EventArgs e)
{
int tmp = dataGrdV.CurrentCell.RowIndex;
string index = dataGrdV.Rows[tmp].Cells[0].Value.ToString();
BaoBieuDTO _ChiTietDTO = _bus.LayThongTinBaoBieu(index);
BaoBieu frmBaoBieu = new BaoBieu(_ChiTietDTO.IdBaoBieu);
frmBaoBieu.Show();
}
public bool CapNhatThongTinBaoBieu(BaoBieuDTO _baobieu)
{
DateTime dtBD = DateTime.Parse(_baobieu.ThoiGianBatDau);
string mBD = dtBD.ToString("yyyy-MM-dd'T'HH:mm:ss");
DateTime dtKT = DateTime.Parse(_baobieu.ThoiGianKetThuc);
string mKT = dtKT.ToString("yyyy-MM-dd'T'HH:mm:ss");
string query = string.Format("UPDATE baobieu SET IDPhong = '{0}', IDNhanVien = '{1}', IDKhachHang = '{2}', ThoiGianBatDau = '{3}', ThoiGianKetThuc = '{4}', DSDichVu = '{5}', TongTien ='{6}' WHERE IDBaoBieu= '{5}'", _baobieu.IdPhong, _baobieu.IdNhanVien, _baobieu.IdKhachHang, mBD, mKT, _baobieu.DsDichVu, _baobieu.TongTien, _baobieu.IdBaoBieu);
return(DBConnection.getInstance().Update(query) ? true : false);
}
public bool ThemThongTinBaoBieu(BaoBieuDTO _baobieu)
{
DateTime dtBD = DateTime.Parse(_baobieu.ThoiGianBatDau);
string mBD = dtBD.ToString("yyyy-MM-dd'T'HH:mm:ss");
DateTime dtKT = DateTime.Parse(_baobieu.ThoiGianKetThuc);
string mKT = dtKT.ToString("yyyy-MM-dd'T'HH:mm:ss");
string query = string.Format("INSERT INTO baobieu (IDBaoBieu, IDPhong, IDNhanVien, IDKhachHang, ThoiGianBatDau, ThoiGianKetThuc, DSDichVu, TongTien) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", _baobieu.IdBaoBieu, _baobieu.IdPhong, _baobieu.IdNhanVien, _baobieu.IdKhachHang, mBD, mKT, _baobieu.DsDichVu, _baobieu.TongTien);
return(DBConnection.getInstance().Insert(query) ? true : false);
}
public BaoBieuDTO LayThongTinBaoBieu(string _id)
{
List <string[]> _list = new List <string[]>();
BaoBieuDTO _data = new BaoBieuDTO();
string query = string.Format("SELECT * FROM baobieu WHERE IDBaoBieu='{0}'", _id);
_list = DBConnection.getInstance().Select(query);
_data.IdBaoBieu = _list[0][0];
_data.IdPhong = _list[0][1];
_data.IdNhanVien = _list[0][2];
_data.IdKhachHang = _list[0][3];
_data.ThoiGianBatDau = _list[0][4];
_data.ThoiGianKetThuc = _list[0][5];
_data.DsDichVu = _list[0][6];
_data.TongTien = Int32.Parse(_list[0][7]);
return(_data);
}
//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");
}
}
