public EditWorkDay(WorkDay workDay)
{
InitializeComponent();
_workDay = workDay;
LoadDataIntoForm();
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
var calendar = CalDate;
var date = CalDate.SelectedDate;
var dayType = GetDayType();
float hours;
if (dayType == WorkDay.DayTypes.Workday)
{
hours = float.Parse(InputHours.Text);
}
else
{
var user = new User();
hours = user.HolidayHours;
}
if (date != null)
{
var workDay = new WorkDay
{
DayType = dayType,
Hours = hours,
Day = date.Value.Day.ToString(),
Month = date.Value.Month.ToString(),
Year = date.Value.Year.ToString()
};
if (workDay.Save())
this.Close();
}
}
public static List<WorkDay> GetWorkingDaysByMonthAndYear(string month, string year)
{
var dataAcc = new DataAccessor();
var retList = new List<WorkDay>();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = string.Format("SELECT * FROM worktime WHERE month= '{0}' AND year = '{1}'", month, year);
var reader = command.ExecuteReader();
while (reader.Read())
{
var wDay = new WorkDay();
wDay.Day = (string)reader.GetString(0);
wDay.Month = (string)reader.GetString(1);
wDay.Year = (string)reader.GetString(2);
wDay.Hours = reader.GetFloat(3);
switch (reader.GetInt32(4))
{
case 0:
wDay.DayType = DayTypes.Workday;
break;
case 1:
wDay.DayType = DayTypes.Holiday;
break;
case 2:
wDay.DayType = DayTypes.Vacancy;
break;
}
retList.Add(wDay);
}
}
return retList;
}
