class FactResellerSales
    {
        public int ProductKey;
        public int OrderDateKey;
        public int ResellerKey;
        public int EmployeeKey;
        public int PromotionKey;
        public int CurrencyKey;
        public int SalesTerritoryKey;
        public string SalesOrderNumber;
        public byte SalesOrderLineNumber;
        public short OrderQuantity;
        public string CarrierTrackingNumber;
        public string CustomerPONumber;
    }

    class DimProduct
    {
        public int ProductKey;
        public string ProductAlternateKey;
        public string EnglishProductName;
        public string Color;
        public short SafetyStockLevel;
        public short ReorderPoint;
        public string SizeRange;
        public int DaysToManufacture;
        public string StartDate;
    }

    class DimReseller
    {
        public int ResellerKey;
        public string ResellerAlternateKey;
        public string Phone;
        public string BusinessType;
        public string ResellerName;
        public int NumberEmployees;
        public string OrderFrequency;
        public string ProductLine;
        public string AddressLine1;
        public string BankName;
        public int YearOpened;
    }

    class DimCurrency
    {
        public int CurrencyKey;
        public string CurrencyAlternateKey;
        public string CurrencyName;
    }

    class DimPromotion
    {
        public int PromotionKey;
        public int PromotionAlternateKey;
        public string EnglishPromotionName;
        public string EnglishPromotionType;
        public string EnglishPromotionCategory;
        public string StartDate;
        public string EndDate;
        public int MinQty;
    }

    class DimSalesTerritory
    {
        public int SalesTerritoryKey;
        public int SalesTerritoryAlternateKey;
        public string SalesTerritoryRegion;
        public string SalesTerritoryCountry;
        public string SalesTerritoryGroup;
    }

    class DimEmployee
    {
        public int EmployeeKey;
        public string FirstName;
        public string LastName;
        public string Title;
        public string BirthDate;
        public string LoginID;
        public string EmailAddress;
        public string Phone;
        public string MaritalStatus;
        public string Gender;
        public byte PayFrequency;
        public short VacationHours;
        public short SickLeaveHours;
        public string DepartmentName;
        public string StartDate;
    }

    class DimDate
    {
        public int DateKey;
        public string FullDateAlternateKey;
        public byte DayNumberOfWeek;
        public string EnglishDayNameOfWeek;
        public byte DayNumberOfMonth;
        public short DayNumberOfYear;
        public byte WeekNumberOfYear;
        public string EnglishMonthName;
        public byte MonthNumberOfYear;
        public byte CalendarQuarter;
        public short CalendarYear;
        public byte CalendarSemester;
        public byte FiscalQuarter;
        public short FiscalYear;
        public byte FiscalSemester;
    }

	    // var output = new List<string>();
            //
            // var random = new Random();
            //
            // var factClass = typeof(FactResellerSales);
            // var dimClasses = from t in Assembly.GetExecutingAssembly().GetTypes()
            //     where t.IsClass && t.Namespace == "KoptevOleg_197" && t.Name.StartsWith("Dim")
            //     select t;
            //
            // var amountOfColumns = random.Next(6) + 1;
            // var columnNamesOutput = new StringBuilder();
            // var columnNames = factClass.GetFields();
            // for (int i = 0; i < amountOfColumns; i++)
            // {
            //     var itemId = random.Next(columnNames.Length);
            //     columnNamesOutput.Append("FactResellerSales." + columnNames[itemId].Name);
            //     if (i < amountOfColumns - 1)
            //         columnNamesOutput.Append(",");
            // }
            // output.Add(columnNamesOutput.ToString());
            //
            // var amountOfPredicates = random.Next(2, 8);
            // output.Add(amountOfPredicates.ToString());
            // var predicates = new string[amountOfPredicates];
            // for (int i = 0; i < amountOfPredicates; i++)
            // {
            //     var classIndex = random.Next(dimClasses.Count() + 1);
            //     string className = "";
            //     FieldInfo[] fields;
            //     if (classIndex == 0)
            //     {
            //         className = "FactResellerSales";
            //         fields = typeof(FactResellerSales).GetFields();
            //     }
            //     else
            //     {
            //         className = dimClasses.ElementAt(classIndex - 1).Name;
            //         fields = dimClasses.ElementAt(classIndex - 1).GetFields();
            //     }
            //     var fieldIndex = random.Next(fields.Length);
            //     var field = fields[fieldIndex];
            //     var fieldName = className + "." + field.Name;
            //     predicates[i] = fieldName;
            //
            //     string[] signs;
            //
            //     if (field.FieldType == typeof(string))
            //     {
            //         signs = new[] {"=", "<>"};
            //     }
            //     else
            //     {
            //         signs = new[] {"=", "<>", "<=", ">=", "<", ">"};
            //     }
            //
            //     var signIndex = random.Next(signs.Length);
            //
            //     predicates[i] += " " + signs[signIndex] + " ";
            //
            //     if (field.FieldType == typeof(string))
            //     {
            //         predicates[i] += "''";
            //     }
            // }
            // foreach (var line in predicates)
            //     output.Add(line);
            // Console.WriteLine(string.Join("\n", output));
            // File.WriteAllLines("var_1_test/my_input/test5.txt", output);