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