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