public static void HapusData(string id)
{
DataTugas databaseObject = new DataTugas();
databaseObject.OpenConnection();
using (SQLiteCommand cmd = new SQLiteCommand(databaseObject.myConnection))
{
cmd.CommandText = "DELETE FROM DataTugas WHERE ID = @I";
cmd.Prepare();
cmd.Parameters.AddWithValue("@I", int.Parse(id));
cmd.ExecuteNonQuery();
}
databaseObject.CloseConnection();
}
public static void EditData(string nama, string deadline, string kategori, string deskripsi, string id)
{
DataTugas databaseObject = new DataTugas();
databaseObject.OpenConnection();
using (SQLiteCommand cmd = new SQLiteCommand(databaseObject.myConnection))
{
cmd.CommandText = "UPDATE DataTugas "
+ "SET NamaTugas = @N, Deadline = @D, Kategori = @K, Deskripsi = @Ds "
+ "WHERE Id = @I";
cmd.Prepare();
cmd.Parameters.AddWithValue("@I", int.Parse(id));
cmd.Parameters.AddWithValue("@N", nama);
cmd.Parameters.AddWithValue("@D", deadline);
cmd.Parameters.AddWithValue("@K", kategori);
cmd.Parameters.AddWithValue("@Ds", deskripsi);
cmd.ExecuteNonQuery();
}
databaseObject.CloseConnection();
}