public static void CreateTable(SQLiteConnection connection)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureDetailsCommands.CreateTable(command);
command.ExecuteNonQuery();
}
}
public static long InsertRow(SQLiteConnection connection, ref FixtureDetailsModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureDetailsCommands.InsertRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
else if (check == 0)
{
throw new Exception("DBFixtureDetails -> InsertRow -> No Row is Inserted.");
}
throw new Exception("DBFixtureDetails -> InsertRow -> Insert Not Successful.");
}
}
public static long UpdateRow(SQLiteConnection connection, FixtureDetailsModel model)
{
long index;
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureDetailsCommands.UpdateRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
index = connection.LastInsertRowId;
return(index);
}
else if (check == 0)
{
//throw new Exception("DBFixtureDetails -> UpdateRow -> No Row is Updated.");
return(0);
}
throw new Exception("DBFixtureDetails -> UpdateRow -> Update Not Successful.");
}
}
