public void FindHouseholdById() { var house = new Household(); var rep = new HouseholdRepository(new CSBCDbContext()); var houses = rep.GetByName(HouseholdName1); Assert.IsTrue(houses.Count<Household>() > 0); house = rep.GetById(houses.FirstOrDefault().HouseID); Assert.IsTrue(house != null); Assert.IsTrue(house.Name == HouseholdName1); }
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); } }
//private List<> private void LoadRow(int id) { using (var db = new CSBCDbContext()) { var rep = new UserRepository(db); try { var user = rep.GetById(id); if ((user != null)) { lblId.Value = user.UserID.ToString(); txtName.Text = user.Name; txtUserName.Text = user.UserName; Master.HouseId = (int)user.HouseID; txtPWord.Text = user.PWord.ToString(); radioUserType.SelectedValue = user.UserType.ToString(); //change this to radio if (user.HouseID != 0) { var repHouse = new HouseholdRepository(db); var house = repHouse.GetById(user.HouseID); lblHouseHold.Text = house.Name; lblEmail.Text = house.Email; lblHouseID.Text = user.HouseID.ToString(); } } } catch (Exception ex) { lblError.Text = "LoadRow::" + ex.Message; } } }
private void ReadHouse() { var rep = new HouseholdRepository(new CSBCDbContext()); try { var house = rep.GetById(Master.HouseId); if ((house != null)) { lnkHouseName.Text = house.Name; lblAddress.Text = " " + house.Address1; lblCSZ.Text = house.City + " " + house.State + " " + house.Zip; lblPhone.Text = house.Phone; lblEmail.Text = house.Email; var repPeople = new PersonRepository(new CSBCDbContext()); var people = repPeople.GetByHousehold(Master.HouseId); if (people.Any<Person>()) LoadMembers(people.ToList<Person>()); } Session.Add("LinkName", txtFirstName.Text + ", " + txtLastName.Text); } catch (Exception ex) { lblError.Text = "ReadHouse::" + ex.Message; } finally { Session.Add("LinkName", txtLastName.Text); } //LoadMembers(Master.HouseId); }
private void UpdRow(int rowId) { var householdRepository = new HouseholdRepository(new CSBCDbContext()); var household = householdRepository.GetById(rowId); try { 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; householdRepository.Update(household); } catch (Exception ex) { Session["ErrorMSG"] = "UpdRow::" + ex.Message; } }
private static Household GetHouseHoldObject(int rowId) { var rep = new HouseholdRepository(new CSBCDbContext()); var household = rep.GetById(rowId); return household; }