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 <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 <MsgRetriever> SaveUserAccess(UserAccess _UserAccess, bool isUpdate = false)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[15];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_UserAccess.SelectedAccessInd) ? new SqlParameter("@AccessInd", DBNull.Value) : new SqlParameter("@AccessInd", _UserAccess.SelectedAccessInd);
Parameters[2] = String.IsNullOrEmpty(_UserAccess.selectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts ", _UserAccess.selectedSts);
Parameters[3] = String.IsNullOrEmpty(_UserAccess.UserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId ", _UserAccess.UserId);
Parameters[4] = String.IsNullOrEmpty(_UserAccess.Password) ? new SqlParameter("@Pw", DBNull.Value) : new SqlParameter("@Pw", _UserAccess.Password);
Parameters[5] = String.IsNullOrEmpty(_UserAccess.Name) ? new SqlParameter("@Name", DBNull.Value) : new SqlParameter("@Name ", _UserAccess.Name);
Parameters[6] = String.IsNullOrEmpty(_UserAccess.ContactNo) ? new SqlParameter("@ContactNo", DBNull.Value) : new SqlParameter("@ContactNo ", _UserAccess.ContactNo);
Parameters[7] = String.IsNullOrEmpty(_UserAccess.EmailAddr) ? new SqlParameter("@EmailAddr", DBNull.Value) : new SqlParameter("@EmailAddr ", _UserAccess.EmailAddr);
Parameters[8] = String.IsNullOrEmpty(_UserAccess.SeletedTitle) ? new SqlParameter("@Title", DBNull.Value) : new SqlParameter("@Title ", _UserAccess.SeletedTitle);
Parameters[9] = String.IsNullOrEmpty(_UserAccess.SelectedDeptId) ? new SqlParameter("@DeptId", DBNull.Value) : new SqlParameter("@DeptId ", _UserAccess.SelectedDeptId);
Parameters[10] = String.IsNullOrEmpty(_UserAccess.PrivilegeCd) ? new SqlParameter("@PrivilegeCd", DBNull.Value) : new SqlParameter("@PrivilegeCd ", _UserAccess.PrivilegeCd);
Parameters[11] = String.IsNullOrEmpty(_UserAccess.CreatedBy) ? new SqlParameter("@CreatedBy", DBNull.Value) : new SqlParameter("@CreatedBy ", _UserAccess.CreatedBy);
Parameters[12] = new SqlParameter("@ChangePassInd", BaseClass.ConvertBoolDB(_UserAccess.ChangePasswordInd));
Parameters[13] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebUserAccessMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
if (Descp.flag == 0)
{
//this.GenerateUserFolder(_UserAccess.UserId);
return(Descp);
}
else
{
return(Descp);
}
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveBusnLocationGeneralInfo(MerchantDetails merch)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[41];
Parameters[0] = new SqlParameter("@Func", GetIssNo);
Parameters[1] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[2] = String.IsNullOrEmpty(merch.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", merch.AcctNo);
Parameters[3] = String.IsNullOrEmpty(merch.BusnLoc) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", merch.BusnLoc);
Parameters[4] = String.IsNullOrEmpty(merch.BusinessName) ? new SqlParameter("@BusnName", DBNull.Value) : new SqlParameter("@BusnName", merch.BusinessName);
Parameters[5] = String.IsNullOrEmpty(merch.SiteId) ? new SqlParameter("@SiteId", DBNull.Value) : new SqlParameter("@SiteId", merch.SiteId);
Parameters[6] = String.IsNullOrEmpty(merch.AgreementNo) ? new SqlParameter("@AgreeNo", DBNull.Value) : new SqlParameter("@AgreeNo", merch.AgreementNo);
Parameters[7] = new SqlParameter("@AgreeDate", BaseClass.DateConverterDB(merch.AgreementDate));
Parameters[8] = String.IsNullOrEmpty(merch.PersonInCharge) ? new SqlParameter("@PersonInChrg", DBNull.Value) : new SqlParameter("@PersonInChrg", merch.PersonInCharge);
Parameters[9] = String.IsNullOrEmpty(merch.selectedOwnershsip) ? new SqlParameter("@Ownership", DBNull.Value) : new SqlParameter("@Ownership", merch.selectedOwnershsip);
Parameters[10] = String.IsNullOrEmpty(merch.BusnSize) ? new SqlParameter("@Establishment", DBNull.Value) : new SqlParameter("@Establishment", merch.BusnSize);
Parameters[11] = String.IsNullOrEmpty(merch.SelectedSIC) ? new SqlParameter("@Sic", DBNull.Value) : new SqlParameter("@Sic", merch.SelectedSIC);
Parameters[12] = String.IsNullOrEmpty(merch.MCC) ? new SqlParameter("@Mcc", DBNull.Value) : new SqlParameter("@Mcc", merch.MCC);
Parameters[13] = String.IsNullOrEmpty(merch.CoRegNo) ? new SqlParameter("@CoRegNo", DBNull.Value) : new SqlParameter("@CoRegNo", merch.CoRegNo);
Parameters[14] = String.IsNullOrEmpty(merch.CoRegName) ? new SqlParameter("@CoRegName", DBNull.Value) : new SqlParameter("@CoRegName", merch.CoRegName);
Parameters[15] = new SqlParameter("@CoRegDate", BaseClass.DateConverterDB(merch.CoRegDate));
Parameters[16] = new SqlParameter("@OwnershipTrsfDate", BaseClass.DateConverterDB(merch.OwnershipTrsfDate));
Parameters[17] = String.IsNullOrEmpty(merch.OwnershipTo) ? new SqlParameter("@OwnershipTo", DBNull.Value) : new SqlParameter("@OwnershipTo", merch.OwnershipTo);
Parameters[18] = String.IsNullOrEmpty(merch.DBAName) ? new SqlParameter("@DBAName", DBNull.Value) : new SqlParameter("@DBAName", merch.DBAName);
Parameters[19] = String.IsNullOrEmpty(merch.SelectDBARegion) ? new SqlParameter("@DBARegion", DBNull.Value) : new SqlParameter("@DBARegion", merch.SelectDBARegion);
Parameters[20] = String.IsNullOrEmpty(merch.SelectDBACity) ? new SqlParameter("@DBACity", DBNull.Value) : new SqlParameter("@DBACity", merch.SelectDBACity);
Parameters[21] = String.IsNullOrEmpty(merch.SelectDBAState) ? new SqlParameter("@DBAState", DBNull.Value) : new SqlParameter("@DBAState", merch.SelectDBAState);
Parameters[22] = String.IsNullOrEmpty(merch.PayeeName) ? new SqlParameter("@PayeeName", DBNull.Value) : new SqlParameter("@PayeeName", merch.PayeeName);
Parameters[23] = new SqlParameter("@AutoDebit", BaseClass.ConvertBoolDB(merch.AutoDebitInd));
Parameters[24] = String.IsNullOrEmpty(merch.BankAcctName) ? new SqlParameter("@BankName", DBNull.Value) : new SqlParameter("@BankName", merch.BankAcctName);
Parameters[25] = String.IsNullOrEmpty(merch.selectedBankAcctType) ? new SqlParameter("@BankAcctType", DBNull.Value) : new SqlParameter("@BankAcctType", merch.selectedBankAcctType);
Parameters[26] = String.IsNullOrEmpty(merch.BankAccountNo) ? new SqlParameter("@BankAcctNo", DBNull.Value) : new SqlParameter("@BankAcctNo", merch.BankAccountNo);
Parameters[27] = String.IsNullOrEmpty(merch.SelectedBankBranchCode) ? new SqlParameter("@BankBranchCd", DBNull.Value) : new SqlParameter("@BankBranchCd", merch.SelectedBankBranchCode);
Parameters[28] = String.IsNullOrEmpty(merch.selectedCurrentStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", merch.selectedCurrentStatus);
Parameters[29] = String.IsNullOrEmpty(merch.EntityId) ? new SqlParameter("@EntityId", DBNull.Value) : new SqlParameter("@EntityId", merch.EntityId);
Parameters[30] = String.IsNullOrEmpty(merch.TaxId) ? new SqlParameter("@TaxId", DBNull.Value) : new SqlParameter("@TaxId", merch.TaxId);
Parameters[31] = new SqlParameter("@WithholdInd", BaseClass.ConvertBoolDB(merch.WithholdingTaxInd));
Parameters[32] = String.IsNullOrEmpty(merch.WithholdingTaxRate) ? new SqlParameter("@WithholdRate", DBNull.Value) : new SqlParameter("@WithholdRate", merch.WithholdingTaxRate);
Parameters[33] = String.IsNullOrEmpty(merch.SelectedcycNo) ? new SqlParameter("@CycNo", DBNull.Value) : new SqlParameter("@CycNo", merch.SelectedcycNo);
Parameters[34] = new SqlParameter("@UserId", this.GetUserId);
Parameters[35] = new SqlParameter("@CreationDate", BaseClass.DateConverterDB(merch.CreationDate));
Parameters[36] = String.IsNullOrEmpty(merch.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", merch.SelectedReasonCode);
Parameters[37] = new SqlParameter("@StmtPrint", BaseClass.ConvertBoolDB(merch.StmtPrintInd));
Parameters[38] = new SqlParameter("@oBusnLocation", SqlDbType.VarChar, 20);
Parameters[38].Direction = ParameterDirection.Output;
Parameters[39] = new SqlParameter("@oEntityId", SqlDbType.VarChar, 20);
Parameters[39].Direction = ParameterDirection.Output;
Parameters[40] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[40].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebBusnLocationGeneralInfoMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.EntityId = Convert.ToString(Cmd.Parameters["@oEntityId"].Value);
this.BusnLoc = Convert.ToString(Cmd.Parameters["@oBusnLocation"].Value);
var Descp = GetMessageCode(Result);
objDataEngine.CloseConnection();
return(await Descp);
}