public IEnumerable <ContactRequestItem> GetContacts(string userId)
{
List <ContactRequestItem> listings = new List <ContactRequestItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ListingsSelectContacts", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", userId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
ContactRequestItem row = new ContactRequestItem();
row.ListingId = (int)dr["ListingId"];
row.UserId = dr["UserId"].ToString();
row.StateId = dr["StateId"].ToString();
row.City = dr["City"].ToString();
row.Rate = (decimal)dr["Rate"];
row.Email = dr["Email"].ToString();
row.Nickname = dr["Nickname"].ToString();
listings.Add(row);
}
}
}
return(listings);
}
private ContactRequestItem PopulateContactRequestItemFromDataReader(SqlDataReader dr)
{
var contactRequestItem = new ContactRequestItem();
contactRequestItem.ListingId = (int)dr["ListingId"];
contactRequestItem.Email = dr["Email"].ToString();
contactRequestItem.UserId = dr["UserId"].ToString();
contactRequestItem.Nickname = dr["Nickname"].ToString();
contactRequestItem.City = dr["City"].ToString();
contactRequestItem.StateId = dr["StateId"].ToString();
contactRequestItem.Rate = (decimal)dr["Rate"];
return(contactRequestItem);
}
