public static List <NhanVienBUS> timkiemNhanVienTrongDoan(DoanBUS doan, String keyword)
{
List <NhanVienBUS> dsNhanVien = new List <NhanVienBUS>();
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand("proc_timkiemNhanVienTrongDoan", connection.getConnection()))
{
connection.open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
command.Parameters.AddWithValue("@keyword", keyword.ToUpper());
var reader = command.ExecuteReader();
while (reader.Read())
{
NhanVienBUS nhanvien = new NhanVienBUS();
nhanvien.MaNhanVien = reader["maNhanVien"].ToString();
nhanvien.TenNhanVien = reader["tenNhanVien"].ToString();
nhanvien.Gioitinh = reader["gioitinh"].ToString();
nhanvien.Cmnd = reader["cmnd"].ToString();
nhanvien.Diachi = reader["diachi"].ToString();
nhanvien.Sdt = reader["sdt"].ToString();
nhanvien.Chucvu.MaChucVu = reader["maChucVu"].ToString();
nhanvien.Chucvu.TenChucVu = reader["tenChucVu"].ToString();
dsNhanVien.Add(nhanvien);
}
reader.Close();
connection.close();
}
return(dsNhanVien);
}
public static bool Them(ChiPhiBUS chiphi, DoanBUS doan)
{
int result = 0;
Connection connection = new Connection();
String query = "insert into ChiPhi (tien,maLoaiChiPhi,maDoan,thoigian) values (@sotien,@maloaichiphi,@madoan,@thoigian)";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@sotien", chiphi.Tien);
command.Parameters.AddWithValue("@thoigian", chiphi.Thoigian);
command.Parameters.AddWithValue("@maloaichiphi", chiphi.LoaiChiPhi.MaLoaiChiPhi);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
result = command.ExecuteNonQuery();
connection.close();
}
if (result == 1)
{
using (SqlCommand command = new SqlCommand("select max(maChiPhi) as myid from ChiPhi", connection.getConnection()))
{
connection.open();
var reader = command.ExecuteReader();
reader.Read();
chiphi.MaChiPhi = int.Parse(reader["myid"].ToString());
connection.close();
}
}
return(result == 1);
}
public static List <KhachHangBUS> timkiemKhachHangTrongDoan(DoanBUS doan, String keyword)
{
List <KhachHangBUS> dsKhachHang = new List <KhachHangBUS>();
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand("proc_timkiemKhachHangTrongDoan", connection.getConnection()))
{
connection.open();
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
command.Parameters.AddWithValue("@keyword", keyword.ToUpper());
var reader = command.ExecuteReader();
while (reader.Read())
{
KhachHangBUS khachhang = new KhachHangBUS();
khachhang.MaKhachHang = reader["maKhachHang"].ToString();
khachhang.TenKhachHang = reader["tenKhachHang"].ToString();
khachhang.Gioitinh = reader["gioitinh"].ToString();
khachhang.Cmnd = reader["cmnd"].ToString();
khachhang.Diachi = reader["diachi"].ToString();
khachhang.Sdt = reader["sdt"].ToString();
dsKhachHang.Add(khachhang);
}
reader.Close();
connection.close();
}
return(dsKhachHang);
}
public static List <DoanBUS> timkiemDoan(String keyword)
{
List <DoanBUS> list = new List <DoanBUS>();
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand("proc_timkiemDoan", connection.getConnection()))
{
connection.open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@keyword", keyword.ToUpper());
var reader = command.ExecuteReader();
while (reader.Read())
{
DoanBUS doan = new DoanBUS();
doan.MaDoan = reader["maDoan"].ToString();
doan.TenDoan = reader["tenDoan"].ToString();
doan.NgayBatDau = DateTime.Parse(reader["ngayBatDau"].ToString());
doan.NgayKetThuc = DateTime.Parse(reader["ngayKetThuc"].ToString());
doan.Tour.MaTour = reader["maTour"].ToString();
doan.Tour.TenTour = reader["tenTour"].ToString();
list.Add(doan);
}
reader.Close();
connection.close();
}
return(list);
}
public static List <KhachHangBUS> getKhachHangKhongCoDoan(DoanBUS doan)
{
List <KhachHangBUS> dsKhachHang = new List <KhachHangBUS>();
String query = "select * from KhachHang where maKhachHang not in (select maKhachHang from ThamGia where maDoan=@madoan) ";
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
var reader = command.ExecuteReader();
while (reader.Read())
{
KhachHangBUS khachhang = new KhachHangBUS();
khachhang.MaKhachHang = reader["maKhachHang"].ToString();
khachhang.TenKhachHang = reader["tenKhachHang"].ToString();
khachhang.Gioitinh = reader["gioitinh"].ToString();
khachhang.Cmnd = reader["cmnd"].ToString();
khachhang.Diachi = reader["diachi"].ToString();
khachhang.Sdt = reader["sdt"].ToString();
dsKhachHang.Add(khachhang);
}
reader.Close();
connection.close();
}
return(dsKhachHang);
}
public static List <NhanVienBUS> getNhanVienKhongCoDoan(DoanBUS doan)
{
List <NhanVienBUS> dsNhanVien = new List <NhanVienBUS>();
String query = "select * from NhanVien ,ChucVu where NhanVien.maChucVu=ChucVu.maChucVu and maNhanVien not in (select maNhanVien from PhanCong where maDoan=@madoan) ";
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
var reader = command.ExecuteReader();
while (reader.Read())
{
NhanVienBUS nhanvien = new NhanVienBUS();
nhanvien.MaNhanVien = reader["maNhanVien"].ToString();
nhanvien.TenNhanVien = reader["tenNhanVien"].ToString();
nhanvien.Gioitinh = reader["gioitinh"].ToString();
nhanvien.Cmnd = reader["cmnd"].ToString();
nhanvien.Diachi = reader["diachi"].ToString();
nhanvien.Sdt = reader["sdt"].ToString();
nhanvien.Chucvu.MaChucVu = reader["maChucVu"].ToString();
nhanvien.Chucvu.TenChucVu = reader["tenChucVu"].ToString();
dsNhanVien.Add(nhanvien);
}
reader.Close();
connection.close();
}
return(dsNhanVien);
}
public static List <ChiPhiBUS> getChiPhiByDoan(DoanBUS doan)
{
List <ChiPhiBUS> dsChiPhi = new List <ChiPhiBUS>();
Connection connection = new Connection();
String query = "select * from ChiPhi,LoaiChiPhi where maDoan=@madoan and ChiPhi.maLoaiChiPhi=LoaiChiPhi.maLoaiChiPhi";
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
var reader = command.ExecuteReader();
while (reader.Read())
{
ChiPhiBUS chiphi = new ChiPhiBUS();
chiphi.MaChiPhi = int.Parse(reader["maChiPhi"].ToString());
chiphi.Thoigian = DateTime.Parse(reader["thoigian"].ToString());
chiphi.Tien = long.Parse(reader["tien"].ToString());
chiphi.LoaiChiPhi.MaLoaiChiPhi = reader["maLoaiChiPhi"].ToString();
chiphi.LoaiChiPhi.TenLoaiChiPhi = reader["tenLoaiChiPhi"].ToString();
dsChiPhi.Add(chiphi);
}
connection.close();
}
return(dsChiPhi);
}
public static List <DoanBUS> getAll()
{
List <DoanBUS> list = new List <DoanBUS>();
String query = "select * from Doan,Tour where Doan.maTour=Tour.maTour";
Connection connection = new Connection();
using (SqlCommand command = new SqlCommand(query, connection.getConnection()))
{
connection.open();
var reader = command.ExecuteReader();
while (reader.Read())
{
DoanBUS doan = new DoanBUS();
doan.MaDoan = reader["maDoan"].ToString();
doan.TenDoan = reader["tenDoan"].ToString();
doan.NgayBatDau = DateTime.Parse(reader["ngayBatDau"].ToString());
doan.NgayKetThuc = DateTime.Parse(reader["ngayKetThuc"].ToString());
doan.Tour.MaTour = reader["maTour"].ToString();
doan.Tour.TenTour = reader["tenTour"].ToString();
list.Add(doan);
}
reader.Close();
connection.close();
}
return(list);
}
public static bool ThemVaoDoan(NhanVienBUS nhanvien, DoanBUS doan)
{
int result = 0;
String query = "insert into phancong (maNhanVien,maDoan) values (@manhanvien,@madoan)";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@manhanvien", nhanvien.MaNhanVien);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
connect.open();
command.ExecuteNonQuery();
}
using (SqlCommand command = new SqlCommand("select count(*) as counts from phancong where maNhanVien=@manhanvien and maDoan=@madoan", connect.getConnection()))
{
command.Parameters.AddWithValue("@manhanvien", nhanvien.MaNhanVien);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
var reader = command.ExecuteReader();
reader.Read();
result = int.Parse(reader["counts"].ToString());
connect.close();
}
return(result == 1);
}
private void btnTimDoan_Click(object sender, EventArgs e)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_sdt(txtSdtDoan.Text.Trim());
txtTenDoan.Text = doan.TenDoan;
txtDiaChi.Text = doan.DiaChi;
txtTruongDoan.Text = doan.MaTruongDoan;
}
private void btnTim_Click(object sender, EventArgs e)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_sdt(txtSdt.Text.Trim());
txtTruongDoan.Text = doan.MaTruongDoan;
txtTenDoan.Text = doan.TenDoan;
loadThuePhong_Doan();
}
public void autoCompleteSource()
{
txtTenDoan.AutoCompleteMode = AutoCompleteMode.Suggest;
txtTenDoan.AutoCompleteSource = AutoCompleteSource.CustomSource;
DoanBUS dbus = new DoanBUS();
txtTenDoan.AutoCompleteCustomSource.Clear();
foreach (eDoan item in dbus.getdoans())
{
txtTenDoan.AutoCompleteCustomSource.Add(item.TenDoan);
}
}
private void frmTraKhachDoan_Load(object sender, EventArgs e)
{
autoCompleteSource();
if (maDoan != null)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_ID(maDoan);
txtSdt.Text = doan.Sdt;
txtTruongDoan.Text = doan.MaTruongDoan;
txtTenDoan.Text = doan.TenDoan;
loadThuePhong_Doan();
}
}
public static bool Xoa(DoanBUS doan)
{
int result = 0;
String query = "delete doan where maDoan=@madoan";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
connect.open();
result = command.ExecuteNonQuery();
connect.close();
}
return(result == 1);
}
public static bool ThemVaoDoan(KhachHangBUS khachhang, DoanBUS doan)
{
int result = 0;
String query = "insert into thamgia (maKhachHang,maDoan) values (@makhachhang,@madoan)";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@makhachhang", khachhang.MaKhachHang);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
connect.open();
result = command.ExecuteNonQuery();
connect.close();
}
return(result == 1);
}
private void frmThanhToan_Load(object sender, EventArgs e)
{
if (doan != null)
{
DoanBUS dbus = new DoanBUS();
txtTenDoan.Text = dbus.getTen_ById(doan);
}
lblMaThue.Text = MaThue;
lblLoaiPhong.Text = LoaiPhong;
lblTenPhong.Text = TenPhong;
loadKhachHang();
tienPhuThu();
tinhTienPhong();
load_list_dichvu();
double tongtien = tienvat + tienphong + tiendv + Convert.ToDouble(phuthu) + Convert.ToDouble(tienkhac) - giamgia;
txtTongTien.Text = string.Format("{0:#,##0}", tongtien).ToString();
}
public static bool XoaKhoiDoan(KhachHangBUS khachhang, DoanBUS doan)
{
int result = 0;
String query = "delete thamgia where maKhachHang=@makhachhang and maDoan=@madoan";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@makhachhang", khachhang.MaKhachHang);
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
connect.open();
result = command.ExecuteNonQuery();
connect.close();
}
return(result == 1);
}
public static void ThemKhachHangDoan(DoanBUS doan, List <KhachHangBUS> dsKhachHang)
{
String query = "insert into ThamGia (maDoan,maKhachHang) values ";
foreach (KhachHangBUS khachhang in dsKhachHang)
{
query += String.Format("('{0}','{1}'),", doan.MaDoan, khachhang.MaKhachHang);
}
query = query.Substring(0, query.Length - 1);
Connection connection = new Connection();
using (SqlCommand commmand = new SqlCommand(query, connection.getConnection()))
{
connection.open();
commmand.ExecuteNonQuery();
connection.close();
}
}
public static bool KiemTraTonTai(DoanBUS doan)
{
int result = 0;
String query = "select COUNT(*) as counts from Doan where maDoan=@madoan";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
connect.open();
var reader = command.ExecuteReader();
reader.Read();
result = int.Parse(reader["counts"].ToString());
connect.close();
}
return(result == 1);
}
public DataTable DataTable_DSTP(ArrayList ds)
{
KhachHangBUS khbus = new KhachHangBUS();
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
DataTable dt = new DataTable();
dt.Columns.Add("Tên khách hàng", typeof(string));
dt.Columns.Add("Tiền phòng", typeof(double));
dt.Columns.Add("Thời gian vào", typeof(string));
dt.Columns.Add("Thời gian ra", typeof(string));
foreach (string item in ds)
{
double tienPhong = 0;
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
tienPhong += hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong)), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(cttp.GioRa + " " + cttp.NgayRa.ToShortDateString())) + hdtp.tinhTienPhuThu(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong))) + cttp.TienKhac;
}
if (tpbus.getMaDoan_ByMaThue(item) == null)
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(khbus.getenKH_ByID(cttp.MaKhach), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
}
}
else
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(item)), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
break;
}
}
}
return(dt);
}
public static bool Them(DoanBUS doan)
{
int result = 0;
String query = "insert into doan (maDoan,tenDoan,ngayBatDau,ngayKetThuc,maTour) values( @madoan,@tendoan,@ngaybatdau,@ngayketthuc,@matour)";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
command.Parameters.AddWithValue("@tendoan", doan.TenDoan);
command.Parameters.AddWithValue("@ngaybatdau", doan.NgayBatDau);
command.Parameters.AddWithValue("@ngayketthuc", doan.NgayKetThuc);
command.Parameters.AddWithValue("@matour", doan.Tour.MaTour);
connect.open();
result = command.ExecuteNonQuery();
connect.close();
}
return(result == 1);
}
public static bool Sua(DoanBUS doancu, DoanBUS doan)
{
int result = 0;
String query = "update doan set maDoan=@madoan, tenDoan=@tendoan, ngayBatDau=@ngaybatdau, ngayKetThuc=@ngayketthuc, maTour=@matour where maDoan=@madoancu";
Connection connect = new Connection();
using (SqlCommand command = new SqlCommand(query, connect.getConnection()))
{
command.Parameters.AddWithValue("@madoan", doan.MaDoan);
command.Parameters.AddWithValue("@tendoan", doan.TenDoan);
command.Parameters.AddWithValue("@ngaybatdau", doan.NgayBatDau);
command.Parameters.AddWithValue("@ngayketthuc", doan.NgayKetThuc);
command.Parameters.AddWithValue("@matour", doan.Tour.MaTour);
command.Parameters.AddWithValue("@madoancu", doancu.MaDoan);
connect.open();
result = command.ExecuteNonQuery();
connect.close();
}
return(result == 1);
}
public DataTable DataTable_DSTP(List <eChiTietThuePhong> ds)
{
KhachHangBUS khbus = new KhachHangBUS();
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
DataTable dt = new DataTable();
dt.Columns.Add("Tên phòng", typeof(string));
dt.Columns.Add("Tên khách hàng", typeof(string));
dt.Columns.Add("Số CMND", typeof(string));
dt.Columns.Add("Số điện thoại", typeof(string));
dt.Columns.Add("Thời gian nhận phòng", typeof(string));
foreach (eChiTietThuePhong item in ds)
{
eKhachHang kh = new eKhachHang();
kh = khbus.getmaKH(item.MaKhach);
dt.Rows.Add(pbus.getTenPhong_ByID(item.MaPhong), kh.TenKH, kh.SoCMND, kh.SoDT, item.GioVao + " " + item.NgayVao.ToShortDateString());
}
return(dt);
}
private void btnLuu_Click(object sender, EventArgs e)
{
ThuePhongBUS tpbus = new ThuePhongBUS();
PhongBUS pbus = new PhongBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
eThuePhong tp = new eThuePhong();
NhanVienBUS nvbus = new NhanVienBUS();
DoanBUS dbus = new DoanBUS();
//Tao Doan
eDoan doan = new eDoan();
doan.DiaChi = txtDiaChi.Text.Trim();
doan.MaTruongDoan = txtTruongDoan.Text.Trim();
doan.TenDoan = txtTenDoan.Text.Trim();
doan.Sdt = txtSdtDoan.Text.Trim();
if (dbus.getdoan_sdt(txtSdtDoan.Text.Trim()) == null)
{
int kqTaoDoan = dbus.insertDoan(doan);
}
tp.MaNV = nvbus.getmaNV_byEmail(emailNV);
tp.MaDoan = dbus.getId_ByTenDoan(txtTenDoan.Text.Trim()); //ma doan
int soLuongP = 0;
for (int i = 0; i < gridViewLoaiPhong.RowCount; i++)
{
soLuongP += Convert.ToInt32(gridViewLoaiPhong.GetRowCellValue(i, gridViewLoaiPhong.Columns[3]));
}
tp.SoLuongPhong = soLuongP;
tp.TrangThai = false;
TimeSpan gioVao = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TimeSpan gioRa = new TimeSpan(14, 00, 00);
int a = tpbus.insertThuePhong(tp);
eChiTietThuePhong cttp = new eChiTietThuePhong();
if (a == 1)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (eKhachHang item in ls)
{
cttp.MaThue = tpbus.getMaThueCuoi();
cttp.MaKhach = item.MaKH;
cttp.MaPhong = pbus.maPhong_byTen(item.SoPhong);
cttp.NgayRa = Convert.ToDateTime(dtmNgayRa.Text).Date;
cttp.NgayVao = DateTime.Now.Date;
cttp.GioRa = gioRa;
cttp.GioVao = gioVao;
cttp.TrangThai = false;
cttpbus.insertCTTP(cttp);
ePhong p = new ePhong();
p.MaPhong = pbus.maPhong_byTen(item.SoPhong);
p.TinhTrang = true;
int soPhong = 0;
foreach (var kh in ls)
{
if (kh.SoPhong.Equals(item.SoPhong))
{
soPhong++;
}
}
p.SoNgHienTai = soPhong;
pbus.updateTinhTrangPhong(p);
}
MessageBox.Show("Đặt phòng thành công");
this.Close();
}
else
{
MessageBox.Show("Không thành công");
return;
}
}
public void loadThuePhong_Doan()
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
PhongBUS pbus = new PhongBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
DichVuBUS dvbus = new DichVuBUS();
List <eChiTietThuePhong> list_ect = new List <eChiTietThuePhong>();
list_ect = cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0), 0);
for (int i = 0; i < list_ect.Count; i++)
{
for (int j = 1; j < list_ect.Count; j++)
{
if (i == j)
{
list_ect.RemoveAt(i);
continue;
}
if (list_ect[i].MaPhong.Equals(list_ect[j].MaPhong))
{
list_ect.RemoveAt(i);
}
}
}
List <eThuePhong_Doan> lstp_d = new List <eThuePhong_Doan>();
foreach (eChiTietThuePhong item in list_ect)
{
eThuePhong_Doan etpd = new eThuePhong_Doan();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
eHoaDonDichVu hddv = new eHoaDonDichVu();
double tienPhong = Convert.ToDouble(hdtp.tinhTienPhong(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(item.GioVao + " " + item.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString())));
double tienPhuThu = 0;
if (item.GhiChu.Equals(""))
{
tienPhuThu += Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong))));
}
else
{
tienPhuThu += Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(item.GhiChu.Substring(0, 8))))));
}
etpd.Tenphong = pbus.getTenPhong_ByID(item.MaPhong);
etpd.TienPhong = tienPhong + tienPhuThu;
double tienDV = 0;
foreach (eChiTetDichVu ctdv in ctdvbus.getctdv_MaThue_MaPhong(item.MaThue, item.MaPhong))
{
tienDV += hddv.tinhDichVu(dvbus.getDonGia_byID(ctdv.MaDV), ctdv.SoLuong);
}
etpd.TienDV = tienDV;
etpd.TienKhac = item.TienKhac;
etpd.GhiChu = item.GhiChu;
lstp_d.Add(etpd);
}
dgvDsThuePhong.DataSource = lstp_d.ToList();
double tongTienPhong = 0;
for (int i = 0; i < gridViewDsThuePhong.RowCount; i++)
{
tongTienPhong += Convert.ToDouble(gridViewDsThuePhong.GetRowCellValue(i, gridViewDsThuePhong.Columns[1]));
}
txtTongTienPhong.Text = string.Format("{0:#,##0}", tongTienPhong).ToString();
txtThueVAT.Text = string.Format("{0:#,##0}", tongTienPhong * 0.1).ToString();
txtKhuyenMai.Text = string.Format("{0:#,##0}", tongTienPhong * 0.2).ToString();
txtTienThanhToan.Text = string.Format("{0:#,##0}", tongTienPhong + tongTienPhong * 0.1 - tongTienPhong * 0.2).ToString();
}
//Load giao diện các phòng trống và phòng có chứa khách hàng
public void TaoGiaoDienPhong(List <ePhong> soPhong, List <ePhong> phongTrong, List <ePhong> coKhach, string title)
{
//Tạo ra một flowLayoutPanel để chứa các panel
PhongBUS pbus = new PhongBUS();
FlowLayoutPanel flowLayoutPanel3 = new FlowLayoutPanel();
flowLayoutPanel3.AutoSize = true;
flowLayoutPanel3.AutoSizeMode = AutoSizeMode.GrowAndShrink;
flowLayoutPanel1.Controls.Add(flowLayoutPanel3);
Label text = new Label();
text.Size = new Size(1850, 30);
text.TextAlign = ContentAlignment.TopCenter;
text.Text = title;
flowLayoutPanel3.Controls.Add(text);
//Tạo các label để chứa thông tin, màu sắc thể hiện các phòng
foreach (var item in soPhong)
{
DevExpress.XtraEditors.PanelControl P0001 = new DevExpress.XtraEditors.PanelControl();
Label lbl = new Label();
flowLayoutPanel3.Controls.Add(P0001);
P0001.Appearance.Options.UseBackColor = true;
P0001.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Style3D;
P0001.Controls.Add(lbl);
P0001.Location = new Point(3, 3);
P0001.Name = item.MaPhong;
P0001.Size = new Size(170, 150);
lbl.Font = new Font("Tahoma", 9F);
lbl.Dock = DockStyle.Fill;
lbl.Size = new Size(150, 120);
lbl.TextAlign = ContentAlignment.TopCenter;
}
//Load thông tin của phòng trống vào từng label
foreach (var item in phongTrong)
{
foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>())
{
if (pnl.Name.Equals(item.MaPhong.Trim()))
{
pnl.BackColor = Color.LawnGreen;
foreach (var lbl in pnl.Controls.OfType <Label>())
{
string ma = item.MaPhong.Substring(3, 5);
lbl.BackColor = Color.LawnGreen;
lbl.Text = "Phòng " + Convert.ToInt32(ma);
lbl.MouseDown += new MouseEventHandler(lbl_ClickTP);
lbl.ContextMenuStrip = cmnstrpSanSang;
}
}
}
}
//Load thông tin của phòng đang có khách vào từng label
foreach (var item in coKhach)
{
foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>())
{
if (pnl.Name.Equals(item.MaPhong.Trim()))
{
pnl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
foreach (var lbl in pnl.Controls.OfType <Label>())
{
lbl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
string ma = item.MaPhong.Substring(3, 5);
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
DoanBUS dbus = new DoanBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
foreach (var thuePhong in tpbus.getMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false)))
{
if (thuePhong.MaDoan == null)
{
lbl.Text = "Phòng " + Convert.ToInt32(ma);
}
else
{
string tendoan = dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false)));
string tenPhong = "Phòng " + Convert.ToInt32(ma);
lbl.Text = tenPhong + "\n\n\rĐoàn: " + tendoan;
}
}
lbl.MouseDown += new MouseEventHandler(lblred_Click);
lbl.MouseHover += new EventHandler(lblred_MouseHover);
lbl.ContextMenuStrip = cmnstrpCoKhach;
}
}
}
}
}
public KhachHang(BUS.DoanBUS doan)
{
InitializeComponent();
this.doan = doan;
}
public NhanVien(DoanBUS doan)
{
InitializeComponent();
this.doan = doan;
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
PhongBUS pbus = new PhongBUS();
HoaDonTienPhongBUS hdtpbus = new HoaDonTienPhongBUS();
TimeSpan gioHienTai = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
eHoaDonTienPhong tt_ent = new eHoaDonTienPhong();
tt_ent.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
tt_ent.NgayLap = DateTime.Now;
tt_ent.GioLap = gioHienTai;
tt_ent.ThueVAT = Convert.ToSingle(txtThueVAT.Text);
tt_ent.KhuyenMai = Convert.ToSingle(txtKhuyenMai.Text);
int a = hdtpbus.insertThanhToan(tt_ent);
if (a == 1)
{
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue(tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0)))
{
eChiTietThuePhong ectOld = new eChiTietThuePhong();
ectOld.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
ectOld.MaPhong = item.MaPhong;
ectOld.MaKhach = item.MaKhach;
ectOld.NgayRa = DateTime.Now.Date;
ectOld.GioRa = gioHienTai;
ectOld.TrangThai = true;
cttpbus.updateChiTietThuePhong(ectOld);
ePhong newp = new ePhong();
newp.MaPhong = item.MaPhong;
newp.TinhTrang = false;
newp.SoNgHienTai = 0;
pbus.updateTinhTrangPhong(newp);
}
eThuePhong tp = new eThuePhong();
tp.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
tp.TrangThai = true;
tpbus.updateThuePhong(tp);
MessageBox.Show("Thanh toán thành công");
NhanVienBUS nvbus = new NhanVienBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
HoaDon bc = new HoaDon();
List <eChiTietBaoCao> listphong = new List <eChiTietBaoCao>();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(tp.MaThue, 1))
{
eChiTietBaoCao ctbc = new eChiTietBaoCao();
ctbc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
ctbc.tenLoaiPhong = lpbus.getTen_Byma(pbus.getLoaiPhong_ByID(item.MaPhong));
ctbc.thoiGianNhan = item.GioVao + " " + item.NgayVao.Date.ToShortDateString();
ctbc.thoiGianTra = item.GioRa + " " + item.NgayRa.Date.ToShortDateString();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
double tienPhong = Convert.ToDouble(hdtp.tinhTienPhong(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(item.GioVao + " " + item.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString())));
double tienPhuThu = Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong))));
ctbc.tienPhong = tienPhong + tienPhuThu;
listphong.Add(ctbc);
}
for (int i = 0; i < listphong.Count; i++)
{
for (int j = 1; j < listphong.Count; j++)
{
if (i == j)
{
continue;
}
if (listphong[i].tenPhong.Equals(listphong[j].tenPhong))
{
listphong.RemoveAt(i);
}
}
}
foreach (var item in tpbus.getMaThue(tp.MaThue))
{
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = dbus.getTen_ById(item.MaDoan);
bc.soHD = hdtpbus.gemaHD_BymaThue(tp.MaThue); //Cần xem xét lại
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
}
this.Close();
frmPrint frmp = new frmPrint();
frmp.InHoaDonInTuReport(bc, listphong.ToList());
frmp.ShowDialog();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS();
DichVuBUS dvbus = new DichVuBUS();
KhachHangBUS khbus = new KhachHangBUS();
if (ctdvbus.getctdv_byMaThue(tt_ent.MaThue) != null)
{
foreach (var item in ctdvbus.getctdv_byMaThue(tt_ent.MaThue))
{
if (hddvbus.kiemTraTonTai(item.MaThue, item.MaPhong) == false)
{
eHoaDonDichVu hddv = new eHoaDonDichVu();
hddv.MaHDDV = (DateTime.Now.Day).ToString() + (DateTime.Now.Month).ToString() + (DateTime.Now.Year).ToString() + item.MaThue + item.MaKhach + item.MaPhong;
hddv.MaThue = item.MaThue;
hddv.MaKH = item.MaKhach;
hddv.MaPhong = item.MaPhong;
hddv.NgayLap = DateTime.Now.Date;
hddv.GioLap = gioHienTai;
hddvbus.insertThanhToanDV(hddv);
List <eCTDV> lsctdv = new List <eCTDV>();
foreach (eChiTetDichVu dv in ctdvbus.getctdv_MaThue_MaPhong(item.MaThue, item.MaPhong))
{
eCTDV ctdv = new eCTDV();
ctdv.TenDV = dvbus.getTenDV_byID(dv.MaDV);
ctdv.SoLuong = dv.SoLuong;
ctdv.DonGia = dvbus.getDonGia_byID(dv.MaDV);
lsctdv.Add(ctdv);
}
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = khbus.getenKH_ByID(item.MaKhach);
bc.soHD = hddvbus.gemaHD_BymaThue_maPhong(item.MaThue, item.MaPhong);
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
bc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
frmPrint frmInDV = new frmPrint();
frmInDV.InHoaDonInDichVuTuReport(bc, lsctdv.ToList());
frmInDV.ShowDialog();
this.Close();
}
}
}
}
}
