// GET: ContinuousAssessments/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContinuousAssessment continuousAssessment = await Db.ContinuousAssessments.FindAsync(id);
if (continuousAssessment == null)
{
return(HttpNotFound());
}
ViewBag.StudentId = new SelectList(await _query.StudentListAsync(userSchool), "StudentID", "FullName");
ViewBag.SessionName = new SelectList(_query.SessionList(), "SessionName", "SessionName");
ViewBag.ClassName = new SelectList(Db.Classes.AsNoTracking(), "FullClassName", "FullClassName");
ViewBag.TermName = new SelectList(_query.TermList(), "TermName", "TermName");
ViewBag.SubjectId = new SelectList(await _query.SubjectListAsync(userSchool), "SubjectId", "SubjectName");
ViewBag.StaffName = User.Identity.GetUserName();
var model = new ContinuousAssesmentViewModel()
{
ContinuousAssessmentId = continuousAssessment.ContinuousAssessmentId,
StudentId = continuousAssessment.StudentId,
FirstTest = continuousAssessment.FirstTest,
SecondTest = continuousAssessment.SecondTest,
ThirdTest = continuousAssessment.ThirdTest,
ExamScore = continuousAssessment.ExamScore
};
return(View(model));
}
public async Task <ActionResult> Edit(ContinuousAssesmentViewModel model)
{
if (ModelState.IsValid)
{
var myContinuousAssessment = new ContinuousAssessment()
{
ContinuousAssessmentId = model.ContinuousAssessmentId,
StudentId = model.StudentId,
SubjectId = model.SubjectId,
FirstTest = model.FirstTest,
SecondTest = model.SecondTest,
ThirdTest = model.ThirdTest,
ExamScore = model.ExamScore,
TermName = model.TermName.ToString(),
SessionName = model.SessionName,
ClassName = model.ClassName,
StaffName = model.StaffName,
SchoolId = userSchool
//SubjectCategory = mysubjectCategory
};
// Db.ContinuousAssessments.Add(myContinuousAssessment);
Db.Entry(myContinuousAssessment).State = EntityState.Modified;
await Db.SaveChangesAsync();
TempData["UserMessage"] = "Continuous Assessment Updated Successfully.";
TempData["Title"] = "Success.";
return(RedirectToAction("Index"));
}
ViewBag.StudentId = new SelectList(await _query.StudentListAsync(userSchool), "StudentID", "FullName");
ViewBag.SessionName = new SelectList(_query.SessionList(), "SessionName", "SessionName");
ViewBag.ClassName = new SelectList(Db.Classes.AsNoTracking(), "FullClassName", "FullClassName");
ViewBag.TermName = new SelectList(_query.TermList(), "TermName", "TermName");
ViewBag.SubjectId = new SelectList(await _query.SubjectListAsync(userSchool), "SubjectId", "SubjectName");
ViewBag.StaffName = User.Identity.GetUserName();
return(View(model));
}
public async Task <ActionResult> Create(ContinuousAssesmentViewModel model)
{
if (ModelState.IsValid)
{
//var mysubjectCategory = Db.Subjects.Where(x => x.CourseCode.Equals(model.SubjectCode))
// .Select(c => c.CategoriesId).FirstOrDefault();
//var subjectName = Db.Subjects.Where(x => x.CourseCode.Equals(model.SubjectCode))
// .Select(c => c.CourseName).FirstOrDefault();
//var student = Db.AssignedClasses.Where(x => x.ClassName.Equals(model.ClassName)
// && x.TermName.Contains(model.TermName.ToString())
// && x.SessionName.Equals(model.SessionName));
var CA = Db.ContinuousAssessments.AsNoTracking().Where(x => x.ClassName.Equals(model.ClassName) &&
x.TermName.Contains(model.TermName.ToString()) &&
x.SessionName.Equals(model.SessionName) &&
x.StudentId.Equals(model.StudentId) &&
x.SubjectId.Equals(model.SubjectId));
var countFromDb = await CA.CountAsync();
if (countFromDb >= 1)
{
ViewBag.StudentId = new SelectList(await _query.StudentListAsync(userSchool), "StudentID", "FullName");
ViewBag.SessionName = new SelectList(_query.SessionList(), "SessionName", "SessionName");
ViewBag.ClassName = new SelectList(Db.Classes.AsNoTracking(), "FullClassName", "FullClassName");
ViewBag.TermName = new SelectList(_query.TermList(), "TermName", "TermName");
ViewBag.SubjectId = new SelectList(await _query.SubjectListAsync(userSchool), "SubjectId", "SubjectName");
TempData["UserMessage"] = "Record Already Exist in Database.";
TempData["Title"] = "Error.";
return(View(model));
}
else
{
var myContinuousAssessment = new ContinuousAssessment()
{
StudentId = model.StudentId,
SubjectId = model.SubjectId,
FirstTest = model.FirstTest,
SecondTest = model.SecondTest,
ThirdTest = model.ThirdTest,
ExamScore = model.ExamScore,
TermName = model.TermName,
SessionName = model.SessionName,
ClassName = model.ClassName,
StaffName = model.StaffName,
SchoolId = userSchool
//SubjectCategory = mysubjectCategory
};
Db.ContinuousAssessments.Add(myContinuousAssessment);
}
await Db.SaveChangesAsync();
TempData["UserMessage"] = "Continuous Assessment Added Successfully.";
TempData["Title"] = "Success.";
return(RedirectToAction("Index"));
}
ViewBag.StudentId = new SelectList(await _query.StudentListAsync(userSchool), "StudentID", "FullName");
ViewBag.SessionName = new SelectList(_query.SessionList(), "SessionName", "SessionName");
ViewBag.ClassName = new SelectList(Db.Classes.AsNoTracking(), "FullClassName", "FullClassName");
ViewBag.TermName = new SelectList(_query.TermList(), "TermName", "TermName");
ViewBag.SubjectId = new SelectList(await _query.SubjectListAsync(userSchool), "SubjectId", "SubjectName");
ViewBag.StaffName = User.Identity.GetUserName();
return(View(model));
}
