// 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));
}
