public static void DeleteChild(int id)
{
try
{
using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2())
{
var child = db.Children.FirstOrDefault(ch => ch.Id == id);
if (child != null)
{
db.Children.Remove(child);
}
var childInKGarden = db.ChildKinderGardens.First(ch => ch.ChildID == id);
db.ChildKinderGardens.Remove(childInKGarden);
var parent = db.Users.FirstOrDefault(u => u.Password == child.Tz);
if (parent != null)
{
db.Users.Remove(parent);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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);
}
}
public static void EditChild(int id, ChildDto child)
{
using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2())
{
var editChild = db.Children.FirstOrDefault(ch => ch.Id == id);
if (editChild != null)
{
editChild.FirstName = child.FirstName;
editChild.LastName = child.LastName;
editChild.Tz = child.Tz;
editChild.BornDate = child.BornDate;
editChild.NumHoursConfirm = child.NumHoursConfirm;
editChild.ParentID = child.ParentID;
}
db.SaveChanges();
}
}