public static int Execute(string command, byte[] image)
{
SqlCommand cmd = new SqlCommand(command, DBConnection.connect());
cmd.Parameters.Add(new SqlParameter("@imagedata", (object)image));
return(cmd.ExecuteNonQuery());
}
public static int Execute(string command, byte[] signature1, byte[] signature2)
{
SqlCommand cmd = new SqlCommand(command, DBConnection.connect());
cmd.Parameters.Add(new SqlParameter("@signature1", (object)signature1));
cmd.Parameters.Add(new SqlParameter("@signature2", (object)signature2));
return(cmd.ExecuteNonQuery());
}
public static int Execute(string command, byte[] MemberSig, byte[] GuardianSig, byte[] IssuerSig)
{
SqlCommand cmd = new SqlCommand(command, DBConnection.connect());
cmd.Parameters.Add(new SqlParameter("@MemberSig", (object)MemberSig));
cmd.Parameters.Add(new SqlParameter("@GuardianSig", (object)GuardianSig));
cmd.Parameters.Add(new SqlParameter("@IssuerSig", (object)IssuerSig));
return(cmd.ExecuteNonQuery());
}
public static DataTable GetRecordSet(string query)
{
SqlDataAdapter adapter = new SqlDataAdapter(query, DBConnection.connect());
DataTable table = new DataTable();
adapter.Fill(table);
//DBConnection.connect().Close();
return(table);
// DBConnection.connect().Dispose();
//DBConnection.connect().Close();
}
public static int Execute(string command)
{
SqlCommand cmd = new SqlCommand(command, DBConnection.connect());
return(cmd.ExecuteNonQuery());
}