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