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