public int ExecuteNonQuery(string command, ParameterAdder pa, object customParam)
{
SqlCommand cmd = new SqlCommand(command, _conn);
if (pa != null)
{
pa(cmd, customParam);
}
_conn.Open();
return(cmd.ExecuteNonQuery());
}
public SqlDataReader ExecuteReader(string command, ParameterAdder pa, object customParam)
{
SqlCommand cmd = new SqlCommand(command, _conn);
if (pa != null)
{
pa(cmd, customParam);
}
_conn.Open();
return(cmd.ExecuteReader());
}
public override void SetRegistration(string userID, int contestID, ContestRegistration registration)
{
string command = "UPDATE Rights SET SystemRights = @ro, IsInvisible = @ii WHERE UserID = @uid" +
" AND ContestID = @cid";
ParameterAdder pa = delegate(SqlCommand comm, object customParam)
{
ContestRegistration cr = (ContestRegistration)customParam;
comm.Parameters.AddWithValue("@ro", cr.Rights);
comm.Parameters.AddWithValue("@ii", cr.IsInvisible);
};
pa += FillMultipleIDs;
using (MsSqlQuery q = new MsSqlQuery(_connectionString))
q.ExecuteNonQuery(command, pa, new object[] { userID, contestID });
}
public XmlDocument ExecuteXmlDocument(string command, ParameterAdder pa, object customParam)
{
SqlCommand cmd = new SqlCommand(command, _conn);
if (pa != null)
{
pa(cmd, customParam);
}
_conn.Open();
XmlDocument doc = new XmlDocument();
doc.Load(cmd.ExecuteXmlReader());
return(doc);
}
