public List <FoodItems> GetAllItems() { List <FoodItems> FoodList = new List <FoodItems>(); string cStr = ConfigurationManager.ConnectionStrings["cns"].ConnectionString; using (SqlConnection cn = new SqlConnection(cStr)) { using (SqlCommand cmd = new SqlCommand("GetItems", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { FoodItems fitem = new FoodItems(); fitem.ID = Convert.ToInt32(dr[0]); fitem.Name = dr[1].ToString(); fitem.Price = Convert.ToInt32(dr[2]); fitem.FoodType = Convert.ToInt32(dr[3]); FoodList.Add(fitem); } dr.Close(); } catch (SqlException se) { throw se; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(FoodList); }
public List<FoodItems> GetAllItems() { List<FoodItems> FoodList = new List<FoodItems>(); string cStr = ConfigurationManager.ConnectionStrings["cns"].ConnectionString; using (SqlConnection cn = new SqlConnection(cStr)) { using (SqlCommand cmd = new SqlCommand("GetItems", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { FoodItems fitem = new FoodItems(); fitem.ID = Convert.ToInt32(dr[0]); fitem.Name = dr[1].ToString(); fitem.Price = Convert.ToInt32(dr[2]); fitem.FoodType = Convert.ToInt32(dr[3]); FoodList.Add(fitem); } dr.Close(); } catch (SqlException se) { throw se; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return FoodList; }