public async Task <MsgRetriever> WebSAPSOAInfoMaint(SAP_SOAInfo _SAP, string SapNo) { var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[10]; SqlCommand cmd = new SqlCommand(); Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo); Parameters[1] = String.IsNullOrEmpty(_SAP.SelectedAccountType) ? new SqlParameter("@AcctType", DBNull.Value) : new SqlParameter("@AcctType", _SAP.SelectedAccountType); Parameters[2] = String.IsNullOrEmpty(_SAP.SelectedTxnCategory) ? new SqlParameter("@TxnCategory", DBNull.Value) : new SqlParameter("@TxnCategory", _SAP.SelectedTxnCategory); Parameters[3] = new SqlParameter("@LPCFlag", BaseClass.ConvertBoolDB(_SAP.LatePayementChargeFlag)); Parameters[4] = new SqlParameter("@HandlingFeeFlag", BaseClass.ConvertBoolDB(_SAP.HandlingFeeFlag)); Parameters[5] = new SqlParameter("@PayeeCardFlag", BaseClass.ConvertBoolDB(_SAP.PayeeCardFlag)); Parameters[6] = new SqlParameter("@EWTFlag", BaseClass.ConvertBoolDB(_SAP.EWTFlag)); Parameters[7] = String.IsNullOrEmpty(_SAP.priceShieldHours) ? new SqlParameter("@PriceShieldHours", DBNull.Value) : new SqlParameter("@PriceShieldHours", _SAP.priceShieldHours); Parameters[8] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[8].Direction = ParameterDirection.ReturnValue; Parameters[9] = new SqlParameter("@AcctTxnType", DBNull.Value); var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPSOAInfoMaint]", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value); var Descp = GetMessageCode(Result); objDataEngine.CloseConnection(); return(await Descp); }
public async Task <SAP_SOAInfo> SAPSOAInfo(string SapNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@sapNo", DBNull.Value) : new SqlParameter("@sapNo", SapNo); var execResult = objDataEngine.ExecuteCommand("WebSAPSOAInfoSelect", CommandType.StoredProcedure, Parameters); var _SAP = new SAP_SOAInfo(); while (execResult.Read()) { _SAP.SelectedAccountType = Convert.ToString(execResult["AcctType"]); _SAP.AccountType = await BaseClass.WebGetRefLib("City"); _SAP.HandlingFee = Convert.ToString(execResult["HandlingFee"]); _SAP.SelectedTxnCategory = Convert.ToString(execResult["AcctTxnType"]); _SAP.TxnCategory = await BaseClass.WebGetRefLib("City"); _SAP.priceShieldHours = Convert.ToString(execResult["PriceShieldHours"]); } return(_SAP); }