public static AGE_DTO getRange(int age) { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { AGE_TBL ages = ctx.AGE_TBL.Where(p => p.begins <= age && p.ends <= age).FirstOrDefault(); if (ages != null) { return(AGE_Casting.CastToDTO(ages)); } return(null); } }
public static List <AGE_DTO> GetAllAgeRange() { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { var AgeRangeList = AgeCRUD.GetAllAgeRange(ctx); List <AGE_DTO> ages = new List <AGE_DTO>(); foreach (var age in AgeRangeList) { ages.Add(AGE_Casting.CastToDTO(age)); } return(ages); } }