public ActionResult create(DM_NhomDanhGia nhomdanhgia, List <string> chitiet, string truongnhom) { if (String.IsNullOrEmpty(nhomdanhgia.TenNhom)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } var check = db.DM_NhomDanhGia.Where(p => p.MaTruong == MaTruong && p.TenNhom == nhomdanhgia.TenNhom).FirstOrDefault(); if (check != null) { return(Json(new ResultInfo() { error = 1, msg = "Đã tồn tại" }, JsonRequestBehavior.AllowGet)); } //lay ra max manhom var maxid = db.DM_NhomDanhGia.OrderByDescending(x => x.MaNhom).Where(x => x.MaTruong == MaTruong).FirstOrDefault(); string maxndg = string.Empty; if (maxid != null) { maxndg = string.Format("NDG{0}", (Convert.ToUInt32(maxid.MaNhom.Substring(3)) + 1).ToString("D4")); } else { maxndg = "NDG0001"; } nhomdanhgia.MaNhom = maxndg; nhomdanhgia.MaTruong = MaTruong; db.DM_NhomDanhGia.Add(nhomdanhgia); //add chi tiet foreach (var item in chitiet) { DM_NhomDanhGiaChiTiet ndgct = new DM_NhomDanhGiaChiTiet(); bool istruongnhom = false; if (truongnhom == item) { istruongnhom = true; } ndgct.MaTruong = MaTruong; ndgct.MaNhanVien = item; ndgct.MaNhom = maxndg; ndgct.TruongNhom = istruongnhom; db.DM_NhomDanhGiaChiTiet.Add(ndgct); } db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = nhomdanhgia }, JsonRequestBehavior.AllowGet)); }
public ActionResult edit(DM_NhomDanhGia nhomdanhgia, List <string> chitiet, string truongnhom) { if (String.IsNullOrEmpty(nhomdanhgia.MaNhom)) { return(Json(new ResultInfo() { error = 1, msg = "Missing info" }, JsonRequestBehavior.AllowGet)); } var check = db.DM_NhomDanhGia.Where(p => p.MaTruong == MaTruong && p.MaNhom == nhomdanhgia.MaNhom).FirstOrDefault(); if (check == null) { return(Json(new ResultInfo() { error = 1, msg = "Không tìm thấy thông tin" }, JsonRequestBehavior.AllowGet)); } check.MaTruong = MaTruong; db.Entry(check).State = System.Data.Entity.EntityState.Modified; //xoa tat ca chi tiet db.DM_NhomDanhGiaChiTiet.RemoveRange(db.DM_NhomDanhGiaChiTiet.Where(p => p.MaNhom == nhomdanhgia.MaNhom && p.MaTruong == MaTruong)); //add chi tiet foreach (var item in chitiet) { DM_NhomDanhGiaChiTiet ndgct = new DM_NhomDanhGiaChiTiet(); bool istruongnhom = false; // var checkct = db.DM_NhomDanhGiaChiTiet.Where(p => p.MaTruong == MaTruong && p.MaNhom == nhomdanhgia.MaNhom && p.MaNhanVien == item).FirstOrDefault(); if (truongnhom == item) { istruongnhom = true; } // add chi tiet ndgct.MaTruong = MaTruong; ndgct.MaNhanVien = item; ndgct.MaNhom = nhomdanhgia.MaNhom; ndgct.TruongNhom = istruongnhom; db.DM_NhomDanhGiaChiTiet.Add(ndgct); } db.SaveChanges(); return(Json(new ResultInfo() { error = 0, msg = "", data = nhomdanhgia }, JsonRequestBehavior.AllowGet)); }