public static DataTable PerformQueryToCompany(bool AllCompany, string selectStatement, List <SqlParameter> SqlParameters, string dataAreaID)
        {
            DataTable TotalResults = null;

            if (AllCompany) //All Company
            {
                var CompanyList = GetAllCompanies();
                foreach (var Company in CompanyList)
                {
                    var ext          = new DataBaseAccess();
                    var paramsToSend = new List <SqlParameter>();
                    foreach (var par in SqlParameters)
                    {
                        paramsToSend.Add(new SqlParameter(par.ParameterName, par.Value));
                    }
                    paramsToSend.Add(new SqlParameter("AxCompany", Company));
                    var results = ext.OpenConnectionGetResults(DataBaseAccess.GetDataBaseName(Company), selectStatement, paramsToSend.ToArray());
                    if (TotalResults != null && TotalResults.Rows.Count > 0)
                    {
                        foreach (DataRow row in results.Rows)
                        {
                            TotalResults.ImportRow(row);
                        }
                    }
                    else
                    {
                        TotalResults = results;
                    }
                }
            }

            else //Just my company
            {
                var ext = new DataBaseAccess();
                SqlParameters.Add(new SqlParameter("AxCompany", dataAreaID));
                var results = ext.OpenConnectionGetResults(DataBaseAccess.GetDataBaseName(dataAreaID), selectStatement, SqlParameters.ToArray());
                TotalResults = results;
            }
            return(TotalResults);
        }
        public static DataTable openConnectionGetResultsP(string connect, string select, params DbParameter[] parameters)
        {
            DataBaseAccess external = new DataBaseAccess();

            return(external.OpenConnectionGetResults(connect, select, parameters));
        }