public ActionResult create(string Nam, string NamHoc, string tuNgay, string denNgay, bool NamHienTai) { if (String.IsNullOrEmpty(NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } DateTime dateFrom = DateTime.Parse(tuNgay); DateTime dateTo = DateTime.Parse(denNgay); var check = db.DM_NamHoc.Where(p => p.MaTruong == MaTruong && p.NamHoc == NamHoc).FirstOrDefault(); if (check != null) { return(Json(new ResultInfo() { error = 1, msg = "Đã tồn tại" }, JsonRequestBehavior.AllowGet)); } //kiem tra neu la nam hoc hien tai thi xoa nhưng cai con lai if (NamHienTai == true) { db.DM_NamHoc.Where(x => x.MaTruong == MaTruong && x.NamHoc != NamHoc).ToList().ForEach(x => { x.NamHienTai = false; }); db.SaveChanges(); } var insData = new DM_NamHoc() { Nam = Nam, NamHoc = NamHoc, TuNgay = dateFrom, DenNgay = dateTo, MaTruong = MaTruong, NamHienTai = NamHienTai }; db.DM_NamHoc.Add(insData); db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = insData }, JsonRequestBehavior.AllowGet)); }
public ActionResult edit(DM_NamHoc namhoc, string tuNgay, string denNgay) { if (String.IsNullOrEmpty(namhoc.NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } DateTime dateFrom = DateTime.Parse(tuNgay); DateTime dateTo = DateTime.Parse(denNgay); var check = db.DM_NamHoc.Where(p => p.MaTruong == MaTruong && p.NamHoc == namhoc.NamHoc).FirstOrDefault(); if (check == null) { return(Json(new ResultInfo() { error = 1, msg = "Không tìm thấy thông tin" }, JsonRequestBehavior.AllowGet)); } if (namhoc.NamHienTai == true) { db.DM_NamHoc.Where(x => x.MaTruong == MaTruong && x.NamHoc != namhoc.NamHoc).ToList().ForEach(x => { x.NamHienTai = false; }); // db.SaveChanges(); } check.Nam = namhoc.Nam; check.MaTruong = MaTruong; namhoc.TuNgay = dateFrom; namhoc.DenNgay = dateTo; check.DenNgay = namhoc.DenNgay; check.NamHienTai = namhoc.NamHienTai; db.Entry(check).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = check }, JsonRequestBehavior.AllowGet)); }
public ActionResult create(DM_NamHoc nh) { if (String.IsNullOrEmpty(nh.NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Chưa nhập thông tin năm học" }, JsonRequestBehavior.AllowGet)); } // 20/12/2018 db.DM_NamHoc.Add(nh); db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = nh }, JsonRequestBehavior.AllowGet)); }
public ActionResult edit(DM_NamHoc nh) { if (String.IsNullOrEmpty(nh.NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Chưa nhập năm học" }, JsonRequestBehavior.AllowGet)); } var check = db.DM_NamHoc.Where(p => p.MaDonVi == MaDonVi && p.NamHoc == nh.NamHoc).FirstOrDefault(); check.NamHoc = nh.NamHoc; db.Entry(check).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = check }, JsonRequestBehavior.AllowGet)); }
public ActionResult create(string NamHoc, string NienKhoa, string tuNgay, string denNgay, bool HienTai) { if (String.IsNullOrEmpty(NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } // 20/12/2018 string tngay = tuNgay.Substring(0, 2); string tthang = tuNgay.Substring(3, 2); string tnam = tuNgay.Substring(6, 4); string dngay = denNgay.Substring(0, 2); string dthang = denNgay.Substring(3, 2); string dnam = denNgay.Substring(6, 4); string sysFormat = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern; //format sever M/d/yyyy DateTime dateFrom; DateTime dateTo; if (sysFormat == "M/d/yyyy") { dateFrom = DateTime.Parse(tthang + '/' + tngay + '/' + tnam); dateTo = DateTime.Parse(dthang + '/' + dngay + '/' + dnam); } else { dateFrom = DateTime.Parse(tuNgay); dateTo = DateTime.Parse(denNgay); } var check = db.DM_NamHoc.Where(p => p.MaTruong == MaDonVi && p.NamHoc == NamHoc).FirstOrDefault(); if (check != null) { return(Json(new ResultInfo() { error = 1, msg = "Đã tồn tại" }, JsonRequestBehavior.AllowGet)); } //kiem tra neu la nam hoc hien tai thi xoa nhưng cai con lai if (HienTai == true) { db.DM_NamHoc.Where(x => x.MaTruong == MaDonVi && x.NamHoc != NamHoc).ToList().ForEach(x => { x.HienTai = false; }); db.SaveChanges(); } var insData = new DM_NamHoc() { NamHoc = NamHoc, TuNgay = dateFrom, DenNgay = dateTo, MaTruong = MaDonVi, NienKhoa = NienKhoa, HienTai = HienTai }; db.DM_NamHoc.Add(insData); db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = sysFormat }, JsonRequestBehavior.AllowGet)); }
public ActionResult edit(DM_NamHoc namhoc, string tuNgay, string denNgay) { if (String.IsNullOrEmpty(namhoc.NamHoc)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } string tngay = tuNgay.Substring(0, 2); string tthang = tuNgay.Substring(3, 2); string tnam = tuNgay.Substring(6, 4); string dngay = denNgay.Substring(0, 2); string dthang = denNgay.Substring(3, 2); string dnam = denNgay.Substring(6, 4); string sysFormat = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern; //format sever M/d/yyyy DateTime dateFrom; DateTime dateTo; if (sysFormat == "M/d/yyyy") { dateFrom = DateTime.Parse(tthang + '/' + tngay + '/' + tnam); dateTo = DateTime.Parse(dthang + '/' + dngay + '/' + dnam); } else { dateFrom = DateTime.Parse(tuNgay); dateTo = DateTime.Parse(denNgay); } var check = db.DM_NamHoc.Where(p => p.MaTruong == MaDonVi && p.NamHoc == namhoc.NamHoc).FirstOrDefault(); if (check == null) { return(Json(new ResultInfo() { error = 1, msg = "Không tìm thấy thông tin" }, JsonRequestBehavior.AllowGet)); } if (namhoc.HienTai == true) { db.DM_NamHoc.Where(x => x.MaTruong == MaDonVi && x.NamHoc != namhoc.NamHoc).ToList().ForEach(x => { x.HienTai = false; }); // db.SaveChanges(); } check.NamHoc = namhoc.NamHoc; check.MaTruong = MaDonVi; namhoc.TuNgay = dateFrom; namhoc.DenNgay = dateTo; check.DenNgay = namhoc.DenNgay; check.HienTai = namhoc.HienTai; check.NienKhoa = namhoc.NamHoc; db.Entry(check).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = check }, JsonRequestBehavior.AllowGet)); }