private void editbt_Click(object sender, EventArgs e)
{
bool check = false;
if (KiemTraError(check) == true)
{
return;
}
ClassCongViec congviec = new ClassCongViec
{
MaCV = this.txtMacv.Text.Trim(),
TenCV = this.txtTencv.Text.Trim(),
ChiTiet = this.txtChitiet.Text.Trim()
};
congviec.listDA.Add(DAController.GetDuAn(this.cbbMaDA.Text.Trim()));
if (CongViecController.UpdateCV(congviec) == false)
{
MessageBox.Show("Loi khi sua cong viec", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
this.txtChitiet.Clear();
this.txtMacv.Clear();
this.txtTencv.Clear();
this.errorProvider1.Clear();
this.errorProvider2.Clear();
this.errorProvider3.Clear();
}
public static bool AddCV(ClassCongViec cv)
{
try
{
using (var _context = new DBManageContext())
{
ClassCongViec congviec = new ClassCongViec {
MaCV = cv.MaCV, TenCV = cv.TenCV, ChiTiet = cv.ChiTiet
};
_context.tbCongViec.Add(congviec);
_context.SaveChanges();
var dbcv = (from c in _context.tbCongViec
where c.MaCV == cv.MaCV
select c).Single();
foreach (var i in cv.listDA)
{
var dbda = (from d in _context.tbDuAn
where d.MaDA == i.MaDA
select d).Single();
dbcv.listDA.Add(dbda);
}
_context.tbCongViec.AddOrUpdate(dbcv);
_context.SaveChanges();
}
}
catch
{
return(false);
}
return(true);
}
public static bool UpdateCV(ClassCongViec cv)
{
try
{
using (var _context = new DBManageContext())
{
ClassCongViec congviec = new ClassCongViec {
MaCV = cv.MaCV, TenCV = cv.TenCV, ChiTiet = cv.ChiTiet
};
foreach (var d in cv.listDA)
{
var dbda = (from da in _context.tbDuAn
where da.MaDA == d.MaDA
select da).Single();
congviec.listDA.Add(dbda);
}
_context.tbCongViec.AddOrUpdate(congviec);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
private void addbtn_Click(object sender, EventArgs e)
{
bool check = false;
if (KiemTraErr(check) == true)
{
return;
}
ClassNhanVien nvien = NhanVienController.GetNV(this.cbbManv.Text.Trim());
foreach (var cvg in nvien.listCVLam.ToList())
{
nvien.listCVLam.Remove(cvg);
}
foreach (var cvx in nvien.listCVXong.ToList())
{
nvien.listCVXong.Remove(cvx);
}
string displaycvGiao = "";
string displaycvHoanThanh = "";
for (int i = 0; i < listBoxG.Items.Count; i++)
{
displaycvGiao = displaycvGiao + this.listBoxG.Items + " ";
ClassCongViec cv = CongViecController.GetCV(this.listBoxG.Items[i].ToString());
nvien.listCVLam.Add(cv);
//nvien.MaDA = cv.listDA.ToList()[0].ToString() + " " + nvien.MaDA;
}
for (int j = 0; j < listBoxX.Items.Count; j++)
{
displaycvHoanThanh = displaycvHoanThanh + this.listBoxX.Items + " ";
nvien.listCVXong.Add(CongViecController.GetCV(this.listBoxX.Items[j].ToString()));
}
string mada = "";
foreach (var i in this.checkedListBox1.CheckedItems)
{
mada = mada + i.ToString() + " ";
}
nvien.MaDA = mada;
if (NhanVienController.UpdateNvien(nvien) == false)
{
MessageBox.Show("Loi them cong viec", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
ClearControls();
}
private void delbt_Click(object sender, EventArgs e)
{
//Kiem tra user co chon hang de xoa khong ?
//if (dataCongViec.SelectedRows.Count <= 0)
// return;
ClassCongViec cv = CongViecController.GetCV(this.txtMacv.Text.Trim());
//Xoa cong viec
if (CongViecController.DeleteCV(cv) == false)
{
MessageBox.Show("Loi khi xoa cong viec", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
}
public static bool DeleteCV(ClassCongViec cv)
{
try
{
using (var _context = new DBManageContext())
{
var task = (from t in _context.tbCongViec
where t.MaCV == cv.MaCV
select t).Single();
_context.tbCongViec.Remove(task);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
private void addbt_Click(object sender, EventArgs e)
{
bool check = false;
//Kiem tra MaCV da ton tai
if (CongViecController.GetCV(this.txtMacv.Text.Trim()) != null)
{
MessageBox.Show("Cong viec nay da ton tai", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//Kiem tra hop le
if (KiemTraError(check) == true)
{
return;
}
ClassCongViec congviec = new ClassCongViec();
congviec.MaCV = this.txtMacv.Text.Trim();
congviec.TenCV = this.txtTencv.Text.Trim();
congviec.ChiTiet = this.txtChitiet.Text.Trim();
congviec.listDA.Add(DAController.GetDuAn(this.cbbMaDA.Text.Trim()));
if (CongViecController.AddCV(congviec) == false)
{
MessageBox.Show("Loi khi them cong viec", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
//Xoa control
this.txtChitiet.Clear();
this.txtMacv.Clear();
this.txtTencv.Clear();
this.errorProvider1.Clear();
this.errorProvider2.Clear();
this.errorProvider3.Clear();
}
