public IList <BLMenu> GetMenuList(Enums.ItemStatus itemStatus)
{
IList <BLMenu> menuList = new List <BLMenu>();
using (IDataReader reader = DAOBase.GetDataReader(Connection.BillerDBConnection, CommandType.StoredProcedure,
StoredProcedures.GetMenuList,
new SqlParameter()
{
ParameterName = "@pItemStatus",
Value = (int)itemStatus,
DbType = DbType.Int32
}))
{
while (reader.Read())
{
var menu = new BLMenu
{
ItemId = reader.TryGetValue <int>("ItemId"),
Name = reader.TryGetValue <string>("Name"),
Description = reader.TryGetValue <string>("Description"),
Category = reader.TryGetValue <Enums.ItemCategory>("Category"),
Type = reader.TryGetValue <Enums.ItemType>("Type"),
Price = reader.TryGetValue <decimal>("Price")
};
menuList.Add(menu);
}
}
return(menuList);
}
private void BindGrid(Enums.ItemStatus itemStatus)
{
var menuList = BalObj.GetMenuList(itemStatus);
dgMenuList.AutoGenerateColumns = false;
dgMenuList.DataSource = menuList;
dgMenuList.CellContentClick += dgMenuList_CellContentClick;
}
public IList <BLMenu> GetMenuList(Enums.ItemStatus itemStatus)
{
return(DaoObj.GetMenuList(itemStatus));
}
