public static void Delete(taskClass task)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute($"delete from tbl_tasks where TaskID=@TaskID", task);
}
}
public static void SaveTask(taskClass task)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("insert into tbl_tasks (TaskTitle, AssignedPerson, Date, Time, Priority, Description) values (@TaskTitle, @AssignedPerson, @Date, @Time, @Priority, @Description)", task);
}
}
public void btnNewTask_Click(object sender, EventArgs e)
{
taskClass p = new taskClass();
p.TaskTitle = txtTaskTitle.Text;
p.AssignedPerson = comboAssignedPerson.Text;
p.Date = dateDate.Text;
p.Time = txtTime.Text;
p.Priority = comboPriority.Text;
p.Description = txtDescription.Text;
SqliteDataAccess.SaveTask(p);
MessageBox.Show("Task Succesfully Added");
this.Close();
}
