private void btnLuu_Click(object sender, EventArgs e) { int soLoi = 0; if (!CheckTenCongViec()) { soLoi++; } if (!CheckNgayKetThuc()) { soLoi++; } if (soLoi > 0) { txtTenCongViec.Focus(); MessageBox.Show("Thong Tin Nhap Khong Hop Le"); return; } eDuAn da = busDuAn.GetItemByCondition(t => t.MaDuAn.Equals(cboDuAn.SelectedValue.ToString())); congViec.DuAn = new eDuAn(da.MaDuAn, da.TenDuAn, null, da.NgayBatDau, da.NgayKetThuc, da.TienDo, da.TrangThai); congViec.TenCongViec = txtTenCongViec.Text; congViec.Tiendo = (int)nudTienDoCongViec.TextAlign; congViec.TrangThai = cboTrangThai.Text; congViec.NgayBatDau = dtmNgayKetThuc.Value; congViec.NgayKetThuc = dtmNgayBatDau.Value; congViec.ViTriCongViec = cboViTriCongViec.Text; busCongViec.AddItem(congViec); DialogResult = DialogResult.OK; this.Close(); }
public frm_themDuAn() { InitializeComponent(); eDuAn = new eDuAn(); busDuAn = new BUSDuAn(); ePhuongXa = new List <ePhuongXa>(); eQuanHuyen = new List <eQuanHuyen>(); eThanhPho = new List <eThanhPho>(); busDiaChi = new BUSDiaChi(); }
bool CheckNgayKyKet() { eDuAn duAn = busDuAn.GetItemByCondition(t => t.MaDuAn.Equals(cboDuAn.SelectedValue.ToString())); if (dtmNgayKyKet.Value < duAn.NgayBatDau || dtmNgayKyKet.Value > duAn.NgayKetThuc || dtmNgayKyKet.Value > DateTime.Now) { errorProvider1.SetError(dtmNgayKyKet, "ngay Ky Ket > ngay Du An bat dau. Ngay Du An:" + duAn.NgayBatDau.ToLongDateString() + " - " + duAn.NgayKetThuc.ToLongDateString()); return(false); } return(true); }
private void btnSua_Click(object sender, EventArgs e) { if (dgv_duAn.SelectedRows.Count > 0) { string maDuAn = dgv_duAn.SelectedCells[0].Value.ToString(); List <eDuAn> da = _duAn.GetAllList(); eDuAn duAn = da.Where(t => t.MaDuAn.Equals(maDuAn)).SingleOrDefault(); frm_suaDuAn suaCongViec = new frm_suaDuAn(duAn.MaDuAn, duAn.TenDuAn, duAn.NgayBatDau, duAn.NgayKetThuc, duAn.TrangThai, duAn.TienDo, duAn.DiaChi.maDiaChi, duAn.DiaChi.soNha, duAn.DiaChi.phuongXa, duAn.DiaChi.quanHuyen, duAn.DiaChi.thanhPho); suaCongViec.ShowDialog(); } }
private void dtmNgayKyKet_Leave(object sender, EventArgs e) { eDuAn duAn = busDuAn.GetItemByCondition(t => t.MaDuAn.Equals(cboDuAn.SelectedValue.ToString())); if (dtmNgayKyKet.Value < duAn.NgayBatDau || dtmNgayKyKet.Value > DateTime.Now) { dtmNgayKyKet.Focus(); errorProvider1.SetError(dtmNgayKyKet, "ngay Ky Ket > ngay Du An bat dau. Ngay Du An:" + duAn.NgayBatDau.ToShortDateString() + "\n" + "Ngay ky ket <= ngay hien tai"); } else { errorProvider1.SetError(dtmNgayKyKet, ""); } }
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; }
/// <summary> /// name: Quynh /// content: Them mot du an moi /// </summary> public void Add(eDuAn entity) { ThemDuAn da = new ThemDuAn(); da.tenDuAn = entity.TenDuAn; da.ngayBatDau = entity.NgayBatDau; da.ngayKetThuc = entity.NgayKetThuc; da.tienDoHoanThanh = entity.TienDo; da.trangThai = entity.TrangThai; da.soNha = entity.DiaChi.soNha; da.phuongXa = entity.DiaChi.phuongXa; da.quanHuyen = entity.DiaChi.quanHuyen; da.ThanhPho = entity.DiaChi.thanhPho; db.ThemDuAns.InsertOnSubmit(da); db.SubmitChanges(); }
/// <summary> /// name: Quynh /// content: Tim kiem 1 du an theo yeu cau /// </summary> public eDuAn GetItemyByCondition(Func <eDuAn, bool> lambda) { eDuAn duAn = db.DuAns.Join( db.DiaChis, da => da.maDiaChi, dc => dc.maDiaChi, (da, dc) => new eDuAn { DiaChi = new eDiaChi(dc.maDiaChi, dc.soNha, dc.phuongXa, dc.quanHuyen, dc.thanhPho), MaDuAn = da.maDuAn, NgayBatDau = da.ngayBatDau, NgayKetThuc = da.ngayKetThuc, TenDuAn = da.tenDuAn, TienDo = da.tienDoHoanThanh, TrangThai = da.trangThai }) .Where(lambda).SingleOrDefault(); return(duAn); }
private void btnChon_Click(object sender, EventArgs e) { int soLoi = 0; if (!ChecktenHopDong()) { soLoi++; } if (!CheckNgayKyKet()) { soLoi++; } if (!CheckNgayHetHan()) { soLoi++; } if (!CheckGiaTriHopDong()) { soLoi++; } if (soLoi > 0) { txtTenHopDong.Focus(); MessageBox.Show("Thong Tin Khong Hop Le"); return; } eDuAn duAn = busDuAn.GetItemByCondition(t => t.MaDuAn.Equals(cboDuAn.SelectedValue.ToString())); eHopDong.duAn = new eDuAn(duAn.MaDuAn, duAn.TenDuAn, null, duAn.NgayBatDau, duAn.NgayKetThuc, duAn.TienDo, duAn.TrangThai); eHopDong.tenHopDong = txtTenHopDong.Text; eHopDong.ngayKyKet = dtmNgayKyKet.Value; eHopDong.ngayHetHan = dtmNgayHetHan.Value; eHopDong.giaTriHopDong = (double)nudGiaTriHopDong.Value; eHopDong.thongTin = txtThongTin.Text; busHopDong.AddItem(eHopDong); this.Close(); }
/// <summary> /// name: Quynh /// content: Chinh sua thong tin cua du an trong co so du lieu /// </summary> public void Update(eDuAn entity) { DuAn da = db.DuAns.Where(t => t.maDuAn.Equals(entity.MaDuAn)).SingleOrDefault(); da.tenDuAn = entity.TenDuAn; da.ngayBatDau = entity.NgayBatDau; da.ngayKetThuc = entity.NgayKetThuc; da.tienDoHoanThanh = entity.TienDo; da.trangThai = entity.TrangThai; db.SubmitChanges(); DiaChi dc = db.DiaChis.Where(t => t.maDiaChi.Equals(entity.DiaChi.maDiaChi)).SingleOrDefault(); dc.soNha = entity.DiaChi.soNha; dc.phuongXa = entity.DiaChi.phuongXa; dc.quanHuyen = entity.DiaChi.quanHuyen; dc.thanhPho = entity.DiaChi.thanhPho; db.SubmitChanges(); }
public frm_suaDuAn(string maDuAn, string tenDuAn, DateTime ngayBatDau, DateTime ngayKetThuc, string trangThai, int tienDoHoanThanh, string maDiaChi, string soNha, string phuongXa, string quanHuyen, string thanhPho) { InitializeComponent(); ePhuongXa = new List <ePhuongXa>(); eQuanHuyen = new List <eQuanHuyen>(); eThanhPho = new List <eThanhPho>(); busDiaChi = new BUSDiaChi(); eDuAn = new eDuAn(); busDuAn = new BUSDuAn(); eDuAn.MaDuAn = maDuAn; eDuAn.NgayBatDau = ngayBatDau; eDuAn.NgayKetThuc = ngayKetThuc; eDuAn.TrangThai = trangThai; eDuAn.TienDo = tienDoHoanThanh; eDuAn.TenDuAn = tenDuAn; eDuAn.DiaChi = new eDiaChi(maDiaChi, soNha, phuongXa, quanHuyen, thanhPho); }
public frm_suaCongViec(string maCongViec, eDuAn duAn, string tenCongViec, DateTime ngayBatDau, DateTime ngayKetThuc, string trangThai, int tienDoCongViec, string viTriCongViec) { InitializeComponent(); congViec = new eCongViec(); busCongViec = new BUSCongViec(); congViec.MaCongViec = maCongViec; congViec.DuAn = duAn; congViec.TrangThai = trangThai; congViec.Tiendo = tienDoCongViec; congViec.NgayBatDau = ngayBatDau; congViec.NgayKetThuc = ngayKetThuc; congViec.TenCongViec = tenCongViec; congViec.ViTriCongViec = viTriCongViec; // Gan gia tri Trang Thai cho combobox cboTrangThai.DataSource = new string[] { "Chưa thực hiện", "Đang thực hiện", "Hoàn thành" }; // Gan gia tri Vi Tri Cong Viec cho combobox cboViTriCongViec.DataSource = new string[] { "Quản Lý", "Khảo Sát", "Thiết Kế", "Giám Sát", "Thi Công" }; }
/// <summary> /// name: Quynh /// content: Chinh sua thong tin cua du an trong co so du lieu /// </summary> public void UpdateItem(eDuAn entity) { dalDuAn.Update(entity); }
/// <summary> /// name: Quynh /// content: Them mot du an moi /// </summary> public void AddItem(eDuAn entity) { dalDuAn.Add(entity); }