internal static int RestoreDeletedTask(int id) { int i = -999; var db = new SQLiteConnection(dbPath); DeletedTask existingItem = db.Get <DeletedTask>(id); if (existingItem != null) { i = db.Delete <DeletedTask>(id); Task restoreTask = new Task(); // restoreTask.Id = existingItem.Id; restoreTask.Title = existingItem.Title; restoreTask.Description = existingItem.Description; restoreTask.Color = existingItem.Color; restoreTask.Date_Time = existingItem.Date_Time; i = Datas.InsertNewData(restoreTask, DateTime.Now); } return(i); }
internal static int DeleteRow(int v) { int i = -999; var db = new SQLiteConnection(dbPath); Task existingItem = db.Get <Task>(v); if (existingItem != null) { i = db.Delete <Task>(v); // HERE DELETING FROM CREATE TABLE AND INSERTING TO TRASH TABLE DeletedTask dt = new DeletedTask(); dt.Id = existingItem.Id; dt.Title = existingItem.Title; dt.Description = existingItem.Description; dt.Color = existingItem.Color; dt.Date_Time = existingItem.Date_Time; Insert_DeletedData(dt); } db.Close(); return(i); }
internal static int DeleteRow_DeletedTaskPermanent(int id) { int i = -999; var db = new SQLiteConnection(dbPath); DeletedTask existingItem = db.Get <DeletedTask>(id); if (existingItem != null) { i = db.Delete <DeletedTask>(id); } Console.WriteLine(".................. DETE TRASH RESULT" + i); db.Close(); return(i); }
////////////////////////////////////////////////////////////////////////////////////////////////////////// internal static int Insert_DeletedData(DeletedTask deletedTask) { var db = new SQLiteConnection(dbPath); int i = db.Insert(deletedTask); if (i == 0) { new UIKit.UIAlertView("Trash alert FAILED", "Trash Data insertion failed " + i, null, "OK", null).Show(); } else { new UIKit.UIAlertView("Trash alert SUCCESS", "Trash Data insertion success " + i, null, "OK", null).Show(); } db.Close(); return(i); }
public static bool GetallDeletedTasks() { bool b = false; var db = new SQLiteConnection(dbPath); var task_delData = db.Table <DeletedTask>(); if (task_delData != null) { Console.WriteLine("DELETED DATA FOUND"); _deletedDataTasks.Clear(); foreach (var s in task_delData) { DeletedTask t = new DeletedTask(); t.Id = s.Id; t.Title = s.Title; t.Description = s.Description; t.Color = s.Color; t.Date_Time = s.Date_Time; _deletedDataTasks.Add(t); t = null; } b = true; } else { Console.WriteLine("NO DELETED DATA FOUND IN DATABASE"); b = false; } db.Close(); return(b); }