//THIS USES THE CURRENCY CONVERTER
public bool SN760756ToExcel(string filePath)
{
//try {
var engine = new FileHelperEngine <TruckCSV>();
var result = engine.ReadFile(filePath);
int currentRow = 5;
// result is now an array of RekordCSV
foreach (TruckCSV csvTruck in result)
{
csvTruck.registration = csvTruck.registration.Replace(" ", string.Empty);
//checks if any truck was found
bool truckWithThisRegistrationFound = false;
//THIS IS KAROL'S CODE
foreach (Truck element in TruckData)
{
if (element.Registration == csvTruck.registration)//this is working, just lookin bad
{
truckWithThisRegistrationFound = true;
//this is so f*****g bad i don't even
String ProductName = csvTruck.product;
if (match(ProductName, new string[] { "Olej", "Diesel", " ON" }) && csvTruck.quantity >= 0 && csvTruck.netto_price >= 0)
{
element.DieselL += (float)csvTruck.quantity;
element.DieselCost += (float)csvTruck.netto_price * currencyConverter.getRateOf(csvTruck.currency);
}
else if (match(ProductName, new string[] { "Autostrada", "Podatek", "Road tax", "Eurovignette", "Motorway", "Eurowinieta", "drogowe", "elektroniczna" }) && csvTruck.netto_price >= 0)
{
element.RoadTax += (float)csvTruck.netto_price * currencyConverter.getRateOf(csvTruck.currency);
}
else if (match(ProductName, new string[] { "AdBlue", "ad blue" }) && csvTruck.quantity >= 0 && csvTruck.netto_price >= 0)
{
element.AdblueL += (float)csvTruck.quantity;
element.AdblueCost += (float)csvTruck.netto_price * currencyConverter.getRateOf(csvTruck.currency);
}
else if (csvTruck.netto_price >= 0)
{
element.OtherCost += (float)csvTruck.netto_price * currencyConverter.getRateOf(csvTruck.currency);
}
}
}
//END OF PIETRZAKOWY KOD
//if there was no truck with this registration number
if (!truckWithThisRegistrationFound)
{
TruckNotFound truck = new TruckNotFound(filePath);
truck.line = currentRow;
truck.Registration = csvTruck.registration;
truck.otherData += "Produkt: " + csvTruck.product + ", cena: " + csvTruck.netto_price;
notFoundTrucks.Add(truck);
}
currentRow++;
}
//}
//catch (Exception e) {
// System.Windows.Forms.MessageBox.Show("Nie udało się otworzyć " + filePath);
// return false;
// }
closeAllWorkbooksDontKillApp();
return(true);
}
public bool _F61506817081ToExcel(string Path)
{
string RegistrationColumn = "X";
string ProductColumn = "E";
string QuantityColumn = "F";
string NettoPriceColumn = "T";
string CurrencyColumn = "O";
Microsoft.Office.Interop.Excel.Worksheet MyWorksheet;
Microsoft.Office.Interop.Excel.Range MyCells;
try {
MyExcel.Workbooks.Open(Path);
MyWorksheet = MyExcel.Worksheets.Item[1];
MyCells = MyWorksheet.Cells;
} catch (Exception e)
{
System.Windows.Forms.MessageBox.Show("Nie udało się otworzyć " + Path);
return(false);
}
int CurrentRow = 2;
int iRowCount = MyWorksheet.UsedRange.Rows.Count;
while (CurrentRow <= iRowCount)
{
String Reg = MyCells.Item[CurrentRow, RegistrationColumn].Value;
Reg = Reg.Replace(" ", string.Empty);
//checks if any truck was found
bool truckWithThisRegistrationFound = false;
foreach (Truck element in TruckData)
{
if (element.Registration == Reg)//this is working, just lookin bad
{
truckWithThisRegistrationFound = true;
String ProductName = MyCells.Item[CurrentRow, ProductColumn].Value;
if (match(ProductName, new string[] { "Olej", "Diesel" }) && MyCells.Item[CurrentRow, QuantityColumn].Value >= 0 && MyCells.Item[CurrentRow, NettoPriceColumn].Value >= 0)
{
element.DieselL += MyCells.Item[CurrentRow, QuantityColumn].Value;
element.DieselCost += MyCells.Item[CurrentRow, NettoPriceColumn].Value;
}
else if (match(ProductName, new string[] { "Autostrada", "Podatek", "Road tax", "Eurovignette", "Motorway" }) && MyCells.Item[CurrentRow, NettoPriceColumn].Value >= 0)
{
element.RoadTax += MyCells.Item[CurrentRow, NettoPriceColumn].Value;
}
else if (match(ProductName, new string[] { "AdBlue", "Ad Blue" }) && MyCells.Item[CurrentRow, QuantityColumn].Value >= 0 && MyCells.Item[CurrentRow, NettoPriceColumn].Value >= 0)
{
element.AdblueL += MyCells.Item[CurrentRow, QuantityColumn].Value;
element.AdblueCost += MyCells.Item[CurrentRow, NettoPriceColumn].Value;
}
else if (MyCells.Item[CurrentRow, NettoPriceColumn].Value >= 0)
{
element.OtherCost += MyCells.Item[CurrentRow, NettoPriceColumn].Value;
}
}
}
//if there was no truck with this registration number
if (!truckWithThisRegistrationFound)
{
TruckNotFound truck = new TruckNotFound(Path);
truck.line = CurrentRow;
truck.Registration = Reg;
truck.otherData += "Produkt: " + MyCells.Item[CurrentRow, ProductColumn].Value + ", ilość: " + MyCells.Item[CurrentRow, QuantityColumn].Value;
notFoundTrucks.Add(truck);
}
CurrentRow++;
}
closeAllWorkbooksDontKillApp();
return(true);
}
