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);
}
public async Task <List <TerminalInventory> > TermInventorySelect(TerminalInventory _TerminalInventory)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@TermId", String.IsNullOrEmpty(_TerminalInventory.TerminalId) ? "" : _TerminalInventory.TerminalId);
Parameters[1] = new SqlParameter("@RefCd", string.IsNullOrEmpty(_TerminalInventory.SelectedTerminalType) ? "" : _TerminalInventory.SelectedTerminalType);
var execResult = objDataEngine.ExecuteCommand("WebTermInventorySelect", CommandType.StoredProcedure, Parameters);
var _TermInventory = new List <TerminalInventory>();
while (execResult.Read())
{
_TermInventory.Add(new TerminalInventory
{
TerminalId = Convert.ToString(execResult["termid"]),
TerminalType = await BaseClass.WebGetRefLib("TermSts"),
SelectedTerminalType = Convert.ToString(execResult["TermType"]),
Status = await BaseClass.WebGetRefLib("TermSts"),
SelectedStatus = Convert.ToString(execResult["sts"]),
UserId = Convert.ToString(execResult["UserId"]),
Description = Convert.ToString(execResult["Description"]),
Printer = Convert.ToString(execResult["PrinterId"]),
PinPad = Convert.ToString(execResult["PinPad"]),
CreationDate = DateConverter(execResult["creationdate"])
});
}
objDataEngine.CloseConnection();
return(_TermInventory);
}
public async Task <BusnLocTerminal> GetBusnLocTermDetail(string TermId, string BusnLocation)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
Parameters[2] = String.IsNullOrEmpty(TermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", TermId);
var execResult = objDataEngine.ExecuteCommand("WebBusnLocationTerminalSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _BusnLocTermDetail = new BusnLocTerminal
{
TermId = Convert.ToString(execResult["TermId"]),
SelectedTermType = Convert.ToString(execResult["TermType"]),
SelectedStatus = Convert.ToString(execResult["Sts"]),
DeployDate = DateConverter(execResult["DeployDate"]),
SaleTerritory = Convert.ToString(execResult["SaleTerritory"]),
Replacement = Convert.ToString(execResult["ReplacedByTermId"]),
ReplacedDate = DateConverter(execResult["ReplacedDate"]),
ReasonCd = await BaseClass.WebGetRefLib("TermReasonCd"),
SelectedReasonCode = Convert.ToString(execResult["ReasonCd"]),
IPEK = Convert.ToString(execResult["IPEK"]),
SettlementStart = DateConverter(execResult["SettleFromTime"]),
SettlementEnd = DateConverter(execResult["SettleToTime"]),
LastBatchId = ConvertInt(execResult["LastBatchId"]),
SettleTxnId = ConvertInt(execResult["SettleTxnId"]),
SelectedProdType = Convert.ToString(execResult["DeviceModel"]),
SerialNo = Convert.ToString(execResult["SerialNo"]),
Remarks = Convert.ToString(execResult["Remarks"]),
CreationDate = DateConverter(execResult["CreationDate"]),
UserId = Convert.ToString(execResult["UserId"]),
LastUpdDate = DateConverter(execResult["LastUpdDate"]),
};
objDataEngine.CloseConnection();
return(_BusnLocTermDetail);
}
;
objDataEngine.CloseConnection();
return(new BusnLocTerminal());
}
public async Task <ManualSlipEntry> GetManualSlipEntryBatchDetail(string SettleId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(SettleId) ? new SqlParameter("@SettleId", DBNull.Value) : new SqlParameter("@SettleId", SettleId);
var execResult = objDataEngine.ExecuteCommand("WebMerchManualBatchSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _ManualSlipEntryBatDetail = new ManualSlipEntry
{
BusnLocation = Convert.ToString(execResult["Dealer"]), //
SelectedTermId = Convert.ToString(execResult["TermId"]), //
SiteId = Convert.ToString(execResult["SiteId"]),
SettleId = Convert.ToString(execResult["Settle Id"]),
BatchId = Convert.ToString(execResult["BatchId"]),//
SelectedTxnCd = ConvertInt(execResult["TxnCd"]),
InvoiceNo = ConvertInt(execResult["InvoiceNo"]), //
SettleDate = DateConverter(execResult["SettleDate"]), //
TotalCnt = ConvertInt(execResult["Cnt"]), //
DisplayTotalAmt = ConverterDecimal(execResult["Amt"]), //
Descp = Convert.ToString(execResult["Descp"]),
OrigBatchNo = ConvertInt(execResult["OrigBatchNo"]),
Sts = await BaseClass.WebGetRefLib("MerchBatchSts"),
SelectedSts = Convert.ToString(execResult["Sts"]),
};
return(_ManualSlipEntryBatDetail);
}
;
return(new ManualSlipEntry());
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <SAP_GeneralInfo> SAPGetGeneralInfo(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("WebSAPGeneralInfoSelect", CommandType.StoredProcedure, Parameters);
var _SAP = new SAP_GeneralInfo();
while (execResult.Read())
{
_SAP.CompanyCd = Convert.ToString(execResult["CmpyCd"]);
_SAP.ReconAccountNo = Convert.ToString(execResult["ReconAcctNo"]);
_SAP.selectedDistributionChannel = Convert.ToString(execResult["DistChannel"]);
_SAP.DistributionChannel = await BaseClass.WebGetRefLib("City");
_SAP.SelectedDivision = Convert.ToString(execResult["Division"]);
_SAP.Division = await BaseClass.WebGetRefLib("City");
_SAP.selectedSalesOrganisation = Convert.ToString(execResult["SalesOrganization"]);
_SAP.SalesOrganization = await BaseClass.WebGetRefLib("City");
_SAP.selectedCustomerClass = Convert.ToString(execResult["CustomerClass"]);
_SAP.CustoemrClass = await BaseClass.WebGetRefLib("City");
_SAP.AuthCd = Convert.ToString(execResult["Authorization"]);
_SAP.SearchName = Convert.ToString(execResult["SearchTerm1"]);
_SAP.SortKey = Convert.ToString(execResult["SortKey"]);
_SAP.Location = Convert.ToString(execResult["Location"]);
_SAP.SelectedCountryCd = Convert.ToString(execResult["CountryCd"]);
_SAP.CountryCd = await BaseClass.WebGetRefLib("City");
_SAP.CurrencyCd = await BaseClass.WebGetRefLib("City");
_SAP.SelectedCurrencyCd = Convert.ToString(execResult["CurrencyCd"]);
_SAP.SelectedCashManagementGroup = Convert.ToString(execResult["CashMgmtGroup"]);
_SAP.CashManagementGroup = await BaseClass.WebGetRefLib("City");
}
objDataEngine.CloseConnection();
return(_SAP);
}
public async Task <UserAccess> GetUserAccessDetail(string AccessInd, string UserId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@AccessInd", String.IsNullOrEmpty(AccessInd) ? "" : AccessInd);
Parameters[2] = new SqlParameter("@UserId", String.IsNullOrEmpty(UserId) ? "" : UserId);
var execResult = objDataEngine.ExecuteCommand("WebUserAccessSelect", CommandType.StoredProcedure, Parameters);
var _UserAccess = new UserAccess();
while (execResult.Read())
{
_UserAccess.AccessInd = await BaseClass.WebGetRefLib("AccessInd");
_UserAccess.UserId = Convert.ToString(execResult["UserId"]);
_UserAccess.MapUserId = await WebGetMap();
//_UserAccess.SelectedMapUserId = Convert.ToString(execResult["MapUser"]);
_UserAccess.Name = Convert.ToString(execResult["Name"]);
_UserAccess.Sts = await WebGetRefLib("UserSts");
_UserAccess.selectedSts = Convert.ToString(execResult["Sts"]);
_UserAccess.ContactNo = Convert.ToString(execResult["ContactNo"]);
_UserAccess.EmailAddr = Convert.ToString(execResult["EmailAddr"]);
_UserAccess.Title = await WebGetRefLib("Title");
_UserAccess.SeletedTitle = Convert.ToString(execResult["Title"]);
_UserAccess.SelectedDeptId = Convert.ToString(execResult["DeptId"]);
_UserAccess.PrivilegeCd = Convert.ToString(execResult["PrivilegeCd"]);
_UserAccess.LastLogin = Convert.ToString(execResult["LastLogin"]);
_UserAccess.CreationDate = Convert.ToString(execResult["CreationDate"]);
}
;
objDataEngine.CloseConnection();
return(_UserAccess);
}
public async Task <SAP> SAPGetAccount(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("WebSAPAcctSelect", CommandType.StoredProcedure, Parameters);
var _SAPAccount = new SAP();
while (execResult.Read())
{
_SAPAccount.Id = Convert.ToString(execResult["Id"]);
_SAPAccount.SapNo = Convert.ToString(execResult["SAPNo"]);
_SAPAccount.SourceRefNo = Convert.ToString(execResult["SourceRefNo"]);
_SAPAccount.RefKey = Convert.ToString(execResult["RefKey"]);
_SAPAccount.RefTo = Convert.ToString(execResult["RefTo"]);
_SAPAccount.AccountName = Convert.ToString(execResult["AccountName"]);
_SAPAccount.SelectedAccountGroup = Convert.ToString(execResult["AccountGroup"]);
_SAPAccount.TaxId = Convert.ToString(execResult["TaxId"]);
_SAPAccount.SelectedWithHoldingTax = Convert.ToString(execResult["WithholdingTax"]);
_SAPAccount.PayeeName = Convert.ToString(execResult["PayeeName"]);
_SAPAccount.SelectedPayeeCd = Convert.ToString(execResult["PayeeCd"]);
_SAPAccount.OldRefKey = Convert.ToString(execResult["OldRefKey"]);
_SAPAccount.Remarks = Convert.ToString(execResult["Remarks"]);
_SAPAccount.CreatedBy = Convert.ToString(execResult["CreatedBy"]);
_SAPAccount.CreationDate = Convert.ToString(execResult["CreationDate"]);
_SAPAccount.UserId = Convert.ToString(execResult["UserId"]);
_SAPAccount.LastUpdate = Convert.ToString(execResult["LastUpdateDate"]);
_SAPAccount.AccountGroup = await BaseClass.WebGetRefLib("City");
_SAPAccount.PayeeCd = await BaseClass.WebGetRefLib("City");
_SAPAccount.WithHoldingTax = await BaseClass.WebGetRefLib("City");
}
objDataEngine.CloseConnection();
return(_SAPAccount);
}
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);
}
public async Task <SAP_SalesTerritory> SAPSalesTerritory(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("WebSAPSalesTerritorySelect", CommandType.StoredProcedure, Parameters);
var _SAP = new SAP_SalesTerritory();
while (execResult.Read())
{
_SAP.SelectedSalesTerritoryCd = Convert.ToString(execResult["SalesTerritoryCd"]);
_SAP.SalesTerritoryCd = await BaseClass.WebGetRefLib("City");
_SAP.CustomerPricingProc = Convert.ToString(execResult["CustPricingProc"]);
_SAP.SelectedCustoemrStatsGroup = Convert.ToString(execResult["CustStatisticGroup"]);
_SAP.CustomerStatsGroup = await BaseClass.WebGetRefLib("City");
_SAP.SelectedSalesDistrict = Convert.ToString(execResult["CustStatisticGroup"]);
_SAP.SalesDistrict = await BaseClass.WebGetRefLib("City");
_SAP.SalesOfficer = Convert.ToString(execResult["SalesOfficer"]);
_SAP.SelectedSalesGroup = Convert.ToString(execResult["SalesGroup"]);
_SAP.SalesGroup = await BaseClass.WebGetRefLib("City");
_SAP.ShippingConditions = Convert.ToString(execResult["ShippingCondition"]);
_SAP.MaxPartialDelivery = Convert.ToString(execResult["MaxPartialDelivery"]);
_SAP.SelectedTaxClass = Convert.ToString(execResult["TaxClass"]);
_SAP.TaxClass = await BaseClass.WebGetRefLib("City");
_SAP.OrderCombiation = Convert.ToString(execResult["OrderCombination"]);
}
return(_SAP);
}
public async Task <MerchantDetails> GetBusinessLocationGeneralInfoDetail(string acctNo, string BusnLocation)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
var Reader = objDataEngine.ExecuteCommand("WebBusnLocationGeneralInfoSelect", CommandType.StoredProcedure, Parameters);
while (Reader.Read())
{
var _BusinessLocation = new MerchantDetails
{
BusinessName = Convert.ToString(Reader["BusnName"]),
AgreementNo = Convert.ToString(Reader["AgreementNo"]),
AgreementDate = BaseClass.DateConverter(Reader["AgreementDate"]),
PersonInCharge = Convert.ToString(Reader["PersonInCharge"]),
Ownership = await BaseClass.WebGetRefLib("MerchOwnership"),
selectedOwnershsip = Convert.ToString(Reader["Ownership"]),
BusnSize = Convert.ToString(Reader["Establishment"]),
SIC = await BaseClass.WebGetMerchType("S"),
SelectedSIC = Convert.ToString(Reader["Sic"]),
MCC = Convert.ToString(Reader["Mcc"]),
CoRegNo = Convert.ToString(Reader["CoRegNo"]),
CoRegName = Convert.ToString(Reader["CoRegName"]),
CoRegDate = BaseClass.DateConverter(Reader["CoRegDate"]),
OwnershipTrsfDate = Convert.ToString(Reader["OwnershipTrsfDate"]),
OwnershipTo = Convert.ToString(Reader["OwnershipTo"]),
DBAName = Convert.ToString(Reader["DBAName"]),
DBARegion = await BaseClass.WebGetRefLib("RegionCd"),
SelectDBARegion = Convert.ToString(Reader["DBARegion"]),
DBACity = await BaseClass.WebGetRefLib("City"),
SelectDBACity = Convert.ToString(Reader["DBACity"]),
DBAState = await BaseClass.WebGetState(GetIssNo, null),
SelectDBAState = Convert.ToString(Reader["DBAState"]),
PayeeName = Convert.ToString(Reader["PayeeName"]),
AutoDebitInd = BaseClass.BoolConverter(Reader["AutoDebitInd"]),
BankAcctName = Convert.ToString(Reader["BankName"]),
BankAcctType = await BaseClass.WebGetRefLib("BankAcctType"),
selectedBankAcctType = Convert.ToString(Reader["BankAcctType"]),
BankAccountNo = Convert.ToString(Reader["BankAcctNo"]),
BankBranchCode = await BaseClass.WebGetRefLib("BranchCd"),
SelectedBankBranchCode = Convert.ToString(Reader["BankBranchCd"]),
CurrentStatus = await BaseClass.WebGetRefLib("MerchAcctSts"),
selectedCurrentStatus = Convert.ToString(Reader["Sts"]),
EntityId = Convert.ToString(Reader["EntityId"]),
WithholdingTaxInd = BaseClass.BoolConverter(Reader["WithholdingTaxInd"]),
WithholdingTaxRate = Convert.ToString(Reader["WithholdingTaxRate"]),
cycNo = await BaseClass.WebGetCycle("A"),
SelectedcycNo = Convert.ToString(Reader["CycNo"]),
UserID = Convert.ToString(Reader["UserId"]),
CreationDate = BaseClass.DateConverter(Reader["CreationDate"]),
ReasonCd = await BaseClass.WebGetRefLib("MerchReasonCd"),
SelectedReasonCode = Convert.ToString(Reader["ReasonCd"]),
StmtPrintInd = BaseClass.BoolConverter(Reader["StmtPrint"]),
SiteId = Convert.ToString(Reader["ReconAcct"]),
BusnLoc = Convert.ToString(Reader["BusnLocation"]),
//PaymentTerms=Convert.ToString(Reader["PaymentTrms"]),
// TaxCategory =Convert.ToString(Reader["TaxCode"])
};
objDataEngine.CloseConnection();
return(_BusinessLocation);
}
;
return(new MerchantDetails());
}