public static bool addTransactionData(long tranId, classes.TransactionItem item) { try { List <SQLiteParameter> parameters = new List <SQLiteParameter>(); parameters.Add(new SQLiteParameter("@tranId", tranId)); parameters.Add(new SQLiteParameter("@itemId", item.itemId)); //parameters.Add(new SQLiteParameter("@item", item.item)); //parameters.Add(new SQLiteParameter("@itemCode", item.itemCode)); parameters.Add(new SQLiteParameter("@qty", item.qty)); parameters.Add(new SQLiteParameter("@discount", item.discount)); parameters.Add(new SQLiteParameter("@ppu", item.ppu)); int inserted = Job.Database.executeQuery("insert into _transaction_data(dataTranId,dataItemId,dataQty,dataDiscount,dataPPU) values(@tranId,@itemId,@qty,@discount,@ppu)", parameters.ToArray()); return(inserted > 0); } catch (Exception ex) { throw new Exception("Unable to add new tranaction data into database."); } return(false); }