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 } }
public void DeleteHouseholdRecord() { var house = new Household { Name = HouseholdName1, CompanyID = 1, Address1 = "10 Minute Lane", City = "Plainview", State = "NY", Email = "*****@*****.**", Phone = "516-222-2222" }; using (var db = new CSBCDbContext()) { var rep = new HouseholdRepository(db); var no = rep.Insert(house); Assert.IsTrue(no != null); var household = rep.GetById(no.HouseID); Assert.IsTrue(household != null ); rep.Delete(household); household = rep.GetById(no.HouseID); Assert.IsTrue(household == null); } }
public void InsertHouseholdRecord() { var house = new Household { Name = HouseholdName1, Address1 = "10 Minute Lane", City = "Plainview", State = "NY", Email = "*****@*****.**", Phone = "516-222-2222" }; var rep = new HouseholdRepository(new CSBCDbContext()); int no = 0; no = rep.Insert(house).HouseID; Assert.IsTrue(no > 0); }
private void ADDRow() { using (var db = new CSBCDbContext()) { try { var rep = new HouseholdRepository(db); var household = new Household(); household.Name = txtName.Text; household.Address1 = txtAddress.Text; household.Address2 = txtAddress2.Text; household.City = txtCity.Text; household.Email = txtEmail.Text; household.EmailList = chkEmail.Checked; household.SportsCard = txtCityCard.Text; household.State = txtState.Text; household.Zip = txtZip.Text; household.Phone = txtPhone.Text; household.CreatedUser = Master.UserName; household.CompanyID = Master.CompanyId; Master.HouseId = rep.Insert(household).HouseID; } catch (Exception ex) { Session["ErrorMSG"] = ex.Message; } } }