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