internal static DataTable LowestOpeningBalance(DataTable table, string studio) { double balance = 0; double casRegisterBalance = 0; DataStrctures tables = new DataStrctures(); DataTable tableToReturn = tables.StartingBalanceTableStructure(); IndexGetters indexes = new IndexGetters(); var indexOfRanges = indexes.ListOfAllRanges(table); var balanceString = ""; var cashRegisterString = ""; var time = ""; for (int i = 0; i < indexOfRanges.Count; i++) { int range = indexOfRanges[i]; balanceString = table.Rows[range + 4][0].ToString().Substring(3); cashRegisterString = table.Rows[range + 6][0].ToString().Substring(6); if (!balanceString.Equals("")) { balance = DelimterConvertor(balanceString); casRegisterBalance = DelimterConvertor(cashRegisterString); time = table.Rows[range][0].ToString().Substring(0, 5); tableToReturn.Rows.Add(time, balance, casRegisterBalance, studio); } } return(tableToReturn); }
private void AvailabilityDataTable(DataTable sheetInfo) { DataStrctures structure = new DataStrctures(); DataTable BalanceSheet = reader.ExcelToDataTable("Наличност", AssemblyDirectory + @"\Zimnina\_Компот-ЦЛ.xlsx"); int startingRow = StartingRowForExport(BalanceSheet, date); for (int i = 0; i < StudioNames.Length; i++) { var lowestBalance = LowestAmmountPopulating(StudioNames[i], StartingBalances, "Balance"); var cashRegisterLowestBalance = LowestAmmountPopulating(StudioNames[i], StartingBalances, "CashRegister"); DataTable table = new DataTable(); if (StudioNames[i].Equals("Студентски")) { table = structure.AvailabilityTableStructure(date, lowestBalance, StudentskiIncome, StudentskiHonorary, "", cashRegisterLowestBalance); reader.ExportToExcel(table, AssemblyDirectory + @"\Zimnina\_Компот-Студентски.xlsx", "Наличност", numberOfLastRow: startingRow); } else { if (StudioNames[i].Equals("Лозенец")) { table = structure.AvailabilityTableStructure(date, lowestBalance, LozenecIncome, LozenecHonorary, "", cashRegisterLowestBalance); reader.ExportToExcel(table, AssemblyDirectory + @"\Zimnina\_Компот-ЦЛ.xlsx", "Наличност", numberOfLastRow: startingRow, startingCellIndex: 8); } else { table = structure.AvailabilityTableStructure(date, lowestBalance, CenteryIncome, CenterHonorary, "", cashRegisterLowestBalance); reader.ExportToExcel(table, AssemblyDirectory + @"\Zimnina\_Компот-ЦЛ.xlsx", "Наличност", numberOfLastRow: startingRow); } } } }
private List <DataTable> CardValidityDataTable(DataTable sheetInfo, List <int> trueExpenses, int year, int month, int day) { DataStrctures structure = new DataStrctures(); List <DataTable> listOfTables = new List <DataTable>(); MoneyData moneyData = new MoneyData(); for (int i = 0; i < trueExpenses.Count; i++) { DataTable table = structure.CardValidityTableStructure(); int indexOfRow = trueExpenses[i]; var money = sheetInfo.Rows[indexOfRow][moneyIndex].ToString(); var cardName = sheetInfo.Rows[indexOfRow][nOfCardIndex].ToString(); var firstAndFamilyName = sheetInfo.Rows[indexOfRow][firstAndFamiliyNameIndex].ToString(); var wayOfPaying = moneyData.deferredPayment(money); var typeOfood = sheetInfo.Rows[indexOfRow][typeOfGoodIndex].ToString(); var ammountOfMoney = moneyData.Ammout(money, typeOfood); var ValidityTo = moneyData.CardPeriodExpiration(year, month, day, ammountOfMoney); if (!cardName.Equals("") || typeOfood.Equals("ваучер")) { table.Rows.Add(cardName, firstAndFamilyName, date, ValidityTo, typeOfood, wayOfPaying, ammountOfMoney); listOfTables.Add(table); } } return(listOfTables); }
private DataTable IncomeDataTable(DataTable sheetInfo, string instrctorName, string studioName, List <int> trueExpenses) { DataStrctures structure = new DataStrctures(); DataTable table = structure.IncomeDataTableStructure(); for (int i = 0; i < trueExpenses.Count; i++) { int indexOfRow = trueExpenses[i]; var typeOfGood = sheetInfo.Rows[indexOfRow][typeOfGoodIndex].ToString(); var FirstAndFamilyName = sheetInfo.Rows[indexOfRow][firstAndFamiliyNameIndex].ToString(); var Money = sheetInfo.Rows[indexOfRow][moneyIndex].ToString(); var Receipt = sheetInfo.Rows[indexOfRow][receiptIndex].ToString(); if (!Receipt.ToLower().Equals("да")) { Receipt = "-"; } var AddditionalInfo = sheetInfo.Rows[indexOfRow][additionalInfoIndex].ToString(); switch (studioName) { case "Лозенец": LozenecIncome = LozenecIncome + Convert.ToDouble(Money); break; case "Студентски": StudentskiIncome = StudentskiIncome + Convert.ToDouble(Money); break; case "Център": CenteryIncome = CenteryIncome + Convert.ToDouble(Money); break; } table.Rows.Add(date, Receipt, studioName, FirstAndFamilyName, typeOfGood, AddditionalInfo, instrctorName, Money); } return(table); }
public void ExtractDataToArchive(int year, int month, int day) { SpreadSheetToExcel toExcel = new SpreadSheetToExcel(); DataStrctures structure = new DataStrctures(); for (int i = 0; i < Instructors().Length; i++) { string dayDirectory = ArchiveDayDirectory(year, MonthName(month), day, Instructors()[i]); Directory.CreateDirectory(dayDirectory); string sourcePath = InstructorsDirectory(year, Instructors()[i]) + @"\" + day; toExcel.Transformer(sourcePath, structure.BananasDataTableStructure()); CopyPasteFiles(sourcePath, dayDirectory); } }
private DataTable ExpenseDataTable(DataTable sheetInfo, string instrctorName, string studioName) { DataStrctures structure = new DataStrctures(); DataTable table = structure.ExpenseDataTableStructure(); string motive = "инструкторски хонорар"; double honorarySum = 0; double honorarySumToAdd = 0; for (int i = 0; i < sheetInfo.Rows.Count; i++) { string honorary = sheetInfo.Rows[i][honoraryIndex].ToString(); if (honorary.Equals("") || honorary.Equals("хонорар") || i == sheetInfo.Rows.Count - 1) { honorarySumToAdd = 0; } else { honorarySumToAdd = DelimterConvertor(honorary); } honorarySum = honorarySum + honorarySumToAdd; } switch (studioName) { case "Лозенец": LozenecHonorary = LozenecHonorary + honorarySum; break; case "Студентски": StudentskiHonorary = StudentskiHonorary + honorarySum; break; case "Център": CenterHonorary = CenterHonorary + honorarySum; break; } table.Rows.Add(date, studioName, motive, instrctorName, honorarySum); return(table); }