//private void btnTimMaDia_TraDia_Click(object sender, EventArgs e)
//{
// MaDiaCD = txtMaDia_TraDia.Text;
// eLapPhieuTra PhieuTra = new eLapPhieuTra();
// PhieuTra = busLapPhieuTra.LayThongTinPhieuTra(MaDiaCD);
// if (PhieuTra != null)
// {
// MaPhieuThue = PhieuTra.MaPhieuThue;
// txtTenTieuDeDia_TraDia.Text = PhieuTra.TenTieuDe;
// txtLoaiDia_TraDia.Text = PhieuTra.LoaiDia;
// dateTimePicker_NgayThue_TraDia.Value = PhieuTra.NgayThueDia;
// dateTimePicker_NgayPhaiTra.Value = PhieuTra.NgayPhaiTra;
// txtMaKH_TraDia.Text = PhieuTra.MaKhachHang;
// txtTenKH_TraDia.Text = PhieuTra.TenKhachHang;
// dateTimePicker_NgayTraDia.Value = DateTime.Now;
// if (dateTimePicker_NgayPhaiTra.Value < dateTimePicker_NgayTraDia.Value)
// {
// lblHienThiPhiPhat_TraDia.Text = "5000";
// KiemTraTraDia = false;
// }
// else
// {
// lblHienThiPhiPhat_TraDia.Text = "0";
// KiemTraTraDia = true;
// }
// }
// else
// {
// MessageBox.Show("Không tìm thấy đỉa thuê !.", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
// }
//}
private void btnTraDia_Click(object sender, EventArgs e)
{
if (txtMaDia_TraDia.Text.Equals("") || txtMaKH_TraDia.Text.Equals(""))
{
MessageBox.Show("Vui Lòng Nhập Mã Đỉa CD !.", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
return;
}
else
{
eLapPhieuTra PhieuTra = new eLapPhieuTra();
PhieuTra.MaPhieuThue = MaPhieuThue;
PhieuTra.NgayTraDia = dateTimePicker_NgayTraDia.Value;
PhieuTra.PhiPhat = Convert.ToDecimal(lblHienThiPhiPhat_TraDia.Text);
PhieuTra.KiemTraPhiPhat = KiemTraTraDia;
busLapPhieuTra.UpdateTongPhiPhatKhachHang(txtMaKH_TraDia.Text, PhieuTra.PhiPhat);
busLapPhieuTra.UpdatePhieuThue(MaPhieuThue, PhieuTra);
busLapPhieuTra.UpdateTrangThaiDia(MaDiaCD);
////////////////--Nguyễn Lê Ngân Bình--///////////////////
string maTieuDe = busDatDia.LayMaTieuDeBangTenTieuDe(txtTenTieuDeDia_TraDia.Text);
busLapPhieuTra.tuDongGanDia(txtMaDia_TraDia.Text, maTieuDe);
////////////////--Nguyễn Lê Ngân Bình--///////////////////
MessageBox.Show("Ghi Nhận Trả Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
txtMaDia_TraDia.Clear();
txtLoaiDia_TraDia.Clear();
txtTenTieuDeDia_TraDia.Clear();
txtMaKH_TraDia.Clear();
txtTenKH_TraDia.Clear();
dateTimePicker_NgayPhaiTra.Value = DateTime.Now;
dateTimePicker_NgayThue_TraDia.Value = DateTime.Now;
dateTimePicker_NgayTraDia.Value = DateTime.Now;
lblHienThiPhiPhat_TraDia.Text = "0";
}
}
private void txtMaDia_TraDia_Leave(object sender, EventArgs e)
{
MaDiaCD = txtMaDia_TraDia.Text;
eLapPhieuTra PhieuTra = new eLapPhieuTra();
PhieuTra = busLapPhieuTra.LayThongTinPhieuTra(MaDiaCD);
if (PhieuTra != null)
{
MaPhieuThue = PhieuTra.MaPhieuThue;
txtTenTieuDeDia_TraDia.Text = PhieuTra.TenTieuDe;
txtLoaiDia_TraDia.Text = PhieuTra.LoaiDia;
dateTimePicker_NgayThue_TraDia.Value = PhieuTra.NgayThueDia;
dateTimePicker_NgayPhaiTra.Value = PhieuTra.NgayPhaiTra;
txtMaKH_TraDia.Text = PhieuTra.MaKhachHang;
txtTenKH_TraDia.Text = PhieuTra.TenKhachHang;
dateTimePicker_NgayTraDia.Value = DateTime.Now;
if (dateTimePicker_NgayPhaiTra.Value < dateTimePicker_NgayTraDia.Value)
{
lblHienThiPhiPhat_TraDia.Text = Convert.ToDouble(PhieuTra.PhiPhat).ToString();
KiemTraTraDia = false;
}
else
{
lblHienThiPhiPhat_TraDia.Text = "0";
KiemTraTraDia = true;
}
}
else
{
MessageBox.Show("Không tìm thấy đỉa thuê !.", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
}
}
public void UpdatePhieuThue(string maPhieuThue, eLapPhieuTra phieutra)
{
IQueryable <tbLapPhieuThue> updateDia = db.tbLapPhieuThues.Where(x => x.MaPhieuThue == maPhieuThue);
updateDia.First().MaPhieuThue = maPhieuThue;
updateDia.First().NgayTraDia = phieutra.NgayTraDia;
updateDia.First().PhiPhat = phieutra.PhiPhat;
updateDia.First().KiemTraPhiPhat = phieutra.KiemTraPhiPhat;
db.SubmitChanges();
}
public eLapPhieuTra LayThongTinPhieuTra(string maDiaCD)
{
var dsDiaTam = db.tbDiaCDs.Where(x => x.MaDiaCD == maDiaCD).ToList();
var dsPhieuThueTam = db.tbLapPhieuThues.ToList();
var dsKhachHang = db.tbKhachHangs.ToList();
var dsTieuDe = db.tbTieuDes.ToList();
var dsLoaiDia = db.tbLoaiDias.ToList();
eLapPhieuTra lapPhieuTra = new eLapPhieuTra();
foreach (tbDiaCD DiaTam in dsDiaTam)
{
if (DiaTam.TinhTrangDia.Equals("Đang Thuê"))
{
foreach (tbTieuDe tieudetam in dsTieuDe)
{
if (DiaTam.MaTieuDe.Equals(tieudetam.MaTieuDe))
{
lapPhieuTra.TenTieuDe = tieudetam.TenTieuDe;
foreach (tbLoaiDia loaiphim in dsLoaiDia)
{
if (tieudetam.MaLoai.Equals(loaiphim.MaLoai))
{
lapPhieuTra.LoaiDia = loaiphim.TenLoai;
lapPhieuTra.PhiPhat = (decimal)loaiphim.PhiPhat;
}
}
}
}
foreach (tbLapPhieuThue phieuthuetam in dsPhieuThueTam)
{
if (phieuthuetam.MaDiaCD.Equals(DiaTam.MaDiaCD))
{
lapPhieuTra.MaPhieuThue = phieuthuetam.MaPhieuThue;
lapPhieuTra.NgayThueDia = Convert.ToDateTime(phieuthuetam.NgayThueDia);
lapPhieuTra.NgayPhaiTra = Convert.ToDateTime(phieuthuetam.NgayPhaiTra);
foreach (tbKhachHang khachhangtam in dsKhachHang)
{
if (khachhangtam.MaKhachHang.Equals(phieuthuetam.MaKhachHang))
{
lapPhieuTra.MaKhachHang = khachhangtam.MaKhachHang;
lapPhieuTra.TenKhachHang = khachhangtam.TenKH;
}
}
}
}
return(lapPhieuTra);
}
else
{
return(null);
}
}
return(null);
}
