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);
}
}
public void addEmptyEntry(int day, int month, int year)
{
ExcelSheet sheet = this.file.getSheet(1);
int newRow = sheet.getLastUsedRowNumber() + 1;
sheet.setCellText(newRow, 1, day.ToString());
sheet.setCellText(newRow, 2, this.getMonthAsString(month));
sheet.setCellText(newRow, 3, "");
for (int i = 1; i <= this.COLUMNS_COUNT; i++)
{
sheet.setCellColor(newRow, i, 148, 138, 84);
}
this.file.save();
}
//TODO: add it for a Lottery name, if it doesn't exists, create and initialize it (write the header)
public void addEntryForWinningNumber(int day, int month, int year, string winningNumber)
{
ExcelSheet sheet = this.file.getSheet(1);
int lastRow = sheet.getLastUsedRowNumber();
int newRow = lastRow + 1;
sheet.setCellText(newRow, 1, day.ToString());
sheet.setCellText(newRow, 2, this.getMonthAsString(month) + "-" + year.ToString());
sheet.setCellText(newRow, 3, winningNumber);
while (this.isRowAnEmptyEntry(sheet, lastRow) && lastRow > 1)
{
lastRow--;
}
for (int i = 4; i <= 13; i++)
{
if (this.columnsToNumbersMap[i].Equals(winningNumber))
{
sheet.setCellText(newRow, i, "SALIO");
sheet.setCellColor(newRow, i, 0, 255, 255);
this.drawnNumbers[i - 4] = true;
}
else
{
if (this.numberHasBeenDrawn(i - 4))
{
this.addNonWinningEntry(lastRow, i, newRow, sheet);
}
else
{
sheet.setCellColor(newRow, i, 0, 0, 0);
}
}
}
this.file.save();
}
