public static void SaveCity(dtoCity city)
{
DAL.City NewCity = dtoCity.castToDal(city);
//School ExistSchool = Entities.context.Schools.FirstOrDefault(p => p.SchoolId == NewSchool.SchoolId);
//if (ExistSchool != null)
//{
// Entities.context.Schools.Remove(ExistSchool);
//}
context.Cities.Add(NewCity);
context.SaveChanges();
}
public static void SavePayment(dtoPayment payment)
{
DAL.Payment NewPayment = dtoPayment.castToDal(payment);
DAL.Payment ExistPayment = context.Payments.FirstOrDefault(p => p.PaymentId == payment.PaymentId);
if (ExistPayment != null)
{
context.Payments.Remove(ExistPayment);
context.SaveChanges();
}
context.Payments.Add(NewPayment);
context.SaveChanges();
}
//public static void SaveSubject(dtoSubject subject)
//{
// Subject NewSubject = dtoSubject.castToDal(subject);
// Subject ExistSubject = Entities.context.Subjects.FirstOrDefault(p => p.SubjectId == NewSubject.SubjectId);
// if (ExistSubject != null)
// {
// Entities.context.Subjects.Remove(ExistSubject);
// }
// Entities.context.Subjects.Add(ExistSubject);
//}
public static void SaveSubject(dtoSubject subject)
{
Subject NewSubject = dtoSubject.castToDal(subject);
//School ExistSchool = Entities.context.Schools.FirstOrDefault(p => p.SchoolId == NewSchool.SchoolId);
//if (ExistSchool != null)
//{
// Entities.context.Schools.Remove(ExistSchool);
//}
context.Subjects.Add(NewSubject);
context.SaveChanges();
}
public static void SaveFamily(dtoFamily family)
{
DAL.Family NewFamily = DTO.dtoFamily.castToDal(family);
DAL.Family ExistFamily = context.Families.FirstOrDefault(p => p.FamilyId == NewFamily.FamilyId);
if (ExistFamily != null)
{
context.Families.Remove(ExistFamily);
context.SaveChanges();
}
context.Families.Add(NewFamily);
context.SaveChanges();
}
//public static void CreateWaitingForChild(dtoChildRegistrationToSubject waiting)
//{
// Entities.context.ChildsRegistrationToSubjects.Add(dtoChildRegistrationToSubject.castToDal(waiting));
//}
public static void AddWaitingChild(dtoChildRegistrationToSubject child)
{
ChildsRegistrationToSubject Newchild = dtoChildRegistrationToSubject.castToDal(child);
context.ChildsRegistrationToSubjects.Add(Newchild);
context.SaveChanges();
}
public static void UpdateGroup(dtoGroup Group)
{
Group NewGroup = dtoGroup.castToDal(Group);
Group ExistGroup = context.Groups.FirstOrDefault(p => p.code == NewGroup.code);
if (ExistGroup != null)
{
ExistGroup.code = Group.code;
ExistGroup.GroupName = Group.GroupName;
ExistGroup.grade1 = Group.grade1;
ExistGroup.grade2 = Group.grade2;
ExistGroup.SchoolId = Group.SchoolId;
context.SaveChanges();
}
}
public static void AddChildrenWithDetails(ChildWithFamilyDetails child)
{
//Child Newchild = dtoChild.castToDal(child);
Child ExistChild = context.Childs.FirstOrDefault(p => p.IdentityNum == child.IdentityNum);
if (ExistChild != null)
{
context.Childs.Remove(ExistChild);
context.SaveChanges();
}
Child child1 = new Child(child.IdentityNum, child.FamilyId, child.FirstName, child.Kind, child.BirthDate, child.PlaceInFamily,
child.SchoolId, child.Grade, child.JoiningDate, child.ViturSodiutFrom, child.PreviousCare, child.Note, child.IsActive,
child.IsMunicipality, child.sumAfterDiscount);
context.SaveChanges();
context.Childs.Add(child1);
context.SaveChanges();
}