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