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