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(); }