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