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 bool SchoolListGradesAdd([FromBody] List <SchoolGradesViewModel> model) { try { foreach (var item in model) { ScoolGrades existingItem = _context.ScoolGrades.Where(m => m.SchoolId == item.SchoolId && m.GradeCode == item.GradeCode).FirstOrDefault(); if (existingItem != null) { existingItem.Active = true; _context.ScoolGrades.Attach(existingItem); _context.SaveChanges(); return(true); } existingItem = _context.ScoolGrades.Where(m => m.SchoolId == item.SchoolId && m.SchoolGradeId == item.SchoolGradeId && m.GradeCode == item.GradeCode).FirstOrDefault(); if (existingItem == null) { ScoolGrades db = new ScoolGrades(); db.SchoolId = item.SchoolId; db.GradeCode = item.GradeCode; db.UserID = item.UserID; db.Type007 = "007"; db.PeriodId = _IPeriods.PeriodId; db.Active = true; _context.ScoolGrades.Add(db); _context.SaveChanges(); SchoolGradeTotals schoolGradeTotals = _context.SchoolGradeTotals.Where(m => m.SchoolId == item.SchoolId && m.SchoolGradeId == db.SchoolGradeId && db.SchoolId == _IPeriods.PeriodId).FirstOrDefault(); if (schoolGradeTotals == null) { SchoolGradeTotals gradeTotals = new SchoolGradeTotals() { NoOffLearners = 0, NoOffClasses = 0, NoOffParticipation = 0, PeriodId = _IPeriods.PeriodId, SchoolGradeId = db.SchoolGradeId, SchoolId = item.SchoolId, UserID = item.UserID }; _context.SchoolGradeTotals.Add(gradeTotals); _context.SaveChanges(); } } } return(true); } catch (Exception ex) { var error = ex.InnerException; return(false); } }