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 int ColumnIndexGetterCardInfoFile(DataTable sheetInfo, string typeOfWorkout) { IndexGetters index = new IndexGetters(); int returnIndex = 0; for (int i = 0; i < sheetInfo.Columns.Count; i++) { if (sheetInfo.Rows[index.CardExpirationStartingRowIndex(sheetInfo)][i].ToString().ToLower().Equals(typeOfWorkout.Trim().ToLower())) { returnIndex = i; break; } } return(returnIndex); }
private void CardValidityPupulation(DataTable sheetInfo, string insctructor, string studio) { IndexGetters indexes = new IndexGetters(); ExcelReader excel = new ExcelReader(); DataTable expenseInfo = excel.ExcelToDataTable("Справка карти", expenseFile); var workouts = indexes.ListOfWorkouts(sheetInfo); var workoutsIndexes = indexes.Ranges(sheetInfo); var workoutType = ""; for (int i = 0; i < sheetInfo.Rows.Count; i++) { var cardName = sheetInfo.Rows[i][nOfCardIndex].ToString(); var typeOfGood = sheetInfo.Rows[i][typeOfGoodIndex].ToString(); var ammount = 0; if (!cardName.Equals("") && !cardName.Equals("N: на карта") && !typeOfGood.Equals("ваучер")) { for (int j = 0; j < workouts.Count; j++) { if (i >= workoutsIndexes[j][0] && i < workoutsIndexes[j][1]) { workoutType = workouts[j]; var cardRowNumber = indexes.RowOfCard(expenseInfo, cardName); var cardColumnNumber = ColumnIndexGetterCardInfoFile(expenseInfo, workoutType); if (!expenseInfo.Rows[cardRowNumber][cardColumnNumber].ToString().Equals("")) { ammount = int.Parse(expenseInfo.Rows[cardRowNumber][cardColumnNumber].ToString()); } var sum = SumForWorkoutType(ammount, workoutType).ToString(); excel.EditCellValue(expenseFile, "Справка карти", sum, cardRowNumber + 1, cardColumnNumber + 1); break; } } } } excel.EditRowColor(expenseFile, "Справка карти", (indexes.CardExpirationStartingRowIndex(expenseInfo) + 2), date); }