public static string GetKinderGardenOfChild(int childID) { using (TafToTafEntities2 db = new TafToTafEntities2()) { var childKG = db.ChildKinderGardens.FirstOrDefault(ch => ch.ChildID == childID); if (childKG == null) { return(null); } string kGardenName = db.KinderGardens.First(ch => ch.Id == childKG.KindrGardenID).Name; return(kGardenName); } }
public static List <CalenderDto> SelectCalendarKinderGarden(int kinderGardenID) { int year = PublicLogic.CalcBeaginYear().Year; List <CalenderDto> calenderDtos = new List <CalenderDto>(); using (TafToTafEntities2 db = new TafToTafEntities2()) { var calenders = db.Calanders.Where(c => c.KindId < 4 && c.KinderGardenId == kinderGardenID && c.DateStart.Value.Year == year); foreach (var calander in calenders) { calenderDtos.Add(CalanderC.ToCalanderDto(calander)); } } return(calenderDtos); }
public static List <CalenderDto> SelectAdminParentMeetings() { int year = PublicLogic.CalcBeaginYear().Year; List <CalenderDto> parentsMeetings = new List <CalenderDto>(); using (TafToTafEntities2 db = new TafToTafEntities2()) { var meetings = db.Calanders.Where(c => c.KindId == 5 && DateTime.Now.Month - c.DateStart.Value.Month <= 2 && c.DateStart.Value.Year == year).ToList(); foreach (var calander in meetings) { parentsMeetings.Add(BLL.Converters.CalanderC.ToCalanderDto(calander)); } } return(parentsMeetings); }
public static List <ChildDto> GetChildrenInKinderGarden(string kinderGardenName) { List <ChildDto> ChildrenDTO = new List <ChildDto>(); using (TafToTafEntities2 db = new TafToTafEntities2()) { int kinderGardenId = db.KinderGardens.First(kg => kg.Name == kinderGardenName).Id; foreach (var childKinderGarden in db.ChildKinderGardens) { if (childKinderGarden.KindrGardenID == kinderGardenId && childKinderGarden.BeginYear.GetValueOrDefault() == PublicLogic.CalcBeaginYear()) { Child childDAL = db.Children.First(ch => ch.Id == childKinderGarden.ChildID); ChildrenDTO.Add(ChildC.ToChildDTO(childDAL)); } } return(ChildrenDTO); } }