public List<string[]> GetCodeSection(string propertyTypeCode)
        {
            ExcelTasks excelTasks = new ExcelTasks();
            List<string[]> codeSectionWorkBookList = excelTasks.ConvertExcelToListCodeSection(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Prop Types, Depr Methods and Lifes.xlsx", "Property Types"));
            List<string[]> codeSections = new List<string[]>();
            foreach (string[] itr in codeSectionWorkBookList)
            {
                if (propertyTypeCode != "CST")
                {
                    if (string.Equals(itr[0], propertyTypeCode))
                    {
                        codeSections.Add(itr);
                        return codeSections;
                    }
                }
                else
                {
                    if (string.Equals(itr[0], propertyTypeCode))
                    {
                        codeSections.Add(itr);

                    }
                }

            }
            return codeSections;
            //return null;
        }
Пример #2
0
        static void Main(string[] args)
        {
            ExcelTasks excelTasks = new ExcelTasks();
            ProcessExcel processExcel = new ProcessExcel();

            List<string[]> propertyExcel = excelTasks.ConvertExcelToList(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Prop Types, Depr Methods and Lifes.xlsx", "Book Defaults"));
            processExcel.Mainlogic(propertyExcel);

            List<string[]> excelMacrs = excelTasks.ConvertExcelToListMacrsBonus(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-MACRS Bonus.xlsx", "Defaults by PT & PIS"));
            MacrsBonus macrs = new MacrsBonus();
            macrs.PushToDatabase(macrs.Mainlogic(excelMacrs));

            List<string[]> excelITC = excelTasks.ConvertExcelToListITC(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-ITC.xls", "ITC"));
            ITC itc = new ITC();
            itc.PushToDatabase(itc.MainLogic(excelITC));

            List<string[]> excelS179 = excelTasks.ConvertExcelToListS179(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Section 179.xlsx", "A. 179 Limits"));
            S179 s179 = new S179();
            List<string[]> excelS179Classification = excelTasks.ConvertExceltoListS179Classification(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-S179 Classification.xls", "Sheet1"));
            s179.PushToDatabase(s179.MainLogic(excelS179, excelS179Classification));

            List<string[]> excelLuxuryAuto = excelTasks.ConvertExcelToListLuxuryAuto(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Section 179.xlsx", "B. Luxury Autos"));
            LuxuryAuto luxuryAuto = new LuxuryAuto();
            luxuryAuto.PushToDatabase(luxuryAuto.MainLogic(excelLuxuryAuto, excelS179Classification));

            List<string[]> excelLightTrucks = excelTasks.ConvertExcelToListLightTrucks(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Section 179.xlsx", "C. Luxury TrucksVans"));
            LightTrucks lighttrucks = new LightTrucks();
            lighttrucks.PushToDatabase(lighttrucks.MainLogic(excelLightTrucks, excelS179Classification));

            List<string[]> excelS179Other = excelTasks.ConvertExcelToListS179Others(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Other Basis Reductions.xls", "179Other"));
            S179OtherDeductions other = new S179OtherDeductions();
            other.MainLogic(excelS179Other);

            List<string[]> excelSalvage = excelTasks.ConvertExcelToListSalvage(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Other Basis Reductions.xls", "179Other"));
            Salvage salvage = new Salvage();
            salvage.MainLogic(excelSalvage);

            List<string[]> excelPreACRS = excelTasks.ConvertExcelToListPreACRSBonus(excelTasks.LoadExcelSheet(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Other Basis Reductions.xls", "179Other"));
               PreACRSBonus preACRSBonus = new PreACRSBonus();
               preACRSBonus.MainLogic(excelPreACRS);

               //PreACRSBonus preACRSBonus = new PreACRSBonus();
               //preACRSBonus.MainLogic(excelPreACRS);

               ZoneType zoneType = new ZoneType();
               List<string[]> zoneTypeData = zoneType.LoadCSV(@"D:\Sage\SRC\RuleBaseInsertion\Rulebase-Zones.csv");
            List<string> propertyList = new List<string>();
                propertyList.Add( "AUT");
                propertyList.Add( "BDG");
                propertyList.Add( "BUS");
                propertyList.Add( "CEQ");
                propertyList.Add( "COQ");
                propertyList.Add( "CSW");
                propertyList.Add( "FFE");
                propertyList.Add( "INT");
                propertyList.Add( "LDI");
                propertyList.Add( "LHI");
                propertyList.Add( "LND");
                propertyList.Add( "MFG");
                propertyList.Add( "PPN");
                propertyList.Add( "RPN");
                propertyList.Add( "RRB");
                propertyList.Add( "TLR");
                propertyList.Add( "TRH");
                propertyList.Add( "LTV");
                propertyList.Add( "UNT");
                propertyList.Add( "WRS");
                propertyList.Add( "CST");
                propertyList.Add("SUV");
                Console.WriteLine("ZoneTypes");
            foreach(string propertyType in propertyList)
            {
                Dictionary<string, List<string>> zones = zoneType.GetZoneTypes(propertyType, zoneTypeData);
                zoneType.AddZoneTypeRecords(propertyType, zones);
            }
        }