//Delete Data Operation public bool removeTable(PresetData presetdata) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "GNIBData.db"))) { connection.Delete(presetdata); return(true); } } catch (SQLiteException ex) { Console.WriteLine("SQLiteEx", ex.Message); return(false); } }
//Edit Operation public bool updateTable(PresetData presetdata) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "GNIBData.db"))) { connection.Query <PresetData>("UPDATE PresetData set FName=?, SName=?, Email=?,Emailmatch?,FamilyApplicant=?,CurrentPass=?,IrpDate=?,LastIrpNum=?,Cat=?,SubCat=?Where Id=?", presetdata.Fname, presetdata.Sname, presetdata.Email, presetdata.EmailMatch, presetdata.FamilyApplicant, presetdata.CurrentPass, presetdata.Irp_Date, presetdata.Last_IrpNum, presetdata.Category, presetdata.SubCategory, presetdata.Id); return(true); } } catch (SQLiteException ex) { Console.WriteLine("SQLiteEx", ex.Message); return(false); } }