public List <ToDoRecord> GetToDosMonth(string year, string month)
{
try
{
using (MySqlConnection connection = new MySqlConnection(ConnectionSettings.ConectionVal()))
{
MySqlCommand command = connection.CreateCommand();
command.CommandText =
$"Select* from `todo` WHERE UserID = '{LoginWindow.LoggedIn.GetID}' AND MONTH(Date) " +
$"= {month} AND YEAR(Date) " +
$"= {year} ORDER BY `todo`.`Is_Done` DESC, `todo`.`Date` DESC ;";
List <ToDoRecord> output = new List <ToDoRecord>();
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ToDoRecord toDo = new ToDoRecord
{
Date = reader["Date"].ToString().Substring(0, reader["Date"].ToString().IndexOf(" ")),
Title = reader["Title"].ToString(),
Coworkers = reader["Co-Worker"].ToString(),
Description = reader["Description"].ToString(),
UserID = reader["UserID"].ToString(),
ID = reader["ID"].ToString(),
IsDone = reader["Is_Done"].ToString()
};
output.Add(toDo);
}
return(output);
}
}
catch
{
MessageBox.Show("Cant connect to DB");
return(null);
}
}
public void MarkAsDone(string IDtoChange)
{
try
{
using (MySqlConnection connection = new MySqlConnection(ConnectionSettings.ConectionVal()))
{
MySqlCommand command = connection.CreateCommand();
command.CommandText =
$"Select* from `todo` WHERE ID = '{ IDtoChange }';";
ToDoRecord output = new ToDoRecord();
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
output.IsDone = reader["Is_Done"].ToString();
}
;
connection.Close();
if (output.IsDone == "inProgress")
{
command.CommandText =
$"UPDATE `baza_lektorow`.`todo` SET `Is_Done`='Done' WHERE `ID`={ IDtoChange };";
}
else
{
command.CommandText =
$"UPDATE `baza_lektorow`.`todo` SET `Is_Done`='inProgress' WHERE `ID`={ IDtoChange };";
}
connection.Open();
MySqlDataReader changeRecord = command.ExecuteReader();
}
}
catch
{
}
}
