public async Task <MsgRetriever> WebSAPCAOMaint(SAP_Cao _CAO, string SapNo)
//[WebSAPCAOMaint]
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[13];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo);
Parameters[1] = String.IsNullOrEmpty(_CAO.CreditLimit) ? new SqlParameter("@CrLimit", DBNull.Value) : new SqlParameter("@CrLimit", _CAO.CreditLimit);
Parameters[2] = String.IsNullOrEmpty(_CAO.NIRD) ? new SqlParameter("@NIRD", DBNull.Value) : new SqlParameter("@NIRD", ConvertToDatetimeDB(_CAO.NIRD));
Parameters[3] = String.IsNullOrEmpty(_CAO.SelectedCreditControlArea) ? new SqlParameter("@CrCtrlArea", DBNull.Value) : new SqlParameter("@CrCtrlArea", _CAO.SelectedCreditControlArea);
Parameters[4] = String.IsNullOrEmpty(_CAO.SelectedRiskCategory) ? new SqlParameter("@RiskCategory", DBNull.Value) : new SqlParameter("@RiskCategory", _CAO.SelectedRiskCategory);
Parameters[5] = String.IsNullOrEmpty(_CAO.SecurityCreditAmount) ? new SqlParameter("@SecureCreditAmt", DBNull.Value) : new SqlParameter("@SecureCreditAmt", _CAO.SecurityCreditAmount);
Parameters[6] = String.IsNullOrEmpty(_CAO.SelectedPaymentTerms) ? new SqlParameter("@PaymtTerm", DBNull.Value) : new SqlParameter("@PaymtTerm", _CAO.SelectedPaymentTerms);
Parameters[7] = String.IsNullOrEmpty(_CAO.DBLInvoice) ? new SqlParameter("@DBLInvoiceNo", DBNull.Value) : new SqlParameter("@DBLInvoiceNo", _CAO.DBLInvoice);
Parameters[8] = String.IsNullOrEmpty(_CAO.SelectedPaymentMethodSupplier) ? new SqlParameter("@PaymtMethodSupplier", DBNull.Value) : new SqlParameter("@PaymtMethodSupplier", _CAO.SelectedPaymentMethodSupplier);
Parameters[9] = String.IsNullOrEmpty(_CAO.Authorization) ? new SqlParameter("@Authorization", DBNull.Value) : new SqlParameter("@Authorization", _CAO.Authorization);
Parameters[10] = new SqlParameter("@InterestFlag", BaseClass.ConvertBoolDB(_CAO.InterestFlag));
Parameters[11] = String.IsNullOrEmpty(_CAO.PaymentHistoryRecord) ? new SqlParameter("@PaymtHistRec", DBNull.Value) : new SqlParameter("@PaymtHistRec", _CAO.PaymentHistoryRecord);
Parameters[12] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[12].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPCAOMaint]", 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_Cao> SAPGetCAO(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("WebSAPCAOSelect", CommandType.StoredProcedure, Parameters);
var _SAP = new SAP_Cao();
while (execResult.Read())
{
_SAP.CreditLimit = Convert.ToString(execResult["CreditLimit"]);
_SAP.NIRD = Convert.ToString(execResult["NIRD"]);
_SAP.SelectedCreditControlArea = Convert.ToString(execResult["CreditControlArea"]);
_SAP.SelectedRiskCategory = Convert.ToString(execResult["RiskCategory"]);
_SAP.SecurityCreditAmount = Convert.ToString(execResult["SecureCreditAmt"]);
_SAP.SelectedPaymentTerms = Convert.ToString(execResult["PaymtTerm"]);
_SAP.Authorization = Convert.ToString(execResult["Authorization"]);
_SAP.PaymentHistoryRecord = Convert.ToString(execResult["PaymtHistRec"]);
_SAP.CreditControlArea = await BaseClass.WebGetRefLib("City");
_SAP.PaymentMethodSupplier = await BaseClass.WebGetRefLib("City");
_SAP.PaymentTerms = await BaseClass.WebGetRefLib("City");
_SAP.RiskCategory = await BaseClass.WebGetRefLib("City");
}
return(_SAP);
}
