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