public ActionResult Test(FormCollection collect, PhieuThue phieuthue)
{
if (ModelState.IsValid)
{
NHANVIEN ad = (NHANVIEN)Session["TaiKhoanAdmin"];
phieuthue.IDNhanVien = ad.ID;
var id = collect["var2"].ToString();
if (phieuthue.TenCongTy == null)
{
phieuthue.TenCongTy = "";
}
if (phieuthue.SDT == null)
{
phieuthue.SDT = "";
}
if (phieuthue.DiaChi == null)
{
phieuthue.DiaChi = "";
}
if (cc.Test(int.Parse(id), phieuthue.IDNhanVien, phieuthue.CMND, phieuthue.Ten, phieuthue.DiaChi, phieuthue.SDT, phieuthue.TenCongTy))
{
return(RedirectToAction("ThemNguoi", new { id = cc.GetID() }));
}
}
return(View());
}
public void LuuPhieuThueMoi(List <ePhieuThue> l)
{
int ma = chisoPhieuThue();
foreach (var item in l)
{
PhieuThue pt = new PhieuThue();
pt.MaThue = sinhMaPhieuThueTuSo(++ma);
pt.MaDia = item.Madia;
pt.MaKhachHang = item.Makhachhang;
pt.TrangThaiPhi = item.Trangthaiphi;
pt.TrangThaiThue = item.Trangthaithue;
pt.NgayHenTra = item.Ngayhentra;
pt.NgayMuon = item.Ngaymuon;
pt.NgayTra = item.Ngaytra;
pt.PhiTraMuon = item.Phitramuon;
pt.GiaThue = item.Giathue;
db.PhieuThues.InsertOnSubmit(pt);
Dia d = db.Dias.Where(x => x.MaDia.Equals(item.Madia)).First();
d.TrangThaiDia = "Đã thuê";
PhieuDat pd = db.PhieuDats.Where(x => x.MaDia.Equals(pt.MaDia)).FirstOrDefault();
if (pd != null)
{
db.PhieuDats.DeleteOnSubmit(pd);
}
}
db.SubmitChanges();
}
private void Btn_Click(object sender, EventArgs e)
{
Phong p = (sender as Button).Tag as Phong;
flpPhong.Tag = p;
txbMaPhong.Text = p.MaPhong1.ToString();
PhieuThue pt = PhieuThueDAO.Instance.getPhieuThueByMaPhong(p.MaPhong1);
int index = -1;
int i = 0;
foreach (PhieuThue item in cbbMaPhieuThue.Items)
{
if (pt.MaPhieuThue1 == item.MaPhieuThue1)
{
index = i;
}
i++;
}
if (index > -1)
{
cbbMaPhieuThue.SelectedIndex = index;
}
}
private void cbbPhieuThueDangAndCho_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbPhieuThueDangAndCho.SelectedItem != null)
{
PhieuThue pt = cbbPhieuThueDangAndCho.SelectedItem as PhieuThue;
List <Phong> listPhong = PhongDAO.Instance.getListPhongByMaPhieuThue(pt.MaPhieuThue1);
try
{
dtpkNgayDen.Value = pt.NgayDen1;
dtpkNgayDi.Value = pt.NgayDi1;
}
catch (Exception)
{
try
{
dtpkNgayDen.Value = DateTime.Now;
dtpkNgayDi.Value = pt.NgayDi1;
}
catch (Exception)
{
}
}
LoadPhongDaDat(listPhong, flpPhongDaDat);
}
}
private void btnXacNhanThue_Click_1(object sender, EventArgs e)
{
int dem = 0; // số phòng mà khách chọn
foreach (DataGridViewRow row in dgvThuePhong.Rows)
{
if (row.Cells[0].Value != null)
{
if ((Boolean)row.Cells[0].Value == true)
{
dem++;
}
}
}
if (dem > 0)
{
//Thêm khách hàng mới
KhachHang kh = new KhachHang();
kh.TenKH = txtTenKH.Text;
kh.GioiTinh = cboGioiTinh.Text;
kh.SDT = txtSDT.Text;
kh.Email = txtEmail.Text;
kh.CMND = txtCMND.Text;
dal_khachhang.ThemKhachHang(kh);
string str_MaKHVuaThem = dal_khachhang.LayMaKHVuaThem();
//Thêm vào bảng Phiếu thuê mã khách hàng, ngày đén ngày đi, hình thức thuê
PhieuThue PT = new PhieuThue();
PT.MaKH = str_MaKHVuaThem;
PT.NgayDen = dateNgayDen.Value;
PT.NgayDi = dateNgayDi.Value;
PT.HinhThucThue = cboHinhThucThue.Text;
dal_phieuthue.ThemPhieuThue(PT);
string str_MaPTVuaThem = dal_phieuthue.LayMaPTVuaThem();
//Update bảng phòng
foreach (DataGridViewRow row in dgvThuePhong.Rows)
{
if (row.Cells[0].Value != null)
{
if ((Boolean)row.Cells[0].Value == true)
{
Phong P = new Phong();
P.MaPhong = row.Cells[1].Value.ToString().Trim();
P.TrangThai = "Đã bị thuê";
P.MaPT = str_MaPTVuaThem;
dal_phong.SuaPhongSauKhiThue(P);
}
}
}
MessageBox.Show("Thuê phòng thành công");
this.Close();
}
else
{
MessageBox.Show("Bạn cần chọn phòng");
}
}
int chisoPhieuThue()
{
PhieuThue pt = db.PhieuThues.ToList().LastOrDefault();
if (pt != null)
{
return(Int32.Parse(pt.MaThue.Substring(4)));
}
return(0);
}
public int updatePhiTraMuonCu(string maphieu)
{
PhieuThue pt = db.PhieuThues.Where(x => x.MaThue == maphieu).FirstOrDefault();
if (pt == null)
{
return(0);
}
else
{
pt.TrangThaiPhi = "Đã trả";
db.SubmitChanges();
return(1);
}
}
public bool ThemPhieuThue(ePhieuThue ept)
{
PhieuThue pt = new PhieuThue();
pt.IdPhieuThue = ept.IdPhieuThue;
pt.NgayTao = ept.NgayTao;
pt.TongPhiThue = ept.TongPhiThue;
pt.IdKhachHang = ept.IdKhachHang;
if (!db.PhieuThues.Contains(pt))
{
db.PhieuThues.InsertOnSubmit(pt);
db.SubmitChanges();
return(true);
}
return(false);
}
private void Btn_ClickPhong(object sender, EventArgs e)
{
Phong p = (sender as Button).Tag as Phong;
Button btn = sender as Button;
if (btn.BackColor == Color.FromArgb(0, 192, 0))
{
btn.BackColor = Color.BlueViolet;
}
else if (btn.BackColor == Color.BlueViolet)
{
btn.BackColor = Color.FromArgb(0, 192, 0);
}
//txbMaPhong.Text = "";
foreach (Button item in flpPhong.Controls)
{
Phong p1 = item.Tag as Phong;
if (item.BackColor == Color.BlueViolet)
{
//txbMaPhong.Text += p1.SoPhong1 + " ";
}
}
PhieuThue pt = PhieuThueDAO.Instance.getPhieuThueByMaPhong(p.MaPhong1);
int index = -1;
int i = 0;
foreach (PhieuThue item in cbbMaPhieuThue.Items)
{
if (pt.MaPhieuThue1 == item.MaPhieuThue1)
{
index = i;
}
i++;
}
if (index > -1)
{
cbbMaPhieuThue.SelectedIndex = index;
}
else
{
cbbMaPhieuThue.SelectedIndex = -1;
}
}
public ePhieuThue layPhieuThueTheoMaPhieu(string ma)
{
PhieuThue pt = db.PhieuThues.Where(x => x.MaThue == ma).FirstOrDefault();
ePhieuThue pt1 = new ePhieuThue();
pt1.Maphieuthue = pt.MaThue;
pt1.Madia = pt.MaDia;
pt1.Makhachhang = pt.MaKhachHang;
pt1.Ngayhentra = pt.NgayHenTra;
pt1.Ngaymuon = pt.NgayMuon;
pt1.Ngaytra = pt.NgayTra;
pt1.Trangthaiphi = pt.TrangThaiPhi;
pt1.Trangthaithue = pt.TrangThaiThue;
pt1.Giathue = pt.GiaThue;
pt1.Phitramuon = pt.PhiTraMuon;
return(pt1);
}
public int updatePhiTraMuonThanhToanSau(string maphieu, double phitramuon)
{
PhieuThue pt = db.PhieuThues.Where(x => x.MaThue == maphieu).FirstOrDefault();
if (pt == null)
{
return(0);
}
else
{
pt.NgayTra = DateTime.Today;
pt.PhiTraMuon = phitramuon;
pt.TrangThaiPhi = "Chưa trả";
db.SubmitChanges();
return(1);
}
}
private void btnHuyPhong_Click(object sender, EventArgs e)
{
if (cbbMaPhieuThue.SelectedItem != null)
{
if (cbbPhongHuy.SelectedItem != null)
{
PhieuThue pt = cbbMaPhieuThue.SelectedItem as PhieuThue;
Phong p = cbbPhongHuy.SelectedItem as Phong;
ThuePhongDAO.Instance.DeleteThuePhong(pt.MaPhieuThue1, p.MaPhong1);
LoadPhong();
loadCbbNhanPhong();
LoadCbbPhong(pt.MaPhieuThue1);
LoadCbbPhongChuyen(pt.NgayDen1, pt.NgayDi1);
}
}
else
{
MessageBox.Show("vui lòng chọn mã phiếu thuê");
}
}
private void btnHuyPhongTab2_Click(object sender, EventArgs e)
{
String maPhongs = txbMaPhongDaDat.Text.Trim();
if (cbbPhieuThueDangAndCho.SelectedItem != null)
{
if (maPhongs != "")
{
PhieuThue pt = cbbPhieuThueDangAndCho.SelectedItem as PhieuThue;
String[] str = maPhongs.Split(' ');
foreach (String item in str)
{
Phong p = PhongDAO.Instance.getMaPhongBySoPhong(Convert.ToInt32(item));
ThuePhongDAO.Instance.DeleteThuePhong(pt.MaPhieuThue1, p.MaPhong1);
}
List <Phong> listPhong = PhongDAO.Instance.getListPhongTrong(pt.NgayDen1, pt.NgayDi1);
LoadPhongTrong(listPhong, flpPhongTrong, flpPhongTrongOfTang2, flpPhongTrongOfTang3);
List <Phong> listPhong1 = PhongDAO.Instance.getListPhongByMaPhieuThue(pt.MaPhieuThue1);
LoadPhongDaDat(listPhong1, flpPhongDaDat);
LoadPhong();
PhieuThue pt1 = cbbMaPhieuThue.SelectedItem as PhieuThue;
if (pt1 != null)
{
LoadCbbPhong(pt1.MaPhieuThue1);
LoadCbbPhongChuyen(pt1.NgayDen1, pt1.NgayDi1);
}
loadCbbNhanPhong();
txbMaPhongDaDat.Text = "";
}
}
else
{
MessageBox.Show("vui lòng chọn mã phiếu thuê");
}
}
public ePhieuThue layPhieuThueTheoDiaDangThue(string madia)
{
ePhieuThue phieuthuenhan = new ePhieuThue();
PhieuThue phieutim = db.PhieuThues.Where(x => x.MaDia == madia && x.TrangThaiThue == "Đang thuê").FirstOrDefault();
if (phieutim == null)
{
return(null);
}
phieuthuenhan.Maphieuthue = phieutim.MaThue;
phieuthuenhan.Madia = phieutim.MaDia;
phieuthuenhan.Makhachhang = phieutim.MaKhachHang;
phieuthuenhan.Ngaymuon = phieutim.NgayMuon;
phieuthuenhan.Ngaytra = phieutim.NgayTra;
phieuthuenhan.Ngayhentra = phieutim.NgayHenTra;
phieuthuenhan.Phitramuon = phieutim.PhiTraMuon;
phieuthuenhan.Giathue = phieutim.GiaThue;
phieuthuenhan.Trangthaiphi = phieutim.TrangThaiPhi;
phieuthuenhan.Trangthaithue = phieutim.TrangThaiThue;
return(phieuthuenhan);
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Bạn đồng ý lấy ngày giờ này chứ?", "Thông Báo", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
// lấy thông tin
int i = dgvPhieuThanhToan.CurrentCell.RowIndex;
PhieuThue pt = new PhieuThue();
pt.MaPT = dgvPhieuThanhToan.Rows[i].Cells[0].Value.ToString().Trim();
pt.NgayDi = dateNgayDi.Value;
dal_PhieuThue.SuaPhieuThue(pt);
//cập nhật lại dgvPhieuthanhtoan
dgvPhieuThanhToan.DataSource = dal_ThanhToan.ThongTinCacKhachHangThuePhong();
//cập nhật lại tiền phòng
lblTienPhong.Text = dal_ThanhToan.TinhTienPhong(pt.MaPT).ToString();
MessageBox.Show("Cập nhật ngày đi cho khách hàng thành công!");
}
}
private void cbbMaPhieuThue_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbMaPhieuThue.SelectedIndex != -1)
{
PhieuThue pt = cbbMaPhieuThue.SelectedItem as PhieuThue;
KhachHang kh = KhachHangDAO.Instance.getKhachHangByMaPhieuThue(pt.MaPhieuThue1);
txbTenKhachHang.Text = kh.TenKH1.ToString();
object TienPhong = PhongDAO.Instance.getTienPhong(pt.MaPhieuThue1);
if (TienPhong != null)
{
txbTienPhong.Text = TienPhong.ToString();
}
LoadCbbPhong(pt.MaPhieuThue1);
ShowLvDichVu(pt.MaPhieuThue1);
LoadCbbPhongChuyen(pt.NgayDen1, pt.NgayDi1);
}
}
public void ThemThongTin(PhieuThue EC_PT)
{
connect.ThucHienLenh("insert into tblPhieuThue(MaPhieu, MaKH, MaPh, MaPT) values(N'" + EC_PT.MaPhieu + "', N'" + EC_PT.MaKH + "', N'" + EC_PT.MaPh + "', N'" + EC_PT.MaPT + "')");
}
public void XoaTTPhieuThue(PhieuThue EC_PT)
{
connect.ThucHienLenh("delete from tblPhieuThue where MaPhieu = '" + EC_PT.MaPhieu + "'");
}
void LoadPhongDaDat1(List <Phong> listPhong, FlowLayoutPanel flpPhongDaDat)
{
flpPhongDaDat.Controls.Clear();
flpPhongOfTang2.Controls.Clear();
flpPhongOfTang3.Controls.Clear();
foreach (Phong item in listPhong)
{
LabelX lb1 = new LabelX()
{
Height = 90, Width = 40
};
lb1.TextAlignment = StringAlignment.Center;
lb1.ForeColor = Color.White;
lb1.Text = item.SoPhong1.ToString();
lb1.Margin = new System.Windows.Forms.Padding(0, 0, 0, 0);
lb1.Font = new Font(new FontFamily("Times New Roman"), 15, FontStyle.Bold);
LabelX lb = new LabelX()
{
Height = 90, Width = 140
};
lb.Margin = new System.Windows.Forms.Padding(0, 0, 0, 0);
lb.TextAlignment = StringAlignment.Center;
lb.Font = new Font(lb1.Font, FontStyle.Bold);
lb.Font = new Font(new FontFamily("Times New Roman"), 11, FontStyle.Bold);
lb.Font = new Font(new FontFamily("Times New Roman"), 11, FontStyle.Bold);
PhieuThue pt = PhieuThueDAO.Instance.getPhieuThueByMaPhong(item.MaPhong1);
KhachHang kh = KhachHangDAO.Instance.getKhachHangByMaKh(pt.MaKH1);
lb1.BackColor = Color.FromArgb(241, 71, 71);
lb.BackColor = Color.FromArgb(230, 203, 203);
String ngayDen = pt.NgayDen1.Day + "/" + pt.NgayDen1.Month + "/" + pt.NgayDen1.Year;
String ngayDi = pt.NgayDi1.Day + "/" + pt.NgayDi1.Month + "/" + pt.NgayDi1.Year;
lb.Text = ngayDen + "\n\n" + kh.TenKH1 + "\n\n" + ngayDi;
lb.ForeColor = Color.FromArgb(241, 71, 71);
FlowLayoutPanel f = new FlowLayoutPanel()
{
Height = 90, Width = 180
};
f.Margin = new System.Windows.Forms.Padding(8, 8, 8, 8);
f.Controls.Add(lb1);
f.Controls.Add(lb);
switch (item.Tang1)
{
case 1:
flpPhong.Controls.Add(f);
break;
case 2:
flpPhongOfTang2.Controls.Add(f);
break;
case 3:
flpPhongOfTang3.Controls.Add(f);
break;
default:
break;
}
}
}
void loadPhong0()
{
flpPhong.Controls.Clear();
flpPhongOfTang2.Controls.Clear();
flpPhongOfTang3.Controls.Clear();
List <Phong> listPhong = PhongDAO.Instance.getListPhong();
const String TAT_CA = "Tất Cả";
lbTatCaPhong.Text = TAT_CA + "(" + listPhong.Count + ")";
int iTrong = 0;
int iCoNguoi = 0;
foreach (Phong item in listPhong)
{
Button btn = new Button();
btn.Font = new Font(new FontFamily("Times New Roman"), 12);
btn.Font = new Font(btn.Font, FontStyle.Bold);
btn.Height = 90;
btn.Width = 80;
btn.ForeColor = Color.Gainsboro;
btn.Tag = item;
btn.Click += Btn_ClickPhong;
switch (item.TrangThai1)
{
case "trống":
iTrong++;
btn.BackColor = Color.FromArgb(30, 156, 37);
btn.Text = "Phòng" + "\n" + item.SoPhong1.ToString();
break;
case "có người":
iCoNguoi++;
PhieuThue pt = PhieuThueDAO.Instance.getPhieuThueByMaPhong(item.MaPhong1);
btn.Text = pt.MaPhieuThue1 + "\n" + "Phòng " + item.SoPhong1;
btn.BackColor = Color.FromArgb(241, 71, 71);
break;
default:
break;
}
btn.Text += "\n" + item.Loai1;
switch (item.Tang1)
{
case 1:
flpPhong.Controls.Add(btn);
break;
case 2:
flpPhongOfTang2.Controls.Add(btn);
break;
case 3:
flpPhongOfTang3.Controls.Add(btn);
break;
default:
break;
}
}
String trong = "Trống";
String coNguoi = "Có Người";
lbTrong.Text = trong + "(" + iTrong + ")";
lbCoNguoi.Text = coNguoi + "(" + iCoNguoi + ")";
}
void loadPhong1()
{
flpPhong.Controls.Clear();
flpPhongOfTang2.Controls.Clear();
flpPhongOfTang3.Controls.Clear();
List <Phong> listPhong = PhongDAO.Instance.getListPhong();
const String TAT_CA = "Tất Cả";
lbTatCaPhong.Text = TAT_CA + "(" + listPhong.Count + ")";
int iTrong = 0;
int iCoNguoi = 0;
foreach (Phong item in listPhong)
{
LabelX lb1 = new LabelX()
{
Height = 90, Width = 40
};
lb1.TextAlignment = StringAlignment.Center;
lb1.ForeColor = Color.White;
lb1.Text = item.SoPhong1.ToString();
lb1.Margin = new System.Windows.Forms.Padding(0, 0, 0, 0);
lb1.Font = new Font(new FontFamily("Times New Roman"), 15, FontStyle.Bold);
LabelX lb = new LabelX()
{
Height = 90, Width = 140
};
lb.Margin = new System.Windows.Forms.Padding(0, 0, 0, 0);
lb.TextAlignment = StringAlignment.Center;
lb.Font = new Font(lb1.Font, FontStyle.Bold);
lb.Font = new Font(new FontFamily("Times New Roman"), 11, FontStyle.Bold);
if (item.TrangThai1 == "trống")
{
iTrong++;
lb1.ForeColor = Color.White;
lb1.Text = item.SoPhong1.ToString();
lb1.BackColor = Color.FromArgb(30, 156, 37);
lb.BackColor = Color.FromArgb(219, 230, 210);
lb.Text = item.TrangThai1;
lb.ForeColor = Color.FromArgb(30, 156, 37);
lb.Font = new Font(new FontFamily("Times New Roman"), 15, FontStyle.Bold);
}
else if (item.TrangThai1 == "có người")
{
iCoNguoi++;
lb.Font = new Font(new FontFamily("Times New Roman"), 11, FontStyle.Bold);
PhieuThue pt = PhieuThueDAO.Instance.getPhieuThueByMaPhong(item.MaPhong1);
KhachHang kh = KhachHangDAO.Instance.getKhachHangByMaKh(pt.MaKH1);
lb1.BackColor = Color.FromArgb(241, 71, 71);
lb.BackColor = Color.FromArgb(230, 203, 203);
String ngayDen = pt.NgayDen1.Day + "/" + pt.NgayDen1.Month + "/" + pt.NgayDen1.Year;
String ngayDi = pt.NgayDi1.Day + "/" + pt.NgayDi1.Month + "/" + pt.NgayDi1.Year;
lb.Text = ngayDen + "\n\n" + kh.TenKH1 + "\n\n" + ngayDi;
lb.ForeColor = Color.FromArgb(241, 71, 71);
}
FlowLayoutPanel f = new FlowLayoutPanel()
{
Height = 90, Width = 180
};
f.Margin = new System.Windows.Forms.Padding(8, 8, 8, 8);
f.Controls.Add(lb1);
f.Controls.Add(lb);
switch (item.Tang1)
{
case 1:
flpPhong.Controls.Add(f);
break;
case 2:
flpPhongOfTang2.Controls.Add(f);
break;
case 3:
flpPhongOfTang3.Controls.Add(f);
break;
default:
break;
}
}
String trong = "Trống";
String coNguoi = "Có Người";
lbTrong.Text = trong + "(" + iTrong + ")";
lbCoNguoi.Text = coNguoi + "(" + iCoNguoi + ")";
}
public int XoaPhieuThue(PhieuThue PT)
{
return(conn.ThucHienLenh("Delete PHIEUTHUE where MaPT = '" + PT.MaPT + "'"));
}
public int SuaPhieuThue(PhieuThue PT)
{
return(conn.ThucHienLenh("Update PHIEUTHUE Set NgayDi = '" + PT.NgayDi + "' where MaPT = '" + PT.MaPT + "'"));
}
public int ThemPhieuThue(PhieuThue PT)
{
return(conn.ThucHienLenh("execute ThemPhieuThue '" + PT.NgayDen + "','" + PT.NgayDi + "','" + PT.MaKH + "',N'" + PT.HinhThucThue + "'"));
//return conn.ThucHienLenh("Insert into PHIEUTHUE(NgayDen, NgayDi, MaKH, HinhThucThue) values('" +PT.NgayDen + "','"+ PT.NgayDi+"','" + PT.MaKH + "',N'" + PT.HinhThucThue + "')");
}
public void SuaThongTin(PhieuThue EC_PT)
{
connect.ThucHienLenh("update tblPhieuThue set MaKH = N'" + EC_PT.MaKH + "', MaPh = N'" + EC_PT.MaPh + "' where MaPhieu = '" + EC_PT.MaPhieu + "'");
}
