public bool Save()
{
var dataAcc = new DataAccessor();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = string.Format(@"UPDATE usersettings
SET name = '{0}', hoursIfVacation = '{1}', hourlyrate = '{2}' ", Name, FormatFloatToString(VacancyHours), FormatFloatToString(HourlyRate));
var reader = command.ExecuteNonQuery();
return reader > 0;
}
}
public User()
{
var dataAcc = new DataAccessor();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = "SELECT * FROM usersettings";
var reader = command.ExecuteReader();
while (reader.Read())
{
Name = reader.GetString(0);
HolidayHours = reader.GetFloat(1);
VacancyHours = reader.GetFloat(1);
HourlyRate = reader.GetFloat(2);
}
}
}
public static float GetHoursForMonth(string month, string year)
{
var dataAcc = new DataAccessor();
var retFloat = 0.0f;
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())
{
retFloat += reader.GetFloat(3);
}
}
return retFloat;
}
public bool Save()
{
var dataAcc = new DataAccessor();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = string.Format(@"INSERT INTO worktime
(workedHours, dayType, day, month, year)
VALUES
('{0}', '{1}', '{2}', '{3}', '{4}')", FormatFloatToString(this.Hours), (int)DayType, this.Day, this.Month, this.Year);
var reader = command.ExecuteNonQuery();
return reader > 0;
}
}
public bool Edit()
{
var dataAcc = new DataAccessor();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = string.Format(@"UPDATE worktime
SET workedHours = '{0}', dayType = '{1}'
WHERE day = '{2}' AND month = '{3}' AND year = '{4}'",
FormatFloatToString(this.Hours), (int)DayType, this.Day, this.Month, this.Year);
var reader = command.ExecuteNonQuery();
return reader > 0;
}
}
public bool Delete()
{
var dataAcc = new DataAccessor();
using (var command = new SQLiteCommand(dataAcc.GetConnection()))
{
command.CommandText = string.Format(@"DELETE FROM worktime
WHERE day = '{0}' AND month = '{1}' AND year = '{2}'", this.Day, this.Month, this.Year);
var reader = command.ExecuteNonQuery();
return reader > 0;
}
}
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;
}