private void findDrawnNumbers()
{
for (int i = 0; i < 10; i++)
{
this.drawnNumbers[i] = false;
}
ExcelSheet sheet = this.file.getSheet(1);
int lastRow = sheet.getLastUsedRowNumber();
while (lastRow > 1)
{
for (int i = 0; i < 10; i++)
{
if (!this.numberHasBeenDrawn(i))
{
if (!sheet.getCellText(lastRow, i + 4).Equals(""))
{
this.drawnNumbers[i] = true;
}
}
}
lastRow--;
}
}
private void addNonWinningEntry(int lastRow, int column, int newRow, ExcelSheet sheet)
{
string days = sheet.getCellText(lastRow, column);
if (days.Equals("SALIO"))
{
sheet.setCellText(newRow, column, "1 DIA");
this.colorizeCellAccordingToDaysPassed(newRow, column, 1, sheet);
}
else if (days.Equals("1 DIA"))
{
sheet.setCellText(newRow, column, "2 DIAS");
this.colorizeCellAccordingToDaysPassed(newRow, column, 2, sheet);
}
else
{
days = days.Replace(" DIAS", "");
int numberOfDays = Int32.Parse(days);
numberOfDays++;
this.colorizeCellAccordingToDaysPassed(newRow, column, numberOfDays, sheet);
days = numberOfDays.ToString() + " DIAS";
sheet.setCellText(newRow, column, days);
}
}
private bool isRowAnEmptyEntry(ExcelSheet sheet, int row)
{
return((sheet.getCellText(row, 3).Equals("")) || (sheet.getCellText(row, 3).Equals("DOMINGO")));
}