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