// GET: Tool5Detail/Create public async Task <IActionResult> Create(int id, short q) { ViewBag.SchoolName = await _context.Schools.Where(a => a.SchoolID == id).Select(a => a.SName).FirstOrDefaultAsync(); Tool5Detail tool5Detail = new Tool5Detail(); tool5Detail.SchoolID = id; tool5Detail.Quarter = q; tool5Detail.ClassID = Convert.ToInt16(_context.Tool5Detail.Count(a => a.SchoolID == id && a.Quarter == q)); ViewBag.MaxClass = 5; switch (_context.Schools.Where(a => a.SchoolID == id).Select(a => a.SLevel).FirstOrDefault()) { case 2: ViewBag.MaxClass = 8; break; case 3: ViewBag.MaxClass = 10; break; default: ViewBag.MaxClass = 5; break; } ViewData["SchoolID"] = new SelectList(_context.Schools, "SchoolID", "SName"); ViewData["ClassID"] = new SelectList(_context.SchoolClasses, "ClassID", "ClassID"); return(View(tool5Detail)); }
public async Task <IActionResult> Edit(int id, [Bind("SchoolID,Quarter,ClassID,NewEnrolltGirls,NewEnrollBoys,AttendRegGirls,AttendRegBoys,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Tool5Detail tool5Detail) { if (id != tool5Detail.SchoolID) { return(NotFound()); } if (ModelState.IsValid) { try { tool5Detail.UpdatedBy = User.Identity.Name; tool5Detail.UpdatedDate = DateTime.Now; _context.Update(tool5Detail); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Tool5DetailExists(tool5Detail.SchoolID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Create", "Tool5Detail", new { id = tool5Detail.SchoolID, q = tool5Detail.Quarter })); } ViewData["SchoolID"] = new SelectList(_context.Schools, "SchoolID", "SName", tool5Detail.SchoolID); ViewData["ClassID"] = new SelectList(_context.SchoolClasses, "ClassID", "ClassID", tool5Detail.ClassID); return(View(tool5Detail)); }
public async Task <IActionResult> Create([Bind("SchoolID,Quarter,ClassID,NewEnrolltGirls,NewEnrollBoys,AttendRegGirls,AttendRegBoys,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] Tool5Detail tool5Detail) { if (ModelState.IsValid) { //tool5Detail.ClassID = Convert.ToInt16(_context.Tool5Detail.Count(a => a.SchoolID == tool5Detail.SchoolID && a.Quarter == tool5Detail.Quarter)); tool5Detail.CreatedBy = User.Identity.Name; tool5Detail.CreatedDate = DateTime.Now; _context.Add(tool5Detail); await _context.SaveChangesAsync(); return(RedirectToAction("Create", "Tool5Detail", new { id = tool5Detail.SchoolID, q = tool5Detail.Quarter })); } ViewData["SchoolID"] = new SelectList(_context.Schools, "SchoolID", "SName", tool5Detail.SchoolID); ViewData["ClassID"] = new SelectList(_context.SchoolClasses, "ClassID", "ClassID", tool5Detail.ClassID); return(View(tool5Detail)); }