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