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);
}
}
public static void InsertChild(DTO.ChildPost child, string kGardenName)
{
using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2())
{
int kGardenID = db.KinderGardens.First(kg => kg.Name == kGardenName).Id;
User user = new User()
{
LastName = child.LastName,
FirstName = child.ParentName,
KindUser = 3,
UserName = "******" + "3",
Email = child.ParentEmail,
Password = child.Tz,
};
db.Users.Add(user);
db.SaveChanges();
ChildDto childDto = new ChildDto()
{
FirstName = child.FirstName,
LastName = child.LastName,
BornDate = child.BornDate,
NumHoursConfirm = child.NumHoursConfirm,
Tz = child.Tz,
ParentID = db.Users.First(u => u.Password == child.Tz).Id
};
db.Children.Add(ChildC.ToChildDAL(childDto));
db.ChildKinderGardens.Add(new ChildKinderGarden()
{
ChildID = child.Id,
KindrGardenID = kGardenID,
BeginYear = PublicLogic.CalcBeaginYear(),
EndYear = PublicLogic.CalcEndYear(),
});
db.SaveChanges();
PublicLogic.SendEmail("TLT3", child.Tz, child.ParentEmail);
}
}