private List <Senator> getSenRecords(string query)
{
List <Senator> senList = new List <Senator>();
//formulate connection string, sql query, data adapter/table
//SqlConnection conn = new SqlConnection(@"Data Source=localhost\CGBPCD; Database=Assignment2; Integrated Security=True");
SqlConnection conn = new SqlConnection("Data Source=CGBPCD;Initial Catalog=Assignment2;Integrated Security=True");
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
//iterate through each record to create list of reps within passed in zipcode
foreach (DataRow dr in dt.Rows)
{
//create our new rep object, and push into list
Senator sen = new Senator();
//Set sen properties
sen.ShortInfo = ""; //Do not have this data
sen.LastName = dr["person__lastname"].ToString();
sen.FirstName = dr["person__firstname"].ToString();
sen.Party = dr["party"].ToString();
sen.StateAbrev = dr["state"].ToString();
sen.FullAddress = ""; //Do not have this data
sen.Phone = dr["phone"].ToString();
sen.Email = ""; //Do not have this data
sen.Website = ""; //Do not have this data
sen.Class = dr["senator_rank"].ToString(); //Do not have this data
sen.bioguide_id = dr["person__bioguideid"].ToString();
sen.LeadershipPosition = dr["leadership_title"].ToString();
senList.Add(sen);
}
return(senList);
}
private List<Senator> getSenRecords(string query)
{
List<Senator> senList = new List<Senator>();
//formulate connection string, sql query, data adapter/table
//SqlConnection conn = new SqlConnection(@"Data Source=localhost\CGBPCD; Database=Assignment2; Integrated Security=True");
SqlConnection conn = new SqlConnection("Data Source=CGBPCD;Initial Catalog=Assignment2;Integrated Security=True");
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
//iterate through each record to create list of reps within passed in zipcode
foreach (DataRow dr in dt.Rows)
{
//create our new rep object, and push into list
Senator sen = new Senator();
//Set sen properties
sen.ShortInfo = ""; //Do not have this data
sen.LastName = dr["person__lastname"].ToString();
sen.FirstName = dr["person__firstname"].ToString();
sen.Party = dr["party"].ToString();
sen.StateAbrev = dr["state"].ToString();
sen.FullAddress = ""; //Do not have this data
sen.Phone = dr["phone"].ToString();
sen.Email = ""; //Do not have this data
sen.Website = ""; //Do not have this data
sen.Class = dr["senator_rank"].ToString(); //Do not have this data
sen.bioguide_id = dr["person__bioguideid"].ToString();
sen.LeadershipPosition = dr["leadership_title"].ToString();
senList.Add(sen);
}
return senList;
}
