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