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