public async Task <IssMessageDTO> SaveMerchManualTxnProduct(MerchManualTxnDTO manualSlipEntry) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), manualSlipEntry.SettleId, manualSlipEntry.TxnId, manualSlipEntry.TxnDetailId, manualSlipEntry.ProdCd, manualSlipEntry.Quantity, manualSlipEntry.ProdAmt, manualSlipEntry.Description, manualSlipEntry.UnitPrice, manualSlipEntry.UserId, manualSlipEntry.VATAmt, manualSlipEntry.VATCd }; var paramNameList = new[] { "@AcqNo", "@SettleId", "@TxnId", "@TxnDetailId", "@ProdCd", "@Qty", "@AmtPts", "@Descp", "@UnitPrice", "@UserId", "@VATAmt", "@VATCd" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@oTxnDetailId", DataType = "varchar", ColLength = 19 } }; var paramCollection = BuildParameterListWithOutPutAndRrn(parameters, outPutParameter, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync (BuildSqlCommandWithRrn("WebMerchManualTxnDetailMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var oTxnDetailId = paramCollection.Where(x => x.ParameterName == "@oTxnDetailId").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.TxnDetailId = Convert.ToString(oTxnDetailId); return(issMessage); } }
/// <author> /// Tuan /// </author> /// <param date="1/03/2017"></param> /// <param name="ManualSlipEntryBatchDetailDTO"></param> /// <returns> string</returns> public async Task <IssMessageDTO> SaveManualSlipEntry(MerchManualTxnDTO merchmanualTxn) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), merchmanualTxn.TxnCd, merchmanualTxn.Dealer, merchmanualTxn.TerminalId, merchmanualTxn.SiteId, merchmanualTxn.SettleId , merchmanualTxn.TxnId, merchmanualTxn.ReceiptNo, merchmanualTxn.InvoiceNo, merchmanualTxn.Stan, merchmanualTxn.CardNo , merchmanualTxn.CardExpiry, merchmanualTxn.DriverCard, merchmanualTxn.AuthCardExp, NumberExtensions.ConvertIntToDb(merchmanualTxn.DriverCd), merchmanualTxn.TxnDate, NumberExtensions.ConvertIntToDb(merchmanualTxn.ArrayCount), merchmanualTxn.Quantity, merchmanualTxn.TotalAmt, merchmanualTxn.Description, merchmanualTxn.OdometerReading, merchmanualTxn.Rrn, merchmanualTxn.AuthNo, merchmanualTxn.Sts, merchmanualTxn.UserId, merchmanualTxn.VATNo }; var paramNameList = new[] { "@AcqNo", "@TxnCd", "@BusnLocation", "@TermId", "@SiteId", "@SettleId", "@TxnId", "@RcptNo", "@InvoiceNo", "@Stan", "@CardNo", "@CardExp", "@AuthCardNo", "@AuthCardExp", "@DriverCd", "@TxnDate", "@ArrayCnt", "@Qty", "@Amt", "@Descp", "@Odometer", "@Rrn", "@AuthNo", "@Sts", "@UserId", "@VATNo" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@oTxnId", DataType = "varchar", ColLength = 19 }, new ColumnInfo { FieldName = "@oSettleId", DataType = "varchar", ColLength = 19 } }; var paramCollection = BuildParameterListWithOutPutAndRrn(parameters, outPutParameter, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync (BuildSqlCommandWithRrn("WebMerchManualTxnMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var txnId = paramCollection.Where(x => x.ParameterName == "@oTxnId").FirstOrDefault().Value; var settleId = paramCollection.Where(x => x.ParameterName == "@oSettleId").FirstOrDefault().Value; return(new IssMessageDTO() { Descp = string.Empty, Flag = Convert.ToInt32(resultCode), paraOut = new ReturnObject { TxnId = Convert.ToString(txnId), SettleId = Convert.ToString(settleId) } }); } }