public static DataTable ExecuteSelect()

in Source/Website/Data_Layer/DataAccessHandler.cs [22:55]

29 lines of code
4 McCabe index (conditional complexity)


        public static DataTable ExecuteSelect(string query, SqlParameter[] parameters = null)
        {
            DataTable table = new DataTable();

            try
            {
                var connectionString = GetConnectionString();

                using (SqlConnection con = new SqlConnection(connectionString))
                using (SqlCommand command = new SqlCommand(query, con))
                {
                    if (parameters != null)
                    {
                        command.Parameters.AddRange(parameters);
                    }

                    using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
                    {
                        if (con.State == ConnectionState.Closed)
                        {
                            con.Open();
                        }

                        dataAdapter.Fill(table);
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }

            return table;
        }