private void GetData() { var rep = new HouseholdRepository(new CSBCDbContext()); try { var rsData = rep.GetRecords( Master.CompanyId, Session["Name"].ToString(), Session["Address"].ToString(), Session["Phone"].ToString(), Session["Email"].ToString()).ToList(); //grdHouseholds.Clear() if (rsData.Any()) { var _with1 = grdHouseholds; _with1.DataSource = rsData; _with1.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message; } finally { rep = null; } }
public void FindHouseholdByName() { var rep = new HouseholdRepository(new CSBCDbContext()); var houses = rep.GetByName(HouseholdName1); Assert.IsTrue(houses.Count<Household>() > 0); var house = houses.First<Household>(); Assert.IsTrue(house.Name == HouseholdName1); }
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 GetUserByHouseholdIDTest() { using (var db = new CSBCDbContext()) { var tester = new TestUtils(db); var house = new HouseholdRepository(db).GetByName(tester.HouseholdLastNames[1]).First<Household>(); var rep = new UserRepository(db); var user = rep.GetUserByHouseId(house.HouseID); Assert.IsTrue(user != null); } }
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 InsertPersonTest() { var context = new Core.Data.CSBCDbContext(); var repHouse = new HouseholdRepository(context); var houses = repHouse.GetByName(TestUtils.Household1); var house = houses.FirstOrDefault(); var rep = new PersonRepository(context); int no= rep.Insert(new Person { CompanyID = TestUtils.CompanyId, FirstName = "Sam", LastName = "Fred", HouseID = house.HouseID }) .PeopleID; Assert.IsTrue(no > 0); }
public void GetHouseholdSearchRecordsTest() { var house = new Household(); using (var db = new CSBCDbContext()) { var rep = new HouseholdRepository(db); var homes = rep.GetRecords(1, name: "Fa").ToList(); Assert.IsTrue(homes.Any()); homes = rep.GetRecords(1, address: "Main").ToList(); Assert.IsTrue(homes.Any()); homes = rep.GetRecords(1, name: "Fa", phone: "954").ToList(); Assert.IsTrue(homes.Any()); homes = rep.GetRecords(1, name: "Fa", address: "123", email: "yahoo.com").ToList(); Assert.IsTrue(homes.Any()); } }
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 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 LoadEmails(Int32 iGroupType) { var rep = new HouseholdRepository(new CSBCDbContext()); try { var rsData = rep.LoadEmails(iGroupType, Master.CompanyId, Master.SeasonId); lstEmails.Items.Clear(); if (rsData.Rows.Count > 0) { lstEmails.DataValueField = "Email"; lstEmails.DataTextField = "Name"; lstEmails.DataSource = rsData; lstEmails.DataBind(); } } catch (Exception ex) { lblError.Text = "LoadEmails::" + ex.Message; } finally { } }
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 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; } } }
private static Household GetHouseHoldObject(int rowId) { var rep = new HouseholdRepository(new CSBCDbContext()); var household = rep.GetById(rowId); return household; }