public void InsertDirectorTest() { using (var db = new CSBCDbContext()) { var repHouse = new HouseholdRepository(db); var house = repHouse.Insert(new Household {CompanyID=2, Name="Frost"}); var repPeople = new PersonRepository(db); var person = repPeople.Insert(new Person { FirstName = "Jack", LastName = "Frost", HouseID = house.HouseID }); var rep = new DirectorRepository(db); var director = new Director{ PeopleID = person.PeopleID, CompanyID = 2, Title = "President" }; var records = rep.Insert(director); Assert.IsTrue(records.PeopleID != 0); Assert.IsTrue(records.Title != String.Empty); //rep.Delete } }
private void AddRecord() { using (var db = new CSBCDbContext()) { try { var director = new Director(); director.PeopleID = Int32.Parse(cboBM.SelectedItem.Value); director.Title = txtTitle.Text; if (cobPhones.Items[0].Selected == true) director.PhonePref = "None"; if (cobPhones.Items[1].Selected == true) director.PhonePref = "HOME"; if (cobPhones.Items[2].Selected == true) director.PhonePref = "CELL"; if (cobPhones.Items[3].Selected == true) director.PhonePref = "WORK"; director.CompanyID = Master.CompanyId; director.EmailPref = (chkEmail.Checked ? 1: 0); director.Seq = Convert.ToInt32(txtSequence.Text); director.CreatedUser = Master.UserName; var rep = new DirectorRepository(db); rep.Insert(director); } catch (Exception ex) { lblError.Text = "ADDRow::" + ex.Message; } } }