public ActionResult Edit(List <Contact> passContact) { List <Contact> list = (List <Contact>)TempData["list"]; TempData["list"] = list; var userid = User.Identity.GetUserId(); var teacher = _dbContext.Teachers.Where(a => a.ApplicationUser.Id == userid).SingleOrDefault(); var year = list[0].YearId; var column = new SetColumnContact(); if (teacher == null) { column.mark_5m = 5; column.mark_45m = 4; column.mark_15m = 5; } else { column = _dbContext.SetColumnContact.Where(a => a.TeacherId == teacher.Id && a.YearId == year).SingleOrDefault(); } var model = new ContactViewModel { Contact = list, SetColumnContact = column }; return(View(model)); }
public IHttpActionResult Index([FromBody] SetColumnContact value) { var userid = User.Identity.GetUserId(); var teacher = _dbContext.Teachers.Where(a => a.ApplicationUser.Id == value.TeacherId).SingleOrDefault(); if (teacher == null) { return(Ok()); } var res = _dbContext.SetColumnContact.Where(a => a.TeacherId == teacher.Id && a.YearId == value.YearId).SingleOrDefault(); return(Ok(res)); }
public ActionResult Index(SetColumnContact setColumnContact) { var userId = User.Identity.GetUserId(); var idteacher = _dbContext.Teachers.Where(a => a.ApplicationUser.Id == userId).Single(); var checknull = _dbContext.SetColumnContact.Any(a => a.TeacherId == idteacher.Id && a.YearId == setColumnContact.YearId); var year = _dbContext.Years.Where(a => a.Id == setColumnContact.YearId).Single(); var setColumnContacts = new SetColumnContact { mark_5m = setColumnContact.mark_5m, mark_15m = setColumnContact.mark_15m, mark_45m = setColumnContact.mark_45m, YearId = setColumnContact.YearId, Year = year, Teacher = idteacher, TeacherId = idteacher.Id }; var model = new SetColumnContactViewModel { Year = _dbContext.Years.ToList(), mark_5m = setColumnContact.mark_5m, mark_15m = setColumnContact.mark_15m, mark_45m = setColumnContact.mark_45m, applicationUser = userId, }; if (!checknull) { _dbContext.SetColumnContact.Add(setColumnContacts); _dbContext.SaveChanges(); TempData["msg"] = "<script>alert('Đã lưu cột điểm');</script>"; return(View(model)); } TempData["msg"] = "<script>alert('Đã thay đổi cột điểm');</script>"; //3. Mark entity as modified _dbContext.Entry(setColumnContacts).State = System.Data.Entity.EntityState.Modified; //4. call SaveChanges _dbContext.SaveChanges(); return(View(model)); }