public void AddAlbumCategory(AlbumCategoryInfo aci)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@title", (DbType)SqlDbType.NChar, 50, aci.Title),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NChar, 300, aci.Description),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4, aci.Displayorder)
};
string commandText = string.Format(@"INSERT INTO [{0}albumcategories]([title], [description], [albumcount], [displayorder]) VALUES(@title, @description, 0, @displayorder)", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
public SAS.Common.Generic.List<AlbumCategoryInfo> GetAlbumCategory()
{
string commandText = string.Format("SELECT * FROM [{0}albumcategories] ORDER BY [displayorder]", BaseConfigs.GetTablePrefix);
IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, commandText);
SAS.Common.Generic.List<AlbumCategoryInfo> acic = new SAS.Common.Generic.List<AlbumCategoryInfo>();
while (reader.Read())
{
AlbumCategoryInfo aci = new AlbumCategoryInfo();
aci.Albumcateid = TypeConverter.ObjectToInt(reader["albumcateid"], 0);
aci.Albumcount = TypeConverter.ObjectToInt(reader["albumcount"], 0);
aci.Description = reader["description"].ToString();
aci.Displayorder = TypeConverter.ObjectToInt(reader["displayorder"], 0);
aci.Title = reader["title"].ToString();
acic.Add(aci);
}
reader.Close();
return acic;
}