public async Task <MsgRetriever> WebReloadAllocDetailMaint(PrepaidCardnAcct _PrepaidCardnAcct, int ParentTxnId, string func, string AcctNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[14];
Parameters[0] = String.IsNullOrEmpty(_PrepaidCardnAcct.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _PrepaidCardnAcct.CardNo);
Parameters[1] = String.IsNullOrEmpty(_PrepaidCardnAcct.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _PrepaidCardnAcct.AcctNo);
Parameters[2] = String.IsNullOrEmpty(_PrepaidCardnAcct.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _PrepaidCardnAcct.SelectedStatus);
Parameters[3] = String.IsNullOrEmpty(_PrepaidCardnAcct.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _PrepaidCardnAcct.Remarks);
Parameters[4] = String.IsNullOrEmpty(_PrepaidCardnAcct.TxnDate) ? new SqlParameter("@TxnDate", DBNull.Value) : new SqlParameter("@TxnDate", ConvertDatetimeDB(_PrepaidCardnAcct.TxnDate));
Parameters[5] = String.IsNullOrEmpty(_PrepaidCardnAcct.TxnAmt) ? new SqlParameter("@TxnAmt", DBNull.Value) : new SqlParameter("@TxnAmt", ConverterDecimal(_PrepaidCardnAcct.TxnAmt));
Parameters[6] = new SqlParameter("@UserId", this.GetUserId);
Parameters[7] = func.ToLower() == "n" ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", ConvertIntToDb(_PrepaidCardnAcct.TxnId));
Parameters[8] = new SqlParameter("@ParentTxnId", ParentTxnId);
Parameters[9] = new SqlParameter("@Func", func);
Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.ReturnValue;
Parameters[11] = new SqlParameter("@IssNo", GetIssNo);
Parameters[12] = String.IsNullOrEmpty(_PrepaidCardnAcct.EffDateFrom) ? new SqlParameter("@EffDateFrom", DBNull.Value) : new SqlParameter("@EffDateFrom", ConvertDatetimeDB(_PrepaidCardnAcct.EffDateFrom));
Parameters[13] = new SqlParameter("@CreatedBy", this.GetUserId);
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebReloadAllocDetailMaint]", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
objDataEngine.CloseConnection();
return(await Descp);
}
public PrepaidCardnAcct WebReloadAllocationDetailSelect(int TxnId, string AcctNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@AcctNo", AcctNo);
Parameters[1] = new SqlParameter("@TxnId", TxnId);
var Reader = objDataEngine.ExecuteCommand("WebReloadAllocationDetailSelect", CommandType.StoredProcedure, Parameters);
while (Reader.Read())
{
var _PrepaidCardnAcct = new PrepaidCardnAcct
{
CardNo = Convert.ToString(Reader["CardNo"]),
AcctNo = Convert.ToString(Reader["AcctNo"]),
SelectedStatus = Convert.ToString(Reader["Sts"]),
Remarks = Convert.ToString(Reader["Remarks"]),
ParentTxnId = Convert.ToInt64(Reader["ParentTxnId"]),
TxnDate = DateTimeConverter(Reader["TxnDate"]),
EffDateFrom = DateConverter(Reader["EffDateFrom"]),
TxnAmt = ConverterDecimal(Reader["ReloadAmt"]),
};
return(_PrepaidCardnAcct);
}
return(new PrepaidCardnAcct());
}
