public IList <IViewArtistContact> Find <IViewArtistContactQueryParams>(IViewArtistContactQueryParams query) { _collection = new List <IViewArtistContact>(); string sqlCommand = "viewArtistContactFind"; // Create a suitable command type and add the required parameter. using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { _dataBase.AddInParameter(dbCmd, "@fromParam", DbType.String, ((IDataQuery)query).From); _dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, ((IDataQuery)query).Where); _dataBase.AddInParameter(dbCmd, "@orderByParam", DbType.String, ((IDataQuery)query).OrderBy); // Call the ExecuteReader method with the command. using (IDataReader reader = _dataBase.ExecuteReader(dbCmd)) { while (reader.Read()) { IViewArtistContact viewArtistContact = new ViewArtistContact(); viewArtistContact.Name = reader["name"].ToString(); viewArtistContact.Description = reader["description"].ToString(); viewArtistContact.Picture = reader["picture"].ToString(); viewArtistContact.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewArtistContact.IdArtistContact = Convert.ToInt32(reader["idArtistContact"].ToString()); viewArtistContact.Bandcamp = reader["bandcamp"].ToString(); viewArtistContact.Soundcloud = reader["soundcloud"].ToString(); viewArtistContact.Website = reader["website"].ToString(); viewArtistContact.Tumblr = reader["tumblr"].ToString(); viewArtistContact.Facebook = reader["facebook"].ToString(); viewArtistContact.Twitter = reader["twitter"].ToString(); viewArtistContact.Email = reader["email"].ToString(); _collection.Add(viewArtistContact); } } } return(_collection); }
public IViewArtistContact GetById(int id) { IViewArtistContact viewArtistContact = new ViewArtistContact(); string sqlCommand = "viewArtistContactFind"; using (DbCommand dbCmd = _dataBase.GetStoredProcCommand(sqlCommand)) { IDataQuery query = new DataQuery(); query.Where = string.Format(" artistId={0} ", id); _dataBase.AddInParameter(dbCmd, "@fromParam", DbType.String, query.From); _dataBase.AddInParameter(dbCmd, "@whereParam", DbType.String, query.Where); _dataBase.AddInParameter(dbCmd, "@orderByParam", DbType.String, query.OrderBy); using (IDataReader reader = _dataBase.ExecuteReader(dbCmd)) { while (reader.Read()) { viewArtistContact.Name = reader["name"].ToString(); viewArtistContact.Description = reader["description"].ToString(); viewArtistContact.Picture = reader["picture"].ToString(); viewArtistContact.ArtistId = Convert.ToInt32(reader["artistId"].ToString()); viewArtistContact.IdArtistContact = Convert.ToInt32(reader["idArtistContact"].ToString()); viewArtistContact.Bandcamp = reader["bandcamp"].ToString(); viewArtistContact.Soundcloud = reader["soundcloud"].ToString(); viewArtistContact.Website = reader["website"].ToString(); viewArtistContact.Tumblr = reader["tumblr"].ToString(); viewArtistContact.Facebook = reader["facebook"].ToString(); viewArtistContact.Twitter = reader["twitter"].ToString(); viewArtistContact.Email = reader["email"].ToString(); } } } return(viewArtistContact); }