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