public List<ItemOrdered> GetAllOrderDetail() { List<ItemOrdered> totalOrders = new List<ItemOrdered>(); string cStr = ConfigurationManager.ConnectionStrings["cns"].ConnectionString; using (SqlConnection cn = new SqlConnection(cStr)) { using (SqlCommand cmd = new SqlCommand("GetAllOrderedItems", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ItemOrdered i1 = new ItemOrdered(); i1.Name =dr[0].ToString(); i1.Count = Convert.ToInt32(dr[1]); i1.TotalIncome = Convert.ToInt32(dr[2]); totalOrders.Add(i1); } dr.Close(); } catch (SqlException se) { } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return totalOrders; }
public List <ItemOrdered> GetAllOrderDetail() { List <ItemOrdered> totalOrders = new List <ItemOrdered>(); string cStr = ConfigurationManager.ConnectionStrings["cns"].ConnectionString; using (SqlConnection cn = new SqlConnection(cStr)) { using (SqlCommand cmd = new SqlCommand("GetAllOrderedItems", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ItemOrdered i1 = new ItemOrdered(); i1.Name = dr[0].ToString(); i1.Count = Convert.ToInt32(dr[1]); i1.TotalIncome = Convert.ToInt32(dr[2]); totalOrders.Add(i1); } dr.Close(); } catch (SqlException se) { } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(totalOrders); }