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