//TODO: How do I make this proper async
internal async void Signup(string familyName, string value, string signupMessage)
{
var row = _spreadsheet.DatabaseSheet.DatabaseRows.GetValueOrDefault(familyName);
if (row == null)
{
return;
}
string columnHeader = null;
var weekDay = new Weekday(DayEnum.Sunday);
do
{
if (signupMessage.IndexOf(weekDay.ToString()) > -1)
{
columnHeader = weekDay.ToString();
}
weekDay.NextDay();
} while (weekDay.Day != DayEnum.Sunday);
if (columnHeader == null)
{
return;
}
var column = _spreadsheet.DatabaseSheet.DatabaseColumns.GetValueOrDefault(columnHeader);
if (column == null)
{
return;
}
SpreadsheetHandler.UpdateCell(_service, _spreadsheet.Id, value, $"{_spreadsheet.DatabaseSheet.Name}!{column.ColumnLetters}{row.RowNumber}");
}
private string ConvertToDanishDayName(Weekday day)
{
switch (day.day)
{
case Day.Monday:
return("Mandag");
case Day.Tuesday:
return("Tirsdag");
case Day.Wednesday:
return("Onsdag");
case Day.Thursday:
return("Torsdag");
case Day.Friday:
return("Fredag");
case Day.Saturday:
return("Lørdag");
case Day.Sunday:
return("Søndag");
default:
throw new FormatException("Weekday not supported - " + day.ToString());
}
}
/// <summary>
/// Return a text representation of this object.
/// </summary>
public override String ToString()
=> String.Concat(Weekday.ToString(),
"s from ",
Begin.ToString(),
" to ",
End.ToString());
public static DayOfWeek ToSystemWeekday(this Weekday wd)
{
DayOfWeek result;
if (Enum.TryParse <DayOfWeek>(wd.ToString(), out result))
{
return(result);
}
else
{
throw new Exception("Failed to covnert custom weekday to system weekday");
}
}
public static void FillInWeekdays()
{
ExcelInterface.EditCellValue(20, 1, currentMonth.ToString() + " " + currentYear);
for (int i = STARTING_COL; i <= days + STARTING_COL - 1; i++)
{
//day of the month
string dayOfMonth = i - STARTING_COL + 1 + "";
ExcelInterface.EditCellValue(i, STARTING_ROW - 1, dayOfMonth + ".");
for (int k = STARTING_ROW + 4; k < STARTING_ROW + (numberEmployees * CELLS_IN_DAY); k += 5)
{
ExcelInterface.EditCellNumberFormat(i, k, "0");
ExcelInterface.EditCellFontSize(i, k, 10);
ExcelInterface.EditCellValue(i, k, dayOfMonth + '.');
}
Weekday day = Weekday.EMPTY;
date = new DateTime(currentYear, (int)currentMonth, i - STARTING_COL + 1);
switch (date.DayOfWeek)
{
case DayOfWeek.Monday:
day = Weekday.Mo;
break;
case DayOfWeek.Tuesday:
day = Weekday.Di;
break;
case DayOfWeek.Wednesday:
day = Weekday.Mi;
break;
case DayOfWeek.Thursday:
day = Weekday.Do;
break;
case DayOfWeek.Friday:
day = Weekday.Fr;
break;
case DayOfWeek.Saturday:
day = Weekday.Sa;
ExcelInterface.EditCellColorInRange(
i, STARTING_ROW - 2,
i, STARTING_ROW + (numberEmployees * CELLS_IN_DAY) - 1,
Excel.XlRgbColor.rgbPaleTurquoise);
break;
case DayOfWeek.Sunday:
day = Weekday.So;
ExcelInterface.EditCellColorInRange(
i, STARTING_ROW - 2,
i, STARTING_ROW + (numberEmployees * CELLS_IN_DAY) - 1,
Excel.XlRgbColor.rgbPaleTurquoise);
break;
default: break;
}
ExcelInterface.EditCellValue(i, STARTING_ROW - 2, day.ToString() + ".");
}
}
private void UpdateCalendar()
{
DayNumberText.text = calendarDay.ToString();
DayNameText.text = weekday.ToString();
SeasonText.text = season.ToString();
}
void GetDay(Weekday day)
{
textField.text = day.ToString();
}
public override string ToString()
{
return(Weekday.ToString());
}
/// <summary>
/// Get First Date Of Month
/// </summary>
/// <param name="weekday"></param>
/// <param name="month"></param>
/// <param name="year"></param>
/// <returns></returns>
public static int GetFirstDateOfMonth(Weekday weekday, int month, int year)
{
int date = -1;
string dayCmp = weekday.ToString().Substring(0, 3);
for (int i = 1; i <= 7; i++)
{
if (dayCmp.Equals(new DateTime(year, month, i).ToString("ddd")))
{
date = i;
break;
}
}
return date;
}
