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; }