public void DeactivateAgeGroup(AgeGroupDTO deactivatedAgeGroup) { using (var context = new MSSContext()) { var ageGroup = context.agegroups.Find(deactivatedAgeGroup.agegroupid); ageGroup.activeyn = false; var existingAgeGroup = context.Entry(ageGroup); existingAgeGroup.State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateAgeGroup(AgeGroupDTO updatedAgeGroup) { using (var context = new MSSContext()) { var ageGroup = context.agegroups.Find(updatedAgeGroup.agegroupid); ageGroup.agegroupname = updatedAgeGroup.agegroupname; var existingAgeGroup = context.Entry(ageGroup); existingAgeGroup.State = EntityState.Modified; context.SaveChanges(); } }
public void AddAgeGroup(AgeGroupDTO tempAgeGroup) { using (var context = new MSSContext()) { agegroup newAgeGroup = new agegroup(); newAgeGroup.agegroupid = tempAgeGroup.agegroupid; newAgeGroup.agegroupname = tempAgeGroup.agegroupname; newAgeGroup.activeyn = true; context.agegroups.Add(newAgeGroup); context.SaveChanges(); } }
public List <AgeGroupDTO> GetAllAges() { using (var context = new MSSContext()) { var ageList = context.agegroups.ToList(); List <AgeGroupDTO> ages = new List <AgeGroupDTO>(); foreach (var age in ageList) { AgeGroupDTO temp = new AgeGroupDTO(); temp.agegroupid = age.agegroupid; temp.agegroupname = age.agegroupname; ages.Add(temp); } return(ages); } }
public List <AgeGroupDTO> GetActiveAges() { using (var context = new MSSContext()) { var ageList = from age in context.agegroups where age.activeyn == true select age; List <AgeGroupDTO> ages = new List <AgeGroupDTO>(); foreach (var age in ageList) { AgeGroupDTO temp = new AgeGroupDTO(); temp.agegroupid = age.agegroupid; temp.agegroupname = age.agegroupname; ages.Add(temp); } return(ages); } }