public void PushChampData(ChampDataCollection col) { string sp = "up_PushChampData"; foreach (ChampData champ 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("@championId", SqlDbType.Int).Value = champ.id; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = champ.name; con.Open(); cmd.ExecuteNonQuery(); } finally { con.Close(); } } } } }
public void SaveChampData() { ChampDataCollection champs = JsonConvert.DeserializeObject <ChampDataCollection>(Properties.Resources.ChampData); DataPush push = new DataPush(); push.PushChampData(champs); }