public bool InsertIntoTable(TransactionItemsModel model)
 {
     try
     {
         using (var connection = new SQLiteConnection(connectionString))
         {
             connection.Insert(model);
             return(true);
         }
     }
     catch (SQLiteException ex)
     {
         Log.Info("SQLiteEx", ex.Message);
         return(false);
     }
 }
 private void SaveTransactionItems()
 {
     foreach (var item in GlobalVariables.globalProductsOnCart)
     {
         mTransactionItem = new TransactionItemsModel
         {
             TransactionId             = mTransactionsDataAccess.GetLatestTransactionId(),
             ProductId                 = item.productId,
             ProductName               = item.productName,
             ProductSize               = item.productSize,
             ProductPrice              = item.productPrice,
             ProductOrigPrice          = item.productOrigPrice,
             ProductDiscountAmount     = item.productDiscountAmount,
             ProductDiscountPercentage = item.productDiscountPercentage,
             ProductSubTotalPrice      = item.productSubTotalPrice,
             ProductCountOnCart        = item.productCountOnCart
         };
         mTransactionItemsDataAccess.InsertIntoTable(mTransactionItem);
     }
 }