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