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