public FlowerCategory GetFlowerCategoryById(int id)
{
FlowerCategory category = null;
using (DbConnection conn = new SqlConnection(ConnectionStr))
{
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT [id]
,[name]
,[img_url]
FROM [dbo].[flower_category]
WHERE id = @id";
cmd.AddParameter("@id", System.Data.DbType.Int32, id);
conn.Open();
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
category = new FlowerCategory()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
ImgUrl = reader.GetString(2)
};
}
}
}
}
return(category);
}
public IList <FlowerCategory> GetFlowerCategories()
{
IList <FlowerCategory> list = new List <FlowerCategory>();
using (DbConnection conn = new SqlConnection(ConnectionStr))
{
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT [id]
,[name]
,[img_url]
FROM [dbo].[flower_category]";
// NOTE FOR COURSEWORK MARKER:
// IF SOME ERROR OCCURS HERE WHEN FIRST TIME RUNNING
// RERUN THE APPLICATION, EVERYTHING SHOULD WORK NORMALLY
conn.Open();
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
FlowerCategory category = new FlowerCategory()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
ImgUrl = reader.GetString(2)
};
list.Add(category);
}
}
}
}
return(list);
}
