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