public bool SchoolListGradesEdit([FromBody] SchoolGradesViewModel model)
{
try
{
SchoolGradeTotals schoolGradeTotals = _context.SchoolGradeTotals.Where(m => m.SchoolId == model.SchoolId && m.SchoolGradeId == model.SchoolGradeId && m.PeriodId == _IPeriods.PeriodId).FirstOrDefault();
schoolGradeTotals.NoOffClasses = model.NoOffClasses;
schoolGradeTotals.NoOffLearners = model.NoOffLearners;
schoolGradeTotals.NoOffParticipation = model.NoOffParticipation;
schoolGradeTotals.UserID = model.UserID;
if (schoolGradeTotals != null)
{
_context.SchoolGradeTotals.Attach(schoolGradeTotals);
_context.SaveChanges();
return(true);
}
else
{
schoolGradeTotals.SchoolId = model.SchoolId;
schoolGradeTotals.SchoolGradeId = model.SchoolGradeId;
schoolGradeTotals.PeriodId = _IPeriods.PeriodId;
_context.SchoolGradeTotals.Add(schoolGradeTotals);
_context.SaveChanges();
return(true);
}
}
catch (Exception ex) {
var error = ex.InnerException;
return(false);
}
}
public bool SchoolGradesDelete([FromBody] SchoolGradesViewModel model)
{
try
{
ScoolGrades scoolGrades = _context.ScoolGrades.Where(m => m.SchoolId == model.SchoolId && m.SchoolGradeId == model.SchoolGradeId && m.GradeCode == model.GradeCode).FirstOrDefault();
List <ScoolGradesList> scoolGradesList = _context.ScoolGradesList.Where(m => m.SchoolId == model.SchoolId && m.SchoolGradeId == model.SchoolGradeId).ToList();
SchoolGradeTotals schoolGradeTotals = _context.SchoolGradeTotals.Where(m => m.SchoolGradeId == model.SchoolGradeId && m.SchoolId == model.SchoolId && m.PeriodId == m.PeriodId).FirstOrDefault();
scoolGrades.UserID = model.UserID;
if (schoolGradeTotals != null)
{
schoolGradeTotals.UserID = model.UserID;
schoolGradeTotals.Active = false;
_context.SchoolGradeTotals.Update(schoolGradeTotals);
}
_context.SaveChanges();
if (scoolGradesList != null)
{
if (scoolGradesList.Count() > 0)
{
foreach (var item in scoolGradesList)
{
item.UserID = model.UserID;
item.Active = false;
_context.ScoolGradesList.Update(item);
}
}
}
_context.SaveChanges();
if (scoolGradesList != null)
{
scoolGrades.Active = false;
_context.ScoolGrades.Update(scoolGrades);
}
_context.SaveChanges();
return(true);
}
catch (Exception ex) {
var error = ex.InnerException;
return(false);
}
}
public IHttpActionResult GetSchoolGrades([FromBody] SchoolGradesViewModel vm)
{
var schoolGrades = _unitOfWork.SchoolGrades.GetSchoolGrades(vm.SubjectId, vm.SchoolClassId);
return(Ok(schoolGrades));
}
