public frm_suaHopDong()
{
InitializeComponent();
busHopDong = new BUSHopDong();
eHopDong = new eHopDong();
busDuAn = new BUSDuAn();
}
public List <eHopDong> LayDulieuTTHopDong() // Lấy dữ liêu hợp đông với tình trạng khác đã hủy
{
var hdlist = db.HopDongs.ToList();
List <eHopDong> ls = new List <eHopDong>();
foreach (HopDong hd in hdlist)
{
if (hd.TinhTrang == "")
{
hd.TinhTrang = "Đã hủy";
}
if (hd.TinhTrang != "Đã hủy")
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
ls.Add(t);
}
}
return(ls);
}
public eHopDong LayHopDongTheoMaHDong(string mahdong)// Lấy 1 hợp dòng theo mã hợp đồng
{
HopDong hd = db.HopDongs.Where(s => s.MaHopDong.Trim() == mahdong).FirstOrDefault();
if (hd != null)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
t.TenNV = hd.TenNV;
return(t);
}
else
{
return(null);
}
}
public List <eHopDong> TimKiemTheoMaHD(string maHD) //Tim kiem hop dong theo tt hợp đồng
{
var hdlist = db.HopDongs.Where(delegate(HopDong c)
{
if (ConvertToUnSign(c.MaHopDong + c.MaKH + c.TenKH + c.TenNV + c.DiaChi + c.HanBH + c.HinhThucTT + c.NgayLap + c.TenXe + c.TinhTrang + c.Gia).IndexOf(maHD, StringComparison.CurrentCultureIgnoreCase) >= 0)
{
return(true);
}
else
{
return(false);
}
}).AsQueryable();
List <eHopDong> lhdong = new List <eHopDong>();
foreach (HopDong hd in hdlist)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
lhdong.Add(t);
}
return(lhdong);
}
public List <eHopDong> ThongKeTheoTinhTrangHD(string tinhtrang) // Thong ke hop dong theo tình trạng hợp đồng
{
var hdlist = (from s in db.HopDongs
where s.TinhTrang.Contains(tinhtrang)
select s).ToList();
List <eHopDong> lhdong = new List <eHopDong>();
foreach (HopDong hd in hdlist)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
lhdong.Add(t);
}
return(lhdong);
}
public List <eHopDong> LayDulieuHopDong() // Lấy dữ liệu từ csdl sang lớp entity
{
var hdlist = db.HopDongs.ToList();
List <eHopDong> ls = new List <eHopDong>();
foreach (HopDong hd in hdlist)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
if (hd.TinhTrang == "")
{
hd.TinhTrang = "Đã hủy";
}
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
ls.Add(t);
}
return(ls);
}
public List <eHopDong> ThongKeTheoNgayLap(DateTime ngaylap) // Thong ke hop dong theo ngay thang nam
{
var lhdong = db.HopDongs.Where(s => s.NgayLap == ngaylap).ToList();
List <eHopDong> lhd = new List <eHopDong>();
foreach (HopDong hd in lhdong)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
lhd.Add(t);
}
return(lhd);
}
public List <eHopDong> ThongKeTheoTatCa(DateTime ngaylap, string tennv, string tenkh, string tinhtrang) // Thong ke hop dong theo tat ca
{
var hdlist = (from s in db.HopDongs
where s.NgayLap == ngaylap && s.TenNV.Contains(tennv) &&
s.TenKH.Contains(tenkh) &&
s.TinhTrang.Contains(tinhtrang)
select s).ToList();
List <eHopDong> lhd = new List <eHopDong>();
foreach (HopDong hd in hdlist)
{
eHopDong t = new eHopDong();
t.MaKH = hd.MaKH;
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.DiaChi = hd.DiaChi;
t.HanBH = DateTime.Parse(hd.HanBH.ToString());
t.HinhThucTT = hd.HinhThucTT;
t.MaHopDong = hd.MaHopDong;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenXe = hd.TenXe;
t.TinhTrang = hd.TinhTrang;
t.Gia = double.Parse(hd.Gia.ToString());
lhd.Add(t);
}
return(lhd);
}
/// <summary>
/// name: Quynh
/// content: Chinh sua thong tin hop dong
/// </summary>
public void Update(eHopDong entity)
{
HopDong hd = db.HopDongs.Where(t => t.maHopDong.Equals(entity.maHopDong)).SingleOrDefault();
hd.ngayHetHan = entity.ngayHetHan;
hd.ngayKyKet = entity.ngayKyKet;
hd.tenHopDong = entity.tenHopDong;
hd.thongTin = entity.thongTin;
hd.giaTriHopDong = (decimal)entity.giaTriHopDong;
db.SubmitChanges();
}
private void btnSua_Click(object sender, EventArgs e)
{
if (dgv_hopDong.SelectedRows.Count > 0)
{
string maHopDong = dgv_hopDong.SelectedCells[0].Value.ToString();
eHopDong hd = _hopDong.GetItemByCondiditon(t => t.maHopDong.Equals(maHopDong));
frm_suaHopDong suaHopDong = new frm_suaHopDong(maHopDong, hd.duAn, hd.tenHopDong, hd.ngayKyKet, hd.ngayHetHan, hd.giaTriHopDong, hd.thongTin);
suaHopDong.ShowDialog();
}
}
/// <summary>
/// name: Quynh
/// content: Them mot hop dong moi
/// </summary>
public void Add(eHopDong entity)
{
HopDong hd = new HopDong();
hd.maDuAn = entity.duAn.MaDuAn;
hd.ngayHetHan = entity.ngayHetHan;
hd.ngayKyKet = entity.ngayKyKet;
hd.tenHopDong = entity.tenHopDong;
hd.thongTin = entity.thongTin;
hd.giaTriHopDong = (decimal)entity.giaTriHopDong;
db.HopDongs.InsertOnSubmit(hd);
db.SubmitChanges();
}
public bool suaHD(eHopDong ehd)
{
Hop_Dong t = new Hop_Dong();
t.soHD = ehd.SoHD;
t.maKH = ehd.MaKH;
t.ng_NgThu = ehd.Ngayngthu;
t.tenKH = ehd.TenKH;
t.triGiaHD = Convert.ToDecimal(ehd.TriGiaHD);
t.diaChi = ehd.Diachi;
t.ngayHD = ehd.NgayHD;
t.ngayHD = ehd.Ngaygiao;
t.soXe = ehd.SoXe;
return(hddal.suaHD(t));
}
public frm_suaHopDong(string maHopDong, eDuAn duAn, string tenHopDong, DateTime ngayKyKet, DateTime ngayHetHan, double giaTriHopDong, string thongTin)
{
InitializeComponent();
eHopDong = new eHopDong();
busHopDong = new BUSHopDong();
eHopDong.maHopDong = maHopDong;
eHopDong.duAn = duAn;
eHopDong.tenHopDong = tenHopDong;
eHopDong.ngayKyKet = ngayKyKet;
eHopDong.ngayHetHan = ngayHetHan;
eHopDong.giaTriHopDong = giaTriHopDong;
eHopDong.thongTin = thongTin;
}
public eHopDong getTho(string ma)
{
eHopDong ehd = new eHopDong();
Hop_Dong t = new Hop_Dong();
t = hddal.getHD(ma);
ehd.SoHD = t.soHD;
ehd.MaKH = t.maKH;
ehd.Ngayngthu = t.ng_NgThu;
ehd.TenKH = t.tenKH;
ehd.TriGiaHD = Convert.ToDouble(t.triGiaHD);
ehd.Diachi = t.diaChi;
ehd.NgayHD = t.ngayHD;
ehd.Ngaygiao = t.ngayHD;
ehd.SoXe = t.soXe;
return(ehd);
}
public int ThemHDong(eHopDong hdongmoi) // Thêm nhân viên mới
{
HopDong temp = new HopDong();
temp.MaKH = hdongmoi.MaKH;
temp.TenKH = hdongmoi.TenKH;
temp.TenNV = hdongmoi.TenNV;
temp.DiaChi = hdongmoi.DiaChi;
temp.HanBH = DateTime.Parse(hdongmoi.HanBH.ToString());
temp.HinhThucTT = hdongmoi.HinhThucTT;
temp.MaHopDong = hdongmoi.MaHopDong;
temp.NgayLap = DateTime.Parse(hdongmoi.NgayLap.ToString());
temp.TenXe = hdongmoi.TenXe;
temp.TinhTrang = hdongmoi.TinhTrang;
temp.Gia = decimal.Parse(hdongmoi.Gia.ToString());
db.HopDongs.InsertOnSubmit(temp);
db.SubmitChanges();
return(1);
}
/// <summary>
/// name: Quynh
/// content: Tim kiem hop dong theo yeu cau
/// </summary>
public eHopDong GetItemByCondiditon(Func <eHopDong, bool> lambda)
{
eHopDong query = db.DuAns // your starting point - table in the "from" statement
.Join(db.HopDongs, // the source table of the inner join
da => da.maDuAn, // Select the primary key (the first part of the "on" clause in an sql "join" statement)
hd => hd.maDuAn, // Select the foreign key (the second part of the "on" clause)
(da, hd) => new eHopDong
{
//(String ma, String ten, eDiaChi diachi, DateTime ngaybatdau, DateTime ngayketthuc, int tiendo, String trangthai)
duAn = new eDuAn(da.maDuAn, da.tenDuAn, null, da.ngayBatDau, da.ngayKetThuc, da.tienDoHoanThanh, da.trangThai),
maHopDong = hd.maHopDong,
tenHopDong = hd.tenHopDong,
ngayKyKet = hd.ngayKyKet,
ngayHetHan = hd.ngayHetHan,
giaTriHopDong = (double)hd.giaTriHopDong,
thongTin = hd.thongTin
}) // selection
.Where(lambda).SingleOrDefault(); // where statement
return(query);
}
public List <eHopDong> getAllHopDong()
{
List <eHopDong> listehd = new List <eHopDong>();
List <Hop_Dong> listhd = new List <Hop_Dong>();
listhd = hddal.getAllHD();
foreach (Hop_Dong t in listhd)
{
eHopDong ehd = new eHopDong();
ehd.SoHD = t.soHD;
ehd.MaKH = t.maKH;
ehd.Ngayngthu = t.ng_NgThu;
ehd.TenKH = t.tenKH;
ehd.TriGiaHD = Convert.ToDouble(t.triGiaHD);
ehd.Diachi = t.diaChi;
ehd.NgayHD = t.ngayHD;
ehd.Ngaygiao = t.ngayHD;
ehd.SoXe = ehd.SoXe;
listehd.Add(ehd);
}
return(listehd);
}
/// <summary>
/// name: Quynh
/// content: Them mot hop dong moi
/// </summary>
public void AddItem(eHopDong entity)
{
dalHopDong.Add(entity);
}
/// <summary>
/// name: Quynh
/// content: Chinh sua thong tin hop dong
/// </summary>
public void UpdateItem(eHopDong entity)
{
dalHopDong.Update(entity);
}
