public int ExecuteMirrorsScalarInt(System.Data.Common.DbCommand command)
{
command.Connection = MirrorsConn;
int returnVal = 0;
command.CommandTimeout = 0;
try
{
if (ConnectionState.Closed == MirrorsConn.State)
{
MirrorsConn.Open();
}
returnVal = Convert.ToInt32(command.ExecuteScalar());
}
finally
{
if (ConnectionState.Open == MirrorsConn.State)
{
MirrorsConn.Close();
}
}
return(returnVal);
}
//mirror section
public DataTable ExecuteMirrorsTableQuery(System.Data.Common.DbCommand command)
{
DataTable returnTable = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter((SqlCommand)command);
command.Connection = MirrorsConn;
try
{
if (MirrorsConn.State == ConnectionState.Closed)
{
MirrorsConn.Open();
}
adapter.Fill(returnTable);
}
finally
{
if (ConnectionState.Open == MirrorsConn.State)
{
MirrorsConn.Close();
}
}
return(returnTable);
}
