public void SaveChildInfo()
{
using (var context = new CCAppEntities())
{
// verify data
if (VerifyChildInfo())
{
// open DB
context.Database.Connection.Open();
// CRUD
context.Child.Add(new Child
{
ChildFirstName = this.ChildFirstName,
ChildMiddleName = this.ChildMiddleName,
ChildLastName = this.ChildLastName,
ChildBirthDate = this.ChildBirthDate,
ChildIsActive = this.ChildIsActive,
ChildAddress = this.ChildAddress,
ChildCity = this.ChildCity,
ChildState = this.ChildState,
ChildGender = this.ChildGender,
ChildZip = this.ChildZip,
ChildPhone = this.ChildPhone
});
// save child to db
context.SaveChanges();
ClearChildInfo();
}
}
}
public string GetCompanyOwner()
{
var company = new Company();
using (var context = new CCAppEntities())
{
// open database
context.Database.Connection.Open();
company = context.Company.FirstOrDefault <Company>();
}
return(company.CompanyOwner);
}
public void LoadChildDemographics()
{
//get selected child from DB
using (var context = new CCAppEntities())
{
var selectedChild = from c in context.Child
where c.ChildFirstName == ChildFirstName.TrimEnd()
select c;
//display child Info
Child child = new Child();
child = (Child)selectedChild;
ChildFirstName = child.ChildFirstName;
}
}
public void SaveChildInfo()
{
SetCurentChild();
using (var context = new CCAppEntities())
{
context.Database.Connection.Open();
if (SelectedChildInfo != null)
{
var childToSave = context.Child.Find(SelectedChildInfo.Id);
SetChildProperties(childToSave);
int saveCode = context.SaveChanges();
}
}
}
public void SaveCompanyInfo()
{
//open database and get company object
var company = new Company();
using (var context = new CCAppEntities())
{
context.Database.Connection.Open();
company = context.Company.FirstOrDefault <Company>();
company.CompanyAddress = CompanyAddress;
company.CompanyEmail = CompanyEmail;
company.CompanyName = CompanyName;
company.CompanyOwner = CompanyOwner;
company.CompanyPhone = CompanyPhone;
int saveCode = context.SaveChanges();
}
}
public string GetCompanyName()
{
var company = new Company();
using (var context = new CCAppEntities())
{
// open database
try
{
context.Database.Connection.Open();
}
catch (System.Exception)
{
throw;
}
company = context.Company.FirstOrDefault <Company>();
}
return(company.CompanyName);
}
private List <Child> LoadChildrenFromDB()
{
// open database
List <Child> childrenList = new List <Child>();
using (var context = new CCAppEntities())
{
if (context.Child.Count() != 0)
{
var children = context.Child.ToList <Child>();
foreach (var c in children)
{
childrenList.Add(c);
}
}
}
return(childrenList);
}
