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