Project_Marmelade.Business.OptimizationBusiness.OptimPersist.SaveFruitInfo C# (CSharp) Method

SaveFruitInfo() public method

public SaveFruitInfo ( List updFruit ) : void
updFruit List
return void
        public void SaveFruitInfo(List<Fruit> updFruit)
        {
            try
            {
                for (int i = 0; i < updFruit.Count; i++)
                {
                    try
                    {
                        SqlCommand cmd = new SqlCommand("spSaveFruitInfo", conn);
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.Add(new SqlParameter("@Name", updFruit[i].FruitName));
                        cmd.Parameters.Add(new SqlParameter("@AmountAvailable", updFruit[i].AmountAvailable));
                        cmd.Parameters.Add(new SqlParameter("@PricePrKg", updFruit[i].PricePrKg));

                        cmd.ExecuteNonQuery();
                    }
                    catch (SqlException e)
                    {
                        string s = e.Message;
                    }
                }
            }
            catch (Exception e)
            {
                string t = e.Message;
            }           
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }

Usage Example

        public void UpdateFruitInfo(List<Fruit> updatedFruit)
        {
            OptimPersist db = new OptimPersist();

            db.SaveFruitInfo(updatedFruit);

        }