public ActionResult XacNhanThemMoi(string data) { dynamic dataJson = JObject.Parse(data); var maNV = dataJson.mnv; var maCC = dataJson.mcc; var ngayCap = DateTime.ParseExact(Convert.ToString(dataJson.ngaycap), "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture); var ngayTra = DateTime.ParseExact(Convert.ToString(dataJson.ngaytra), "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture); var sohieu = dataJson.sohieu + ""; using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { try { ChungChi_NhanVien ccnv = new ChungChi_NhanVien { MaNV = maNV, MaChungChi = maCC, NgayCap = Convert.ToDateTime(ngayCap), NgayTra = Convert.ToDateTime(ngayTra), SoHieu = sohieu }; if (ccnv.SoHieu != null && !ccnv.SoHieu.Equals("")) { db.ChungChi_NhanVien.Add(ccnv); db.SaveChanges(); return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult EditCertificateEmp(string id) { using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { List <ChungChi> listdata_chungchi = db.ChungChis.ToList <ChungChi>(); List <NhanVien> listdata_nv = db.NhanViens.ToList <NhanVien>(); SelectList listCirtificate = new SelectList(listdata_chungchi, "MaChungChi", "TenChungChi"); SelectList listEmployee = new SelectList(listdata_nv, "MaNV", "MaNV"); ViewBag.List_chungchi = listCirtificate; ViewBag.List_nhanvien = listEmployee; var cirtificate_emp = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>(); if (cirtificate_emp != null) { var emp = db.NhanViens.Where(x => x.MaNV == cirtificate_emp.MaNV).FirstOrDefault <NhanVien>(); if (emp != null) { ViewBag.nameEmp = emp.Ten; ViewBag.first_cir = cirtificate_emp.MaChungChi; } } ChungChi_NhanVien chungchinv = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>(); return(View(chungchinv)); } }
public ActionResult DeleteCertificateEmp(string id) { using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { ChungChi_NhanVien chungchi_nv = db.ChungChi_NhanVien.Where(x => x.SoHieu == id).FirstOrDefault <ChungChi_NhanVien>(); db.ChungChi_NhanVien.Remove(chungchi_nv); db.SaveChanges(); return(Json(new { success = true, message = "Delete successful" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditCertificateEmp(ChungChi_NhanVien chungchinv) { using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { if (chungchinv != null) { db.Entry(chungchinv).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("List")); } }
public ActionResult AddCertificateEmployee(ChungChi_NhanVien chungChi_nhanVien) { using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { if (chungChi_nhanVien != null) { db.ChungChi_NhanVien.Add(chungChi_nhanVien); db.SaveChanges(); } return(RedirectToAction("List")); } }
public ActionResult updateGiayTo(String json) { dynamic js = JObject.Parse(json); String manv = js.manv; String sohieu = js.sohieu; String kieu = js.kieu; String ngaytra = js.ngaytra; using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { // GiayChungNhan_NhanVien x = (from a in db.GiayChungNhan_NhanVien where a.MaNV == manv & a.SoHieu==sohieu select a).SingleOrDefault() ; ChungChi_NhanVien x = (from a in db.ChungChi_NhanVien where a.MaNV == manv & a.SoHieu == sohieu select a).SingleOrDefault(); ChiTiet_BangCap_GiayChungNhan y = (from a in db.ChiTiet_BangCap_GiayChungNhan where a.MaNV == manv & a.SoHieu == sohieu select a).SingleOrDefault(); if (x != null) { if (isValidateDateTime(ngaytra)) { x.NgayTra = Convert.ToDateTime(ngaytra); } } if (y != null) { if (isValidateDateTime(ngaytra)) { y.NgayTra = Convert.ToDateTime(ngaytra); } } //if (z != null) //{ // if (isValidateDateTime(ngaytra)) // z.NgayTra = Convert.ToDateTime(ngaytra); //} db.SaveChanges(); return(Json(new { success = true, draw = Request["draw"] }, JsonRequestBehavior.AllowGet));; } }