public void PushSumSpellData(SumSpellDataCollection col) { string sp = "up_PushSumSpellData"; foreach (SumSpellData sum in col.data.Values) { using (SqlConnection con = new SqlConnection(CONNECTION_STRING)) { using (SqlCommand cmd = new SqlCommand(sp, con)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sumid", SqlDbType.Int).Value = sum.id; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = sum.name; con.Open(); cmd.ExecuteNonQuery(); } finally { con.Close(); } } } } }
public void SaveSumSpellData() { SumSpellDataCollection sums = JsonConvert.DeserializeObject <SumSpellDataCollection>(Properties.Resources.SumSpellData); DataPush push = new DataPush(); push.PushSumSpellData(sums); }