public async Task <MsgRetriever> SaveBusnLocTerm(BusnLocTerminal _BusnLocTerminal)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[16];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(_BusnLocTerminal.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", _BusnLocTerminal.BusnLocation);
Parameters[2] = String.IsNullOrEmpty(_BusnLocTerminal.TermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", _BusnLocTerminal.TermId);
Parameters[3] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _BusnLocTerminal.SelectedStatus);
Parameters[4] = String.IsNullOrEmpty(_BusnLocTerminal.DeployDate) ? new SqlParameter("@DeployDate", DBNull.Value) : new SqlParameter("@DeployDate", ConvertDatetimeDB(_BusnLocTerminal.DeployDate));
Parameters[5] = String.IsNullOrEmpty(_BusnLocTerminal.SaleTerritory) ? new SqlParameter("@SaleTerritory", DBNull.Value) : new SqlParameter("@SaleTerritory", _BusnLocTerminal.SaleTerritory);
Parameters[6] = String.IsNullOrEmpty(_BusnLocTerminal.Replacement) ? new SqlParameter("@ReplacedByTermId", DBNull.Value) : new SqlParameter("@ReplacedByTermId", _BusnLocTerminal.Replacement);
Parameters[7] = String.IsNullOrEmpty(_BusnLocTerminal.ReplacedDate) ? new SqlParameter("@ReplacedDate", DBNull.Value) : new SqlParameter("@ReplacedDate", ConvertDatetimeDB(_BusnLocTerminal.ReplacedDate));
Parameters[8] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", _BusnLocTerminal.SelectedReasonCode);
Parameters[9] = String.IsNullOrEmpty(_BusnLocTerminal.IPEK) ? new SqlParameter("@IPEK", DBNull.Value) : new SqlParameter("@IPEK", _BusnLocTerminal.IPEK);
Parameters[10] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedProdType) ? new SqlParameter("@DeviceModel", DBNull.Value) : new SqlParameter("@DeviceModel", _BusnLocTerminal.SelectedProdType);
Parameters[11] = String.IsNullOrEmpty(_BusnLocTerminal.SerialNo) ? new SqlParameter("@SerialNo", DBNull.Value) : new SqlParameter("@SerialNo", _BusnLocTerminal.SerialNo);
Parameters[12] = String.IsNullOrEmpty(_BusnLocTerminal.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _BusnLocTerminal.Remarks);
Parameters[13] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedTermType) ? new SqlParameter("@TermType", DBNull.Value) : new SqlParameter("@TermType", _BusnLocTerminal.SelectedTermType);
Parameters[14] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[15].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebBusnLocationTerminalMaint", 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> WebReloadFundMaint(PurchaseOrder _Order, string Func)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[12];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_Order.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _Order.Remarks);
Parameters[2] = String.IsNullOrEmpty(_Order.DocNo) ? new SqlParameter("@DocNo", DBNull.Value) : new SqlParameter("@DocNo", _Order.DocNo);
Parameters[3] = new SqlParameter("@AcctNo", _Order.AcctNo);
Parameters[4] = new SqlParameter("@Func", Func);
Parameters[5] = new SqlParameter("@TxnDate", ConvertDatetimeDB(_Order.TxnDate));
Parameters[6] = new SqlParameter("@UserId", this.GetUserId);
Parameters[7] = new SqlParameter("@CreatedBy", this.GetUserId);
Parameters[8] = Func.ToLower() == "n" ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", ConvertIntToDb(_Order.TxnId));
Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[9].Direction = ParameterDirection.ReturnValue;
Parameters[10] = new SqlParameter("@TxnAmt", ConvertDecimalToDb(_Order.TxnAmt));
Parameters[11] = String.IsNullOrEmpty(_Order.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _Order.SelectedStatus);
var Cmd = objDataEngine.ExecuteWithReturnValue("WebReloadFundMaint", 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> WebSAPSalesTerritoryMaint(SAP_SalesTerritory _SAP, string SapNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[11];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo);
Parameters[1] = String.IsNullOrEmpty(_SAP.SelectedSalesTerritoryCd) ? new SqlParameter("@SalesTerritoryCd", DBNull.Value) : new SqlParameter("@SalesTerritoryCd", _SAP.SelectedSalesTerritoryCd);
Parameters[2] = String.IsNullOrEmpty(_SAP.CustomerPricingProc) ? new SqlParameter("@CustPricingProc", DBNull.Value) : new SqlParameter("@CustPricingProc", _SAP.CustomerPricingProc);
Parameters[3] = String.IsNullOrEmpty(_SAP.SelectedCustoemrStatsGroup) ? new SqlParameter("@CustStatisticGroup", DBNull.Value) : new SqlParameter("@CustStatisticGroup", _SAP.SelectedCustoemrStatsGroup);
Parameters[4] = String.IsNullOrEmpty(_SAP.SelectedSalesDistrict) ? new SqlParameter("@SalesDistrict", DBNull.Value) : new SqlParameter("@SalesDistrict", _SAP.SelectedSalesDistrict);
Parameters[5] = String.IsNullOrEmpty(_SAP.SalesOfficer) ? new SqlParameter("@SalesOffice", DBNull.Value) : new SqlParameter("@SalesOffice", _SAP.SalesOfficer);
Parameters[6] = String.IsNullOrEmpty(_SAP.ShippingConditions) ? new SqlParameter("@ShippingCondition", DBNull.Value) : new SqlParameter("@ShippingCondition", _SAP.ShippingConditions);
Parameters[7] = String.IsNullOrEmpty(_SAP.MaxPartialDelivery) ? new SqlParameter("@MaxPartialDelivery", DBNull.Value) : new SqlParameter("@MaxPartialDelivery", _SAP.MaxPartialDelivery);
Parameters[8] = String.IsNullOrEmpty(_SAP.OrderCombiation) ? new SqlParameter("@OrderCombination", DBNull.Value) : new SqlParameter("@OrderCombination", _SAP.OrderCombiation);
Parameters[9] = String.IsNullOrEmpty(_SAP.SelectedTaxClass) ? new SqlParameter("@TaxClass", DBNull.Value) : new SqlParameter("@TaxClass", _SAP.SelectedTaxClass);
Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPSalesTerritoryMaint]", 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> RecoverInternalPassword(string userId)
{
var Email = IsValid(userId);
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
SqlCommand cmd = new SqlCommand();
if (Email)
{
Parameters[0] = new SqlParameter("@UserId", DBNull.Value);
Parameters[1] = new SqlParameter("@Email", userId);
}
else
{
Parameters[0] = new SqlParameter("@UserId", userId);
Parameters[1] = new SqlParameter("@Email", DBNull.Value);
}
Parameters[2] = new SqlParameter("@RETURN_VALUE", SqlDbType.TinyInt);
Parameters[2].Direction = ParameterDirection.ReturnValue;
// Parameters[10] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
var Cmd = objDataEngine.ExecuteWithReturnValue("WebInternalForgetPassMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
objDataEngine.CloseConnection();
return(Descp);
}
public async Task <MsgRetriever> WebNegativeUnlockMaint(List <string> RefKey, string RefTo, string Func)
{
var Dt = new DataTable();
Dt.Columns.Add("refKey");
foreach (var item in RefKey)
{
var dr = Dt.NewRow();
dr["RefKey"] = item;
Dt.Rows.Add(dr);
}
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[6];
Parameters[0] = new SqlParameter("@Func", Func);
Parameters[1] = new SqlParameter("@IssNo", GetIssNo);
Parameters[2] = String.IsNullOrEmpty(RefTo) ? new SqlParameter("@RefTo", DBNull.Value) : new SqlParameter("@RefTo", RefTo);
Parameters[3] = new SqlParameter("@RefKey", Dt);
Parameters[4] = new SqlParameter("@UserId", this.GetUserId);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebNegativeUnlockMaint", 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> 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> SaveMerchManualTxnProduct(ManualSlipEntry _ManualTxnProduct)
* {
* var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
*
* try
* {
* objDataEngine.InitiateConnection();
* SqlParameter[] Parameters = new SqlParameter[14];
* Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
* Parameters[1] = string.IsNullOrEmpty(_ManualTxnProduct.SettleId) ? new SqlParameter("@SettleId", DBNull.Value) : new SqlParameter("@SettleId", _ManualTxnProduct.SettleId);
* Parameters[2] = string.IsNullOrEmpty(_ManualTxnProduct.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _ManualTxnProduct.TxnId);
* Parameters[3] = string.IsNullOrEmpty(_ManualTxnProduct.TxnDetailId) ? new SqlParameter("@TxnDetailId", DBNull.Value) : new SqlParameter("@TxnDetailId", _ManualTxnProduct.TxnDetailId);
* Parameters[4] = string.IsNullOrEmpty(_ManualTxnProduct.SelectedProdCd) ? new SqlParameter("@ProdCd", DBNull.Value) : new SqlParameter("@ProdCd", _ManualTxnProduct.SelectedProdCd.Split('-').First());
* Parameters[5] = new SqlParameter("@Qty", ConvertDecimalToDb(_ManualTxnProduct.Quantity));
* Parameters[6] = new SqlParameter("@AmtPts", ConvertDecimalToDb(_ManualTxnProduct.ProdAmt));
* Parameters[7] = String.IsNullOrEmpty(_ManualTxnProduct.ProdDesc) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _ManualTxnProduct.ProdDesc);
* Parameters[8] = new SqlParameter("@UnitPrice", ConvertDecimalToDb(_ManualTxnProduct.UnitPrice));
* Parameters[9] = new SqlParameter("@UserId", this.GetUserId);
* Parameters[10] = String.IsNullOrEmpty(_ManualTxnProduct.VATAmt) ? new SqlParameter("@VATAmt", DBNull.Value) : new SqlParameter("@VATAmt", _ManualTxnProduct.VATAmt);
* Parameters[11] = String.IsNullOrEmpty(_ManualTxnProduct.SelectedVATCd) ? new SqlParameter("@VATCd", DBNull.Value) : new SqlParameter("@VATCd", _ManualTxnProduct.SelectedVATCd);
* Parameters[12] = new SqlParameter("@oTxnDetailId", SqlDbType.NVarChar, 19);
* Parameters[12].Direction = ParameterDirection.Output;
* Parameters[13] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
* Parameters[13].Direction = ParameterDirection.ReturnValue;
*
* var Cmd = objDataEngine.ExecuteWithReturnValue("WebMerchManualTxnDetailMaint", CommandType.StoredProcedure, Parameters);
* var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
* this.TxnDetailId = Convert.ToString(Cmd.Parameters["@oTxnDetailId"].Value);
*
* var Descp = await GetMessageCode(Result);
* return Descp;
* }
* finally
* {
* objDataEngine.CloseConnection();
* }
*
*
* }
*/
public async Task <MsgRetriever> MerchManualProductTxnDelete(ManualSlipEntry _TxnProduct)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[6];
Parameters[0] = new SqlParameter("@AcqNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnProduct.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _TxnProduct.BatchId);
Parameters[2] = String.IsNullOrEmpty(_TxnProduct.SettleId) ? new SqlParameter("@SettleId", DBNull.Value) : new SqlParameter("@SettleId", _TxnProduct.SettleId);
Parameters[3] = String.IsNullOrEmpty(_TxnProduct.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnProduct.TxnId);
Parameters[4] = String.IsNullOrEmpty(_TxnProduct.TxnDetailId) ? new SqlParameter("@DetailTxnId", DBNull.Value) : new SqlParameter("@DetailTxnId", _TxnProduct.TxnDetailId);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebMerchManualTxnDelete", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public string SaveUserPasswordConfirm(forgetPassword _UserPassConfirm)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[6];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_UserPassConfirm.EmailAddr) ? new SqlParameter("@EmailAddr", DBNull.Value) : new SqlParameter("@EmailAddr", _UserPassConfirm.EmailAddr);
Parameters[2] = String.IsNullOrEmpty(_UserPassConfirm.password) ? new SqlParameter("@Pw", DBNull.Value) : new SqlParameter("@Pw", _UserPassConfirm.password);
Parameters[3] = String.IsNullOrEmpty(_UserPassConfirm.secureCd) ? new SqlParameter("@SecureCd", DBNull.Value) : new SqlParameter("@SecureCd", _UserPassConfirm.secureCd);
Parameters[4] = String.IsNullOrEmpty(_UserPassConfirm.IpAddr) ? new SqlParameter("@IPAddr", DBNull.Value) : new SqlParameter("@IPAddr", _UserPassConfirm.IpAddr);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebUserAccessPwMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToString(Cmd.Parameters["@RETURN_VALUE"].Value);
return(Result);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebReloadAllocDetailMaint(PrepaidCardnAcct _PrepaidCardnAcct, int ParentTxnId, string func, string AcctNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[14];
Parameters[0] = String.IsNullOrEmpty(_PrepaidCardnAcct.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _PrepaidCardnAcct.CardNo);
Parameters[1] = String.IsNullOrEmpty(_PrepaidCardnAcct.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _PrepaidCardnAcct.AcctNo);
Parameters[2] = String.IsNullOrEmpty(_PrepaidCardnAcct.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _PrepaidCardnAcct.SelectedStatus);
Parameters[3] = String.IsNullOrEmpty(_PrepaidCardnAcct.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _PrepaidCardnAcct.Remarks);
Parameters[4] = String.IsNullOrEmpty(_PrepaidCardnAcct.TxnDate) ? new SqlParameter("@TxnDate", DBNull.Value) : new SqlParameter("@TxnDate", ConvertDatetimeDB(_PrepaidCardnAcct.TxnDate));
Parameters[5] = String.IsNullOrEmpty(_PrepaidCardnAcct.TxnAmt) ? new SqlParameter("@TxnAmt", DBNull.Value) : new SqlParameter("@TxnAmt", ConverterDecimal(_PrepaidCardnAcct.TxnAmt));
Parameters[6] = new SqlParameter("@UserId", this.GetUserId);
Parameters[7] = func.ToLower() == "n" ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", ConvertIntToDb(_PrepaidCardnAcct.TxnId));
Parameters[8] = new SqlParameter("@ParentTxnId", ParentTxnId);
Parameters[9] = new SqlParameter("@Func", func);
Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.ReturnValue;
Parameters[11] = new SqlParameter("@IssNo", GetIssNo);
Parameters[12] = String.IsNullOrEmpty(_PrepaidCardnAcct.EffDateFrom) ? new SqlParameter("@EffDateFrom", DBNull.Value) : new SqlParameter("@EffDateFrom", ConvertDatetimeDB(_PrepaidCardnAcct.EffDateFrom));
Parameters[13] = new SqlParameter("@CreatedBy", this.GetUserId);
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebReloadAllocDetailMaint]", 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> SaveWebUserAccessMapping(UserAccess _userAccess, bool isUpdate = true)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[10];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@UserId", _userAccess.UserId);
Parameters[2] = String.IsNullOrEmpty(_userAccess.SelectedMapUserId) ? new SqlParameter("@MapUserId", DBNull.Value) : new SqlParameter("@MapUserId", _userAccess.SelectedMapUserId);
Parameters[3] = String.IsNullOrEmpty(_userAccess.Name) ? new SqlParameter("@ContactName", DBNull.Value) : new SqlParameter("@ContactName", _userAccess.Name);
Parameters[4] = String.IsNullOrEmpty(_userAccess.ContactNo) ? new SqlParameter("@ContactNo", DBNull.Value) : new SqlParameter("@ContactNo", _userAccess.ContactNo);
Parameters[5] = String.IsNullOrEmpty(_userAccess.SelectedDeptId) ? new SqlParameter("@DeptId", DBNull.Value) : new SqlParameter("@DeptId", _userAccess.SelectedDeptId);
Parameters[6] = String.IsNullOrEmpty(_userAccess.SelectedAccessInd) ? new SqlParameter("@AccessInd", DBNull.Value) : new SqlParameter("@AccessInd", _userAccess.SelectedAccessInd);
Parameters[7] = String.IsNullOrEmpty(_userAccess.EmailAddr) ? new SqlParameter("@EmailAddr", DBNull.Value) : new SqlParameter("@EmailAddr", _userAccess.EmailAddr);
Parameters[8] = String.IsNullOrEmpty(_userAccess.Password) ? new SqlParameter("@PwBlock", DBNull.Value) : new SqlParameter("@PwBlock", _userAccess.Password);
Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.TinyInt);
Parameters[9].Direction = ParameterDirection.ReturnValue;
// Parameters[10] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
var Cmd = objDataEngine.ExecuteWithReturnValue("WebUserAccessMapping", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveNonFleetTxn(NonFleetTxn _NonFleetTxn)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[10];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_NonFleetTxn.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _NonFleetTxn.TxnId);
Parameters[2] = String.IsNullOrEmpty(_NonFleetTxn.SelectedTxnCd) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _NonFleetTxn.SelectedTxnCd);
Parameters[3] = new SqlParameter("@TxnAmt", ConvertDecimalToDb(_NonFleetTxn.TotAmnt));
Parameters[4] = new SqlParameter("@TxnDate", DateConverterDB(_NonFleetTxn.TxnDate));
Parameters[5] = String.IsNullOrEmpty(_NonFleetTxn.SelectedAffiliate) ? new SqlParameter("@Affiliate", DBNull.Value) : new SqlParameter("@Affiliate", _NonFleetTxn.SelectedAffiliate);
Parameters[6] = String.IsNullOrEmpty(_NonFleetTxn.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _NonFleetTxn.Descp);
Parameters[7] = String.IsNullOrEmpty(_NonFleetTxn.remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _NonFleetTxn.remarks);
Parameters[8] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[9].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebNonFleetTxnMaint", CommandType.StoredProcedure, Parameters);
var Result = ConvertInt(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> DelNonFleetTxn(NonFleetTxn _NonFleetTxnDel)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[5];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_NonFleetTxnDel.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _NonFleetTxnDel.TxnId);
Parameters[2] = String.IsNullOrEmpty(_NonFleetTxnDel._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _NonFleetTxnDel._CardnAccNo.AccNo);
Parameters[3] = String.IsNullOrEmpty(_NonFleetTxnDel._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _NonFleetTxnDel._CardnAccNo.CardNo);
Parameters[4] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[4].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebTxnAdjustmentDelete", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
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> SaveManualSlipEntry(ManualSlipEntry _ManualSlipEntry)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[29];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = new SqlParameter("@TxnCd", ConvertIntToDb(_ManualSlipEntry.SelectedTxnCd));
Parameters[2] = String.IsNullOrEmpty(_ManualSlipEntry.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", _ManualSlipEntry.BusnLocation);
Parameters[3] = String.IsNullOrEmpty(_ManualSlipEntry.SelectedTermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", _ManualSlipEntry.SelectedTermId);
Parameters[4] = String.IsNullOrEmpty(_ManualSlipEntry.SiteId) ? new SqlParameter("@SiteId", DBNull.Value) : new SqlParameter("@SiteId", _ManualSlipEntry.SiteId);
Parameters[5] = String.IsNullOrEmpty(_ManualSlipEntry.SettleId) ? new SqlParameter("@SettleId", DBNull.Value) : new SqlParameter("@SettleId", _ManualSlipEntry.SettleId);
Parameters[6] = String.IsNullOrEmpty(_ManualSlipEntry.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _ManualSlipEntry.TxnId);
Parameters[7] = String.IsNullOrEmpty(_ManualSlipEntry.RcptNo) ? new SqlParameter("@RcptNo", DBNull.Value) : new SqlParameter("@RcptNo", _ManualSlipEntry.RcptNo);
Parameters[8] = new SqlParameter("@InvoiceNo", ConvertIntToDb(_ManualSlipEntry.InvoiceNo));
Parameters[9] = new SqlParameter("@Stan", ConvertLongToDb(_ManualSlipEntry.Stans));
Parameters[10] = String.IsNullOrEmpty(_ManualSlipEntry.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _ManualSlipEntry.CardNo);
Parameters[11] = String.IsNullOrEmpty(_ManualSlipEntry.CardExpire) ? new SqlParameter("@CardExp", DBNull.Value) : new SqlParameter("@CardExp", _ManualSlipEntry.CardExpire);
Parameters[12] = String.IsNullOrEmpty(_ManualSlipEntry.AuthCardNo) ? new SqlParameter("@AuthCardNo", DBNull.Value) : new SqlParameter("@AuthCardNo", _ManualSlipEntry.AuthCardNo);
Parameters[13] = String.IsNullOrEmpty(_ManualSlipEntry.AuthCardExp) ? new SqlParameter("@AuthCardExp", DBNull.Value) : new SqlParameter("@AuthCardExp", _ManualSlipEntry.AuthCardExp);
Parameters[14] = new SqlParameter("@DriverCd", ConvertIntToDb(_ManualSlipEntry.DriverCd));
Parameters[15] = new SqlParameter("@TxnDate", ConvertDatetimeDB(_ManualSlipEntry.TxnDate));
Parameters[16] = new SqlParameter("@ArrayCnt", ConvertIntToDb(_ManualSlipEntry.ArrayCnt));
Parameters[17] = new SqlParameter("@Qty", ConvertDecimalToDb(_ManualSlipEntry.Quantity));
Parameters[18] = new SqlParameter("@Amt", ConvertDecimalToDb(_ManualSlipEntry.DisplayTotalAmt));
Parameters[19] = String.IsNullOrEmpty(_ManualSlipEntry.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _ManualSlipEntry.Descp);
Parameters[20] = new SqlParameter("@Odometer", ConvertLongToDb(_ManualSlipEntry.Odometer));
Parameters[21] = new SqlParameter("@Rrn", ConvertLongToDb(_ManualSlipEntry.Rrn));//String.IsNullOrEmpty(_ManualSlipEntry.Rrn) ? new SqlParameter("@Rrn", DBNull.Value) :
Parameters[22] = String.IsNullOrEmpty(_ManualSlipEntry.AuthNo) ? new SqlParameter("@AuthNo", DBNull.Value) : new SqlParameter("@AuthNo", _ManualSlipEntry.AuthNo);
Parameters[23] = String.IsNullOrEmpty(_ManualSlipEntry.SelectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _ManualSlipEntry.SelectedSts);
Parameters[24] = new SqlParameter("@UserId", this.GetUserId);
Parameters[25] = String.IsNullOrEmpty(_ManualSlipEntry.VATNo) ? new SqlParameter("@VATNo", DBNull.Value) : new SqlParameter("@VATNo", _ManualSlipEntry.VATNo);
//Parameters[26] = String.IsNullOrEmpty(_ManualSlipEntry.AppvCd) ? new SqlParameter("@AuthNo", DBNull.Value) : new SqlParameter("@AuthNo", _ManualSlipEntry.AppvCd);
Parameters[26] = new SqlParameter("@oTxnId", SqlDbType.VarChar, 19);
Parameters[26].Direction = ParameterDirection.Output;
Parameters[27] = new SqlParameter("@oSettleId", SqlDbType.VarChar, 19);
Parameters[27].Direction = ParameterDirection.Output;
Parameters[28] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[28].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebMerchManualTxnMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.TxnId = Convert.ToString(Cmd.Parameters["@oTxnId"].Value);
this.SettleId = Convert.ToString(Cmd.Parameters["@oSettleId"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebManualTxnValidate(VoiceAuthEntryViewModel ViewModel, List <VoiceAuthProducts> list)
{
var dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("ProdCd");
dt.Columns.Add("Qty", typeof(decimal));
dt.Columns.Add("AmtPts", typeof(decimal));
dt.Columns.Add("FastTrack", typeof(decimal));
dt.Columns.Add("UnitPrice", typeof(decimal));
dt.Columns.Add("Seq", typeof(int));
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
var DrRow = dt.NewRow();
DrRow["Id"] = ConvertIntToDb(i + 1);
DrRow["ProdCd"] = list[i].SelectedProdCd;
DrRow["Qty"] = ConvertDecimalToDb(list[i].Qty);
DrRow["AmtPts"] = ConvertDecimalToDb(list[i].AmtPoints);
DrRow["FastTrack"] = ConvertDecimalToDb(list[i].FastTrack);
DrRow["UnitPrice"] = ConvertDecimalToDb(list[i].UnitPrice);
DrRow["Seq"] = ConvertIntToDb(i + 1);
dt.Rows.Add(DrRow);
}
}
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[10];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@AcqNo", "1");
Parameters[2] = String.IsNullOrEmpty(ViewModel._VoiceAuthDetail.SelectedTxnCd) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", ViewModel._VoiceAuthDetail.SelectedTxnCd);
Parameters[3] = String.IsNullOrEmpty(ViewModel._VoiceAuthDetail.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", ViewModel._VoiceAuthDetail.BusnLocation);
Parameters[4] = String.IsNullOrEmpty(ViewModel._VoiceAuthDetail.TxnAmt) ? new SqlParameter("@Amt", DBNull.Value) : new SqlParameter("@Amt", ConvertDecimalToDb(ViewModel._VoiceAuthDetail.TxnAmt));
Parameters[5] = String.IsNullOrEmpty(ViewModel._VoiceAuthDetail.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", ViewModel._VoiceAuthDetail.CardNo);
Parameters[6] = String.IsNullOrEmpty(ViewModel._VoiceAuthDetail.termId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", ViewModel._VoiceAuthDetail.termId);
Parameters[7] = new SqlParameter("@ProdDetail", dt);
//1 missing WebManualTxnValidate
Parameters[8] = new SqlParameter("@AuthNo", SqlDbType.VarChar, 19);
Parameters[8].Direction = ParameterDirection.Output;
Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[9].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebManualTxnValidate", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.AuthId = Convert.ToString(Cmd.Parameters["@AuthNo"].Value);
var Descp = GetMessageCode(Result);
objDataEngine.CloseConnection();
return(await Descp);
}
public string SaveUserLogin(Login _userpermit)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(_userpermit.AppUid) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", _userpermit.AppUid);
Parameters[1] = String.IsNullOrEmpty(_userpermit.Password) ? new SqlParameter("@Pw", DBNull.Value) : new SqlParameter("@Pw", _userpermit.Password);
Parameters[2] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[2].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebUserSignIn", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToString(Cmd.Parameters["@RETURN_VALUE"].Value);
objDataEngine.CloseConnection();
return(Result);
}
public async Task <MsgRetriever> WebSAPAcctMaint(SAP _SAP)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[17];
SqlCommand cmd = new SqlCommand();
Parameters[1] = String.IsNullOrEmpty(_SAP.SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", _SAP.SapNo);
Parameters[2] = String.IsNullOrEmpty(_SAP.SourceRefNo) ? new SqlParameter("@SourceRefNo", DBNull.Value) : new SqlParameter("@SourceRefNo", _SAP.SourceRefNo);
Parameters[3] = String.IsNullOrEmpty(_SAP.RefKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@RefKey", _SAP.RefKey);
Parameters[4] = String.IsNullOrEmpty(_SAP.RefTo) ? new SqlParameter("@RefTo", DBNull.Value) : new SqlParameter("@RefTo", _SAP.RefTo);
Parameters[5] = String.IsNullOrEmpty(_SAP.AccountName) ? new SqlParameter("@AcctName", DBNull.Value) : new SqlParameter("@AcctName", _SAP.AccountName);
Parameters[6] = String.IsNullOrEmpty(_SAP.SelectedAccountGroup) ? new SqlParameter("@AcctGroup", DBNull.Value) : new SqlParameter("@AcctGroup", _SAP.SelectedAccountGroup);
Parameters[7] = String.IsNullOrEmpty(_SAP.TaxId) ? new SqlParameter("@TaxId", DBNull.Value) : new SqlParameter("@TaxId", _SAP.TaxId);
Parameters[8] = String.IsNullOrEmpty(_SAP.SelectedWithHoldingTax) ? new SqlParameter("@Wht", DBNull.Value) : new SqlParameter("@Wht", _SAP.SelectedWithHoldingTax);
Parameters[9] = String.IsNullOrEmpty(_SAP.PayeeName) ? new SqlParameter("@PayeeName", DBNull.Value) : new SqlParameter("@PayeeName", _SAP.PayeeName);
Parameters[10] = String.IsNullOrEmpty(_SAP.SelectedPayeeCd) ? new SqlParameter("@PayeeCd", DBNull.Value) : new SqlParameter("@PayeeCd", _SAP.SelectedPayeeCd);
Parameters[11] = String.IsNullOrEmpty(_SAP.OldRefKey) ? new SqlParameter("@PrevRefKey", DBNull.Value) : new SqlParameter("@PrevRefKey", _SAP.OldRefKey);
Parameters[12] = String.IsNullOrEmpty(_SAP.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _SAP.Remarks);
Parameters[13] = String.IsNullOrEmpty(_SAP.CreatedBy) ? new SqlParameter("@CreatedBy", DBNull.Value) : new SqlParameter("@CreatedBy", _SAP.CreatedBy);
Parameters[14] = String.IsNullOrEmpty(_SAP.CreationDate) ? new SqlParameter("@CreationDate", DBNull.Value) : new SqlParameter("@CreationDate", BaseClass.ConvertDatetimeDB(_SAP.CreationDate));
Parameters[15] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[16] = new SqlParameter("@LastUpdDate", ConvertDatetimeDB(DateTime.Now.ToString()));
Parameters[0] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[0].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPAcctMaint]", 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> ResetInternalUserPassword(string Token, Login Login)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(Token) ? new SqlParameter("@Token", DBNull.Value) : new SqlParameter("@Token", Token);
Parameters[1] = String.IsNullOrEmpty(Login.Password) ? new SqlParameter("@NewPass", DBNull.Value) : new SqlParameter("@NewPass", Login.Password);
Parameters[2] = new SqlParameter("@RETURN_VALUE", SqlDbType.TinyInt);
Parameters[2].Direction = ParameterDirection.ReturnValue;
// Parameters[10] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
var Cmd = objDataEngine.ExecuteWithReturnValue("WebInternalAdminPassValidate", 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> SaveUnsettleTxn(UnsettleTxn _ust)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[14];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_ust.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _ust.TxnId);
Parameters[2] = String.IsNullOrEmpty(_ust.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _ust.AcctNo);
Parameters[3] = new SqlParameter("@TxnCd", ConvertIntToDb(_ust.TxnCd));
Parameters[4] = String.IsNullOrEmpty(_ust.TxnDate) ? new SqlParameter("@TxnDate", DBNull.Value) : new SqlParameter("@TxnDate", DateConverterDB(_ust.TxnDate));
Parameters[5] = String.IsNullOrEmpty(_ust.BookingDate) ? new SqlParameter("@BookingDate", DBNull.Value) : new SqlParameter("@BookingDate", DateConverterDB(_ust.BookingDate));
Parameters[6] = new SqlParameter("@TxnAmt", ConvertDecimalToDb(_ust.STxnAmt));
Parameters[7] = String.IsNullOrEmpty(_ust.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _ust.Descp);
// Parameters[8] = String.IsNullOrEmpty(_ust.PayeeName) ? new SqlParameter("@PayeeName ", DBNull.Value) : new SqlParameter("@PayeeName", _ust.PayeeName);
Parameters[8] = String.IsNullOrEmpty(_ust.CheqNo) ? new SqlParameter("@CheqNo", DBNull.Value) : new SqlParameter("@CheqNo", _ust.CheqNo);
Parameters[9] = String.IsNullOrEmpty(_ust.SelectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _ust.SelectedSts);
Parameters[10] = new SqlParameter("@RcptNo", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.Output;
Parameters[11] = new SqlParameter("@RetCd", SqlDbType.BigInt);
Parameters[11].Direction = ParameterDirection.Output;
Parameters[12] = new SqlParameter("@UserId", this.GetUserId);
Parameters[13] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[13].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebTxnUnsettleMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebSAPGeneralInfoMaint(SAP_GeneralInfo _SAP, string SapNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[15];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo);
Parameters[1] = String.IsNullOrEmpty(_SAP.ReconAccountNo) ? new SqlParameter("@ReconAcctNo", DBNull.Value) : new SqlParameter("@ReconAcctNo", _SAP.ReconAccountNo);
Parameters[2] = String.IsNullOrEmpty(_SAP.selectedDistributionChannel) ? new SqlParameter("@DistChannel", DBNull.Value) : new SqlParameter("@DistChannel", _SAP.selectedDistributionChannel);
Parameters[3] = String.IsNullOrEmpty(_SAP.CompanyCd) ? new SqlParameter("@CmpyCd", DBNull.Value) : new SqlParameter("@CmpyCd", _SAP.CompanyCd);
Parameters[4] = String.IsNullOrEmpty(_SAP.SelectedDivision) ? new SqlParameter("@Division", DBNull.Value) : new SqlParameter("@Division", _SAP.SelectedDivision);
Parameters[5] = String.IsNullOrEmpty(_SAP.selectedSalesOrganisation) ? new SqlParameter("@SaleOrg", DBNull.Value) : new SqlParameter("@SaleOrg", _SAP.selectedSalesOrganisation);
Parameters[6] = String.IsNullOrEmpty(_SAP.selectedCustomerClass) ? new SqlParameter("@CustClass", DBNull.Value) : new SqlParameter("@CustClass", _SAP.selectedCustomerClass);
Parameters[7] = String.IsNullOrEmpty(_SAP.AuthCd) ? new SqlParameter("@Autho", DBNull.Value) : new SqlParameter("@Autho", _SAP.AuthCd);
Parameters[8] = String.IsNullOrEmpty(_SAP.SearchName) ? new SqlParameter("@SearchTerm1", DBNull.Value) : new SqlParameter("@SearchTerm1", _SAP.SearchName);
Parameters[9] = String.IsNullOrEmpty(_SAP.SortKey) ? new SqlParameter("@SortKey", DBNull.Value) : new SqlParameter("@SortKey", _SAP.SortKey);
Parameters[10] = String.IsNullOrEmpty(_SAP.Location) ? new SqlParameter("@Location", DBNull.Value) : new SqlParameter("@Location", _SAP.Location);
Parameters[11] = String.IsNullOrEmpty(_SAP.SelectedCountryCd) ? new SqlParameter("@CtryCd", DBNull.Value) : new SqlParameter("@CtryCd", _SAP.SelectedCountryCd);
Parameters[12] = String.IsNullOrEmpty(_SAP.SelectedCurrencyCd) ? new SqlParameter("@CurrCd", DBNull.Value) : new SqlParameter("@CurrCd", _SAP.SelectedCurrencyCd);
Parameters[13] = String.IsNullOrEmpty(_SAP.SelectedCashManagementGroup) ? new SqlParameter("@CashMgmtGroup", DBNull.Value) : new SqlParameter("@CashMgmtGroup", _SAP.SelectedCashManagementGroup);
Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPGeneralInfoMaint]", 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> 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);
}