public static void UpdateTasksForDay(DailyTasks dailyTasks)
{
using (var con = new SQLiteConnection(Helper.connectionString))
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = @"UPDATE Tasks SET TasksForTheDay = @tasks WHERE Day = @day";
cmd.Parameters.AddWithValue("@tasks", dailyTasks.TasksForTheDay);
cmd.Parameters.AddWithValue("@day", dailyTasks.Day.ToString());
var a = cmd.ExecuteNonQuery();
}
con.Close();
}
}
public static List <DailyTasks> GetTasksForTheWeek()
{
List <DailyTasks> tasksForTheWeek = new List <DailyTasks>();
foreach (var day in (DayOfWeek[])Enum.GetValues(typeof(DayOfWeek)))
{
if (day == DayOfWeek.Sunday || day == DayOfWeek.Saturday)
{
continue;
}
DailyTasks dailyTasks = new DailyTasks();
using (var con = new SQLiteConnection(Helper.connectionString))
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = @"SELECT * FROM Tasks WHERE Day = @day";
cmd.Parameters.AddWithValue("@day", day.ToString());
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
Enum.TryParse(reader["Day"].ToString(), out DayOfWeek parsedDay);
dailyTasks.Day = parsedDay;
dailyTasks.TasksForTheDay = reader["TasksForTheDay"].ToString();
}
}
}
con.Close();
}
tasksForTheWeek.Add(dailyTasks);
}
return(tasksForTheWeek);
}
public static DailyTasks GetTasksForTheDay(DayOfWeek day)
{
DailyTasks dailyTasks = new DailyTasks();
using (var con = new SQLiteConnection(Helper.connectionString))
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = @"SELECT * FROM Tasks WHERE Day = '" + day.ToString() + "'";
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
dailyTasks.Day = day;
dailyTasks.TasksForTheDay = reader["TasksForTheDay"].ToString();
}
}
}
con.Close();
}
return(dailyTasks);
}
