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);
}
