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