public DataTable DataTable_DSP(List <PhieuCheckIn_Ent> dsPCI)
{
Phong_WCFClient ph_wcf = new Phong_WCFClient();
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
DichVu_WCFClient dv_wcf = new DichVu_WCFClient();
DataTable dt = new DataTable();
dt.Columns.Add("Mã Phiếu Check In", typeof(string));
dt.Columns.Add("Loại Phòng", typeof(string));
dt.Columns.Add("Số Phòng", typeof(string));
dt.Columns.Add("Họ Tên Khách Hàng", typeof(string));
dt.Columns.Add("Thời Gian Check In", typeof(string));
dt.Columns.Add("Thời gian Check Out", typeof(string));
dt.Columns.Add("Tên Dịch Vụ", typeof(string));
dt.Columns.Add("Số Lượng Dịch Vụ", typeof(string));
foreach (PhieuCheckIn_Ent p_ent in dsPCI)
{
string nameServ = dv_wcf.GetTenDichVu_byIdDichVu(p_ent.Id_DichVu);
dt.Rows.Add(p_ent.Id_phieu_checkin, ph_wcf.GetTenLoaiPhong_by_IDLoai(p_ent.Id_Phong), ph_wcf.getsoPhong_byID(p_ent.Id_Phong), kh_wcf.getHoKhacHang_byID(p_ent.Id_khach) + " " + kh_wcf.getTenKhacHang_byID(p_ent.Id_khach),
p_ent.Gio_check_in + " " + p_ent.Ngay_check_in.ToShortDateString(), p_ent.Gio_check_out + " " + p_ent.Ngay_check_out.ToShortDateString(), nameServ, p_ent.SoLuongDichVu.ToString());
}
return(dt);
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh_ent = kh_wcf.GetKhachHang_byCMND(txtTimKiem.Text.Trim());
if (kh_ent == null)
{
ClearTextBox();
return;
}
foreach (var item in kh_wcf.TimKiem_KhachHang_by_CMND(txtTimKiem.Text.Trim()))
{
maKH = item.Id_khach.ToString();
txtHo.Text = item.Ho;
txtTen.Text = item.Ten;
txtCMND.Text = item.So_cmnd;
txtQuocTich.Text = item.Quoc_tich;
if (item.Gioi_tinh.Equals("Nam"))
{
cboGioiTinh.Text = "Nam";
}
else
{
cboGioiTinh.Text = "Nữ";
}
txtSDT.Text = item.Sodienthoai;
dtpNgaySinh.Text = item.Date_of_birth.ToString();
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh_ent = kh_wcf.GetKhachHang_byCMND(txtTimKiem.Text.Trim());
if (kh_ent == null)
{
MessageBox.Show("Kiểm Tra Lại !", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
txtHo.Text = kh_ent.Ho.Trim();
txtTen.Text = kh_ent.Ten.Trim();
txtSDT.Text = kh_ent.Sodienthoai.Trim();
txtCMND.Text = kh_ent.So_cmnd.Trim();
if (kh_ent.Gioi_tinh.Equals("Nam"))
{
cboGioiTinh.Text = "Nam";
}
else
{
cboGioiTinh.Text = "Nữ";
}
txtQuocTich.Text = kh_ent.Quoc_tich.Trim();
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
if (txtTimKiem.Text.Trim() == "")
{
return;
}
else
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
List <KhachHang_Ent> dsKhachHang = kh_wcf.TimKiem_KhachHang_by_CMND(txtTimKiem.Text.Trim()).ToList();
PhieuCheckIn_WCFClient pck_wcf = new PhieuCheckIn_WCFClient();
try
{
if (pck_wcf.isKhachThue(dsKhachHang[0].Id_khach))
{
PhieuCheckIn_WCFClient p_wcf = new PhieuCheckIn_WCFClient();
List <PhieuCheckIn_Ent> lstP = pck_wcf.GetPhieuCheckIns_NoCheckOut_byIDKhach(dsKhachHang[0].Id_khach).ToList();
loaDataToGridView(DataTable_DSPhieu(lstP));
Custom_DataGridView(dgv_DSPhieuCheckIn);
}
else
{
MessageBox.Show("Khách Này Đã Trả Phòng", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
MessageBox.Show("Không Tồn Tại", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnReload_Click(object sender, EventArgs e)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
List <KhachHang_Ent> dsKhachHang = kh_wcf.GetKhachHangs().ToList();
Loading_DSKH(DataTable_DSKH(dsKhachHang));
Custom_DataGridView(dgv_DSKhachHang);
}
private void frmQLKhachHang_Load(object sender, EventArgs e)
{
btnReload.Image = imgs_Button.Images[0];
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
List <KhachHang_Ent> dsKH = kh_wcf.GetKhachHangs().ToList();
Loading_DSKH(DataTable_DSKH(dsKH));
Custom_DataGridView(dgv_DSKhachHang);
}
private void Luu_Sua()
{
if (!CheckNull())
{
MessageBox.Show("Chưa Nhập Đủ Thông Tin", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();;
KhachHang_Ent kh = new KhachHang_Ent();
kh.Id_khach = khach.Id_khach;
kh.Ho = txtHo.Text.Trim();
kh.Ten = txtTen.Text.Trim();
kh.So_cmnd = txtCMND.Text.Trim();
kh.Sodienthoai = txtSoDT.Text.Trim();
kh.Quoc_tich = cbx_QuocTich.Text.Trim();
if (cbx_GioiTinh.SelectedIndex == 1)
{
kh.Gioi_tinh = "nam";
}
else
{
kh.Gioi_tinh = "nu";
}
kh.Date_of_birth = dtp_NgaySinh.Value;
if (kh_wcf.CapNhatKhachHang(kh))
{
DialogResult ds = MessageBox.Show("Lưu Thành Công, Tiếp Tục ?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ds == DialogResult.Yes)
{
return;
}
else
{
this.Close();
}
}
else
{
DialogResult ds = MessageBox.Show("Lưu Thất Bại, Thử Lại ?", "LỖI", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (ds == DialogResult.Yes)
{
return;
}
else
{
this.Close();
}
}
}
}
private void autoCompleteSource()
{
txtTimKiem.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtTimKiem.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtTimKiem.AutoCompleteCustomSource.Clear();
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
foreach (KhachHang_Ent item in kh_wcf.GetKhachHangs())
{
txtTimKiem.AutoCompleteCustomSource.Add(item.So_cmnd.Trim());
}
}
private void frmTextKhachHang_FormClosing(object sender, FormClosingEventArgs e)
{
if (isShortCutCreate)
{
return;
}
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
frmQLKH.Loading_DSKH(frmQLKH.DataTable_DSKH(kh_wcf.GetKhachHangs().ToList()));
frmQLKH.Custom_DataGridView(frmQLKH.dgv_DSKhachHang);
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
if (txtTimKiem.Text.Trim() == "")
{
return;
}
else
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
List <KhachHang_Ent> dsKhachHang = kh_wcf.TimKiem_KhachHang_by_CMND(txtTimKiem.Text.Trim()).ToList();
Loading_DSKH(DataTable_DSKH(dsKhachHang));
Custom_DataGridView(dgv_DSKhachHang);
}
}
private void btnSuaKH_Click(object sender, EventArgs e)
{
if (dgv_DSKhachHang.SelectedRows.Count == 1)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh = kh_wcf.GetKhachHang_byCMND(dgv_DSKhachHang.SelectedRows[0].Cells[4].Value.ToString().Trim());
frmTextKhachHang frm = new frmTextKhachHang(this, "Sửa Khách Hàng", kh);
frm.ShowDialog();
}
else
{
MessageBox.Show("Chọn 1 Nhân Viên Cần Sửa", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
return;
}
}
private void txtSoPhong_TextChanged(object sender, EventArgs e)
{
Phong_WCFClient p_wcf = new Phong_WCFClient();
PhieuCheckIn_WCFClient pck_wcf = new PhieuCheckIn_WCFClient();
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
int idKhach = 0;
int idPhong = p_wcf.GetIDPhong_by_SoPhong(txtSoPhong.Text.Trim());
foreach (var item in pck_wcf.GetPhieuCheckIns())
{
if (item.Id_Phong == idPhong && item.TrangThaiHoaDon == 0)
{
idKhach = item.Id_khach;
break;
}
}
txtHoTenKH.Text = kh_wcf.getHoKhacHang_byID(idKhach) + " " + kh_wcf.getTenKhacHang_byID(idKhach);
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
DichVu_WCFClient dv_wcf = new DichVu_WCFClient();
Phong_WCFClient p_wcf = new Phong_WCFClient();
PhieuCheckIn_WCFClient pck_wcf = new PhieuCheckIn_WCFClient();
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
PhieuCheckIn_Ent p_dv_ent = new PhieuCheckIn_Ent();
int idPhong = p_wcf.GetIDPhong_by_SoPhong(txtSoPhong.Text.Trim());
if (txtSoPhong.Text.Trim().Equals(""))
{
MessageBox.Show("Nhập Số Phòng", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int idKhach = 0;
foreach (var item in pck_wcf.GetPhieuCheckIns())
{
if (item.Id_Phong == idPhong && item.TrangThaiHoaDon == 0)
{
idKhach = item.Id_khach;
}
}
PhieuCheckIn_Ent p_ent = new PhieuCheckIn_Ent();
foreach (var item in pck_wcf.GetPhieuCheckIns().ToList())
{
if (item.Id_khach == idKhach)
{
p_ent.Ngay_check_in = item.Ngay_check_in;
p_ent.Gio_check_in = item.Gio_check_in;
p_ent.Ngay_check_out = item.Ngay_check_out;
p_ent.Gio_check_out = item.Gio_check_out;
p_ent.Giam_gia = item.Giam_gia;
p_ent.SoLuongKhach = item.SoLuongKhach;
}
}
int checkLoi = 0;
for (int i = 0; i < dgvCTDV.Rows.Count - 1; i++)
{
p_dv_ent.Id_Phong = idPhong;
p_dv_ent.Id_khach = Convert.ToInt32(idKhach);
p_dv_ent.Id_NhanVien = idNhanVien;
p_dv_ent.Id_DichVu = dv_wcf.GetIDDichVu_byTenDV(dgvCTDV.Rows[i].Cells[0].Value.ToString());
p_dv_ent.SoLuongDichVu = Convert.ToInt32(dgvCTDV.Rows[i].Cells[1].Value);
p_dv_ent.Ngay_check_in = (DateTime)p_ent.Ngay_check_in;
p_dv_ent.Gio_check_in = p_ent.Gio_check_in;
p_dv_ent.Ngay_check_out = p_ent.Ngay_check_out;
p_dv_ent.Gio_check_out = p_ent.Gio_check_out;
p_dv_ent.Giam_gia = p_ent.Giam_gia;
p_dv_ent.SoLuongKhach = p_ent.SoLuongKhach;
p_dv_ent.TrangThaiHoaDon = 1;
p_dv_ent.SoLuongDichVu = Convert.ToInt32(dgvCTDV.Rows[i].Cells[1].Value.ToString().Trim());
if (!pck_wcf.ThemPhieuCheckIn_DichVu(p_dv_ent))
{
checkLoi = 1;
MessageBox.Show("Có Lỗi Xảy Ra!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
if (checkLoi == 0)
{
MessageBox.Show("Lưu Thành Công", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
//DataTable
public DataTable DataTable_DSP(List <PhieuCheckIn_Ent> dsPCI)
{
Phong_WCFClient ph_wcf = new Phong_WCFClient();
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
DichVu_WCFClient dv_wcf = new DichVu_WCFClient();
DataTable dt = new DataTable();
dt.Columns.Add("Mã Phiếu Check In", typeof(string));
dt.Columns.Add("Loại Phòng", typeof(string));
dt.Columns.Add("Số Phòng", typeof(string));
dt.Columns.Add("Họ Tên Khách Hàng", typeof(string));
dt.Columns.Add("Thời Gian Check In", typeof(string));
dt.Columns.Add("Thời gian Check Out", typeof(string));
dt.Columns.Add("Tên Dịch Vụ", typeof(string));
dt.Columns.Add("Số Lượng Dịch Vụ", typeof(string));
dt.Columns.Add("Tổng Tiền", typeof(string));
dt.Columns.Add("Tình Trạng", typeof(string));
//Lọc Dữ Liệu Phiếu Đặt Phòng và Phiếu Mua Bán Dịch Vụ
foreach (PhieuCheckIn_Ent p_ent in dsPCI)
{
string nameServ = dv_wcf.GetTenDichVu_byIdDichVu(p_ent.Id_DichVu);
if (p_ent.Id_DichVu != 0)
{
string tinhTrang = "";
if (p_ent.TrangThaiHoaDon == 0)
{
tinhTrang = "Chưa Thanh Toán";
}
if (p_ent.TrangThaiHoaDon == 1)
{
tinhTrang = "Đã Thanh Toán";
}
dt.Rows.Add(p_ent.Id_phieu_checkin, ph_wcf.GetTenLoaiPhong_by_IDLoai(p_ent.Id_Phong), ph_wcf.getsoPhong_byID(p_ent.Id_Phong), kh_wcf.getHoKhacHang_byID(p_ent.Id_khach) + " " + kh_wcf.getTenKhacHang_byID(p_ent.Id_khach),
p_ent.Gio_check_in + " " + p_ent.Ngay_check_in.ToShortDateString(), p_ent.Gio_check_out + " " + p_ent.Ngay_check_out.ToShortDateString(), nameServ, p_ent.SoLuongDichVu.ToString(), (p_ent.SoLuongDichVu * dv_wcf.GetGiaDichVu_byIdDichVu(p_ent.Id_DichVu)), tinhTrang);
}
else
{
TimeSpan date = p_ent.Ngay_check_out - p_ent.Ngay_check_in;
decimal donGia = ph_wcf.DonGia(ph_wcf.GetIDLoaiPhong_by_IDPhong(p_ent.Id_Phong).ToString());
string tienPhong = (donGia * Convert.ToInt32(date.Days)).ToString();
string tinhTrang = "";
if (p_ent.TrangThaiHoaDon == 0)
{
tinhTrang = "Trống";
}
if (p_ent.TrangThaiHoaDon == 1)
{
tinhTrang = "Có Khách";
}
dt.Rows.Add(p_ent.Id_phieu_checkin, ph_wcf.GetTenLoaiPhong_by_IDLoai(p_ent.Id_Phong), ph_wcf.getsoPhong_byID(p_ent.Id_Phong), kh_wcf.getHoKhacHang_byID(p_ent.Id_khach) + " " + kh_wcf.getTenKhacHang_byID(p_ent.Id_khach),
p_ent.Gio_check_in + " " + p_ent.Ngay_check_in.ToShortDateString(), p_ent.Gio_check_out + " " + p_ent.Ngay_check_out.ToShortDateString(), nameServ, p_ent.SoLuongDichVu.ToString(), tienPhong, tinhTrang);
}
}
return(dt);
}
