public int DeleteMtgSet(MtgSet mtgSet)
{
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.DeleteSet", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SetID", SqlDbType.Int).Value = mtgSet.SetId;
con.Open();
var ID = cmd.ExecuteNonQuery();
return(ID);
}
}
}
public int InsertMtgSet(MtgSet mtgSet)
{
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.InsertSet", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(@"SetName", SqlDbType.VarChar, 100).Value = mtgSet.SetName;
cmd.Parameters.Add(@"SetSize", SqlDbType.Int).Value = mtgSet.SetSize;
cmd.Parameters.Add(@"SetRares", SqlDbType.VarChar).Value = mtgSet.SetRares;
cmd.Parameters.Add(@"SetUncommons", SqlDbType.VarChar).Value = mtgSet.SetUncommons;
cmd.Parameters.Add(@"SetCommons", SqlDbType.VarChar).Value = mtgSet.SetCommons;
cmd.Parameters.Add(@"SetBasicLands", SqlDbType.VarChar).Value = mtgSet.SetBasicLands;
cmd.Parameters.Add(@"SetReleaseDate", SqlDbType.VarChar).Value = mtgSet.SetReleaseDate;
con.Open();
var ID = cmd.ExecuteScalar();
mtgSet.SetId = Convert.ToInt32(ID.ToString());
}
}
return(mtgSet.SetId);
}
public int UpdateMtgSet(MtgSet mtgSet)
{
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.UpdateSet", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SetID", SqlDbType.Int).Value = mtgSet.SetId;
cmd.Parameters.Add("@SetName", SqlDbType.VarChar, 100).Value = mtgSet.SetName;
cmd.Parameters.Add("@SetSize", SqlDbType.Int).Value = mtgSet.SetSize;
cmd.Parameters.Add("@SetRares", SqlDbType.Int).Value = mtgSet.SetRares;
cmd.Parameters.Add("@SetUncommons", SqlDbType.Int).Value = mtgSet.SetUncommons;
cmd.Parameters.Add("@SetCommons", SqlDbType.Int).Value = mtgSet.SetCommons;
cmd.Parameters.Add("@SetBasicLands", SqlDbType.Int).Value = mtgSet.SetBasicLands;
cmd.Parameters.Add("@SetReleaseDate", SqlDbType.DateTime).Value = mtgSet.SetReleaseDate;
con.Open();
var ID = cmd.ExecuteNonQuery();
return(ID);
}
}
}
