public void InsertTask(TaskObject task)
{
using (MySqlConnection conn = GetConnection()) {
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO Tasks(TaskName,TaskDescription,TaskProgress,StartDate,EndDate,TaskStatus,ModuleID) VALUES(@TaskName, @TaskDescription, @TaskProgress, @StartDate, @EndDate, @TaskStatus, @ModuleID)", conn);
cmd.Parameters.AddWithValue("@TaskName", task.TaskName);
cmd.Parameters.AddWithValue("@TaskDescription", task.TaskDescription);
cmd.Parameters.AddWithValue("@TaskProgress", 0);
cmd.Parameters.AddWithValue("@StartDate", task.StartDate);
cmd.Parameters.AddWithValue("@EndDate", task.EndDate);
cmd.Parameters.AddWithValue("@TaskStatus", 0);
cmd.Parameters.AddWithValue("@ModuleID", task.ModuleID);
cmd.ExecuteNonQuery();
}
}
public void UpdateTask(TaskObject task)
{
using (MySqlConnection conn = GetConnection()) {
conn.Open();
MySqlCommand cmd = new MySqlCommand("UPDATE Tasks SET(TaskName,TaskDescription,TaskProgress,StartDate,EndDate,TaskStatus, ModuleID) VALUES(@TaskName, @TaskDescription, @TaskProgress, @StartDate, @EndDate, @TaskStatus, @ModuleID) WHERE TaskID = @TaskID", conn);
cmd.Parameters.AddWithValue("@TaskID", task.TaskID);
cmd.Parameters.AddWithValue("@TaskName", task.TaskName);
cmd.Parameters.AddWithValue("@TaskDescription", task.TaskDescription);
cmd.Parameters.AddWithValue("@TaskProgress", task.TaskProgress);
cmd.Parameters.AddWithValue("@StartDate", task.StartDate);
cmd.Parameters.AddWithValue("@EndDate", task.EndDate);
cmd.Parameters.AddWithValue("@TaskStatus", task.Status);
cmd.Parameters.AddWithValue("@ModuleID", task.ModuleID);
cmd.ExecuteNonQuery();
}
}