public int ThemNhiemVu(ThemNhiemVuMoel model)
{
var iMaNguoiDangCode = CurrentContext.GetUser().iMaThanhVienCode;
var task = new Models.NhiemVu();
task.dNgayLap = DateTime.Now;
task.dNgayBD = model.dNgayBD;
task.dNgayKT = model.dNgayKT;
task.iMaNguoiDuocGiaoCode = 14;
task.vTenNhiemVu = model.vTenNhiemVu;
task.vMoTa = model.vMoTa;
task.iMaNguoiDangCode = iMaNguoiDangCode;
task.iMaTrangThaiCode = 1;
task.iMaModuleCode = model.iMaModuleCode;
try
{
using (var db = new dbnhiemvuEntities())
{
db.NhiemVus.Add(task);
db.SaveChanges();
}
return(task.iMaNhiemVuCode);
}
catch
{
return(0);
}
}
public ActionResult LuuLoiCanSua(string noidungloi, int id)
{
dbnhiemvuEntities db = new dbnhiemvuEntities();
ChiTietLoi chitietloi = new ChiTietLoi();
Models.NhiemVu nhiemvu = new Models.NhiemVu();
try
{
nhiemvu = db.NhiemVus.Find(id);
nhiemvu.iMaTrangThaiCode = 5;
chitietloi.iMaNhiemVuCode = id;
chitietloi.vChiTietLoi = noidungloi;
chitietloi.iTrangThai = 1;
db.ChiTietLois.Add(chitietloi);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(Json(chitietloi));
}
public ActionResult NopNhiemVu(int id, int trangthai)
{
dbnhiemvuEntities db = new dbnhiemvuEntities();
Models.NhiemVu nhiemvu = new Models.NhiemVu();
try
{
if (trangthai == 2)
{
nhiemvu = db.NhiemVus.Find(id);
nhiemvu.iMaTrangThaiCode = 3;
db.SaveChanges();
}
else if (trangthai == 3)
{
nhiemvu = db.NhiemVus.Find(id);
nhiemvu.iMaTrangThaiCode = 5;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(true));
}
public ActionResult Duyet(int id)
{
dbnhiemvuEntities db = new dbnhiemvuEntities();
Models.NhiemVu nhiemvu = new Models.NhiemVu();
try
{
nhiemvu = db.NhiemVus.Find(id);
nhiemvu.iMaTrangThaiCode = 4;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(Json(true));
}
public ActionResult ThemNhiemVu(string vTenNhiemVu, string vMoTa, int iMaThanhVienCode, DateTime dNgayBD, DateTime dNgayKT)
{
dbnhiemvuEntities db = new dbnhiemvuEntities();
Models.NhiemVu nhiemvu = new Models.NhiemVu();
List <LayNhiemVu> laynhiemvuvualuu = new List <Models.LayNhiemVu>();
try
{
nhiemvu.vTenNhiemVu = vTenNhiemVu;
nhiemvu.vMoTa = vMoTa;
nhiemvu.iMaNguoiDuocGiaoCode = iMaThanhVienCode;
nhiemvu.iMaNguoiDangCode = 1;
nhiemvu.dNgayBD = dNgayBD;
nhiemvu.dNgayKT = dNgayKT;
nhiemvu.iMaTrangThaiCode = 1;
db.NhiemVus.Add(nhiemvu);
db.SaveChanges();
laynhiemvuvualuu = (from nv in db.NhiemVus
join tv in db.ThanhViens on nv.iMaNguoiDangCode equals tv.iMaThanhVienCode
join tv1 in db.ThanhViens on nv.iMaNguoiDuocGiaoCode equals tv1.iMaThanhVienCode
where nv.iMaNhiemVuCode == nhiemvu.iMaNhiemVuCode
select new LayNhiemVu
{
iMaNhiemVuCode = nv.iMaNhiemVuCode,
vNguoiDang = tv.vTenDangNhap,
vNguoiDuocGiaoCode = tv1.vTenDangNhap,
vMoTa = nv.vMoTa,
vTenNhiemVu = nv.vTenNhiemVu,
dNgayBD = nv.dNgayBD,
dNgayKT = nv.dNgayKT,
iMaTrangThaiCode = nv.iMaTrangThaiCode
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(Json(laynhiemvuvualuu));
}
public ActionResult SuaNhiemVu(int id, string vTenNhiemVu, string vMoTa, DateTime dNgayBD, DateTime dNgayKT)
{
dbnhiemvuEntities db = new dbnhiemvuEntities();
Models.NhiemVu nhiemvu = new Models.NhiemVu();
List <LayNhiemVu> laynhiemvuvualuu = new List <Models.LayNhiemVu>();
try
{
nhiemvu = db.NhiemVus.Find(id);
nhiemvu.vTenNhiemVu = vTenNhiemVu;
nhiemvu.vMoTa = vMoTa;
//nhiemvu.iMaNguoiDangCode = 1;
nhiemvu.dNgayBD = dNgayBD;
nhiemvu.dNgayKT = dNgayKT;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(Json(true));
}
