public List <VoiceAuthProducts> WebVAEProdListSelect(string ids)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@AcqNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(ids) ? new SqlParameter("@SrcIds", DBNull.Value) : new SqlParameter("@SrcIds", ids);
var execResult = objDataEngine.ExecuteCommand("[WebVAEProdListSelect]", CommandType.StoredProcedure, Parameters);
var _Products = new List <VoiceAuthProducts>();
while (execResult.Read())
{
_Products.Add(new VoiceAuthProducts
{
SelectedProdCd = Convert.ToString(execResult["ProdCd"]),
Qty = Convert.ToString(execResult["Qty"]),
AmtPoints = ConverterDecimal(execResult["Amt"]),
FastTrack = Convert.ToString(execResult["FastTrack"]),
UnitPrice = ConverterDecimal(execResult["UnitPrice"]),
});
}
return(_Products);
}
public PurchaseOrder WebReloadFundSelect(string TxnId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", TxnId);
var Reader = objDataEngine.ExecuteCommand("WebReloadFundSelect", CommandType.StoredProcedure, Parameters);
while (Reader.Read())
{
var _PurchaseOrder = new PurchaseOrder
{
AcctNo = Convert.ToInt64(Reader["AcctNo"]),
DocNo = Convert.ToString(Reader["DocNo"]),
TxnDate = DateConverter(Reader["TxnDate"]),
TxnAmt = ConverterDecimal(Reader["POAmt"]),
SelectedStatus = Convert.ToString(Reader["Sts"]),
Remarks = Convert.ToString(Reader["Remarks"])
};
objDataEngine.CloseConnection();
return(_PurchaseOrder);
}
return(new PurchaseOrder());
}
public ManualSlipEntry WebGetManualTxn(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("WebGetManualTxn", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _ManualSlipEntryTxnDetail = new ManualSlipEntry
{
BusnLocation = Convert.ToString(execResult["Dealer"]),
SelectedTermId = Convert.ToString(execResult["Termid"])
};
return(_ManualSlipEntryTxnDetail);
}
return(new ManualSlipEntry());
}
finally
{
objDataEngine.CloseConnection();
}
}
public List <ReportBrowser> WebRptBrowser(ReportBrowser _Browser)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@UserID", GetUserId);
Parameters[1] = string.IsNullOrEmpty(_Browser.ReportDate) ? new SqlParameter("@RptDate", DBNull.Value) : new SqlParameter("@RptDate", ConvertDatetimeDB(_Browser.ReportDate));
var execResult = objDataEngine.ExecuteCommand("WebRptBrowser", CommandType.StoredProcedure, Parameters);
var _Reports = new List <ReportBrowser>();
while (execResult.Read())
{
_Reports.Add(new ReportBrowser
{
FileName = Convert.ToString(execResult["DiskFileName"]),
ReportCategory = Convert.ToString(execResult["RptCategory"]),
ReportName = Convert.ToString(execResult["RptName"])
});
}
;
return(_Reports);
}
finally
{
objDataEngine.CloseConnection();
}
}
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 List <VoiceAuth> ftVoiceAuth(string BusnLocation, string CardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
Parameters[2] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo);
var execResult = objDataEngine.ExecuteCommand("[WebVAESearch]", CommandType.StoredProcedure, Parameters);
var _VoiceAuth = new List <VoiceAuth>();
while (execResult.Read())
{
_VoiceAuth.Add(new VoiceAuth
{
BusnLocation = Convert.ToString(execResult["BusnLocation"]),
CardNo = Convert.ToString(execResult["CardNo"]),
ApprovalCd = Convert.ToString(execResult["ApprovalCd"]),
DriverCd = Convert.ToString(execResult["DriverCd"]),
TxnInd = Convert.ToString(execResult["TxnInd"]),
TxnDate = DateTimeConverter(execResult["TxnDate"]),
Ids = Convert.ToString(execResult["Ids"]),
ResponseCd = Convert.ToString(execResult["RespCd"]),
TxnAmt = ConverterDecimal(execResult["Amt"]),
UserId = Convert.ToString(execResult["UserId"]),
TxnCd = Convert.ToString(execResult["TxnCd"]),
EmbossName = Convert.ToString(execResult["EmbName"]),
BusnName = Convert.ToString(execResult["BusnName"]),
CreationDate = DateConverter(execResult["CreationDate"])
});
}
return(_VoiceAuth);
}
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 List <UserIndexAccess> UserIndexAccess(string UserId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(UserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", UserId);
Parameters[1] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[1].Direction = ParameterDirection.ReturnValue;
var execResult = objDataEngine.ExecuteCommand("WebGetIndexAccess", CommandType.StoredProcedure, Parameters);
var userAccessList = new List <UserIndexAccess>();
while (execResult.Read())
{
var userAccess = new UserIndexAccess()
{
url = Convert.ToString(execResult["url"]),
descp = Convert.ToString(execResult["Descp"]),
attrId = Convert.ToString(execResult["attrid"]),
icon = Convert.ToString(execResult["icon"])
};
userAccessList.Add(userAccess);
}
objDataEngine.CloseConnection();
return(userAccessList);
}
public List <UserAccess> GetUserAccessList(string AccessInd)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(AccessInd) ? new SqlParameter("@AccessInd", DBNull.Value) : new SqlParameter("@AccessInd", AccessInd);
var execResult = objDataEngine.ExecuteCommand("WebUserAccessListSelect", CommandType.StoredProcedure, Parameters);
var _GetUserAccessList = new List <UserAccess>();
while (execResult.Read())
{
_GetUserAccessList.Add(new UserAccess
{
UserId = Convert.ToString(execResult["UserId"]),
Name = Convert.ToString(execResult["UserName"]),
SeletedTitle = Convert.ToString(execResult["Title"]),
selectedSts = Convert.ToString(execResult["Status"]),
ContactNo = Convert.ToString(execResult["ContactNo"]),
EmailAddr = Convert.ToString(execResult["EmailAddress"]),
SelectedDeptId = Convert.ToString(execResult["DeptId"]),
SelectedAccessInd = Convert.ToString(execResult["AccessInd"])
});
}
;
return(_GetUserAccessList);
}
finally
{
objDataEngine.CloseConnection();
}
}
public PrepaidCardnAcct WebReloadAllocationDetailSelect(int TxnId, string AcctNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@AcctNo", AcctNo);
Parameters[1] = new SqlParameter("@TxnId", TxnId);
var Reader = objDataEngine.ExecuteCommand("WebReloadAllocationDetailSelect", CommandType.StoredProcedure, Parameters);
while (Reader.Read())
{
var _PrepaidCardnAcct = new PrepaidCardnAcct
{
CardNo = Convert.ToString(Reader["CardNo"]),
AcctNo = Convert.ToString(Reader["AcctNo"]),
SelectedStatus = Convert.ToString(Reader["Sts"]),
Remarks = Convert.ToString(Reader["Remarks"]),
ParentTxnId = Convert.ToInt64(Reader["ParentTxnId"]),
TxnDate = DateTimeConverter(Reader["TxnDate"]),
EffDateFrom = DateConverter(Reader["EffDateFrom"]),
TxnAmt = ConverterDecimal(Reader["ReloadAmt"]),
};
return(_PrepaidCardnAcct);
}
return(new PrepaidCardnAcct());
}
public List <PrepaidCardnAcct> WebReloadAllocationDetailListSelect(string TxnId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = String.IsNullOrEmpty(TxnId) ? new SqlParameter("@ParentTxnId", DBNull.Value) : new SqlParameter("@ParentTxnId", TxnId);
var execResult = objDataEngine.ExecuteCommand("WebReloadAllocationDetailListSelect", CommandType.StoredProcedure, Parameters);
var CardNAcct = new List <PrepaidCardnAcct>();
while (execResult.Read())
{
CardNAcct.Add(new PrepaidCardnAcct
{
CardNo = Convert.ToString(execResult["CardNo"]),
ReloadAmt = ConverterDecimal(execResult["ReloadAmt"]),
SelectedStatus = Convert.ToString(execResult["Sts"]),
Remarks = Convert.ToString(execResult["Remarks"]),
ReloadDate = DateConverter(execResult["ReloadDate"]),
UserId = Convert.ToString(execResult["UserId"]),
CreationDate = DateConverter(execResult["CreationDate"]),
TxnId = ConvertLongToDb(execResult["TxnId"]),
AcctNo = Convert.ToString(execResult["AcctNo"])
});
}
objDataEngine.CloseConnection();
return(CardNAcct);
}
public List <PurchaseOrder> WebReloadFundSearch(Prepaid Params)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[5];
Parameters[0] = String.IsNullOrEmpty(Params.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", Params.AcctNo);
Parameters[1] = String.IsNullOrEmpty(Params.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", Params.SelectedStatus);
Parameters[2] = String.IsNullOrEmpty(Params.DocNo) ? new SqlParameter("@DocNo", DBNull.Value) : new SqlParameter("@DocNo", Params.DocNo);
Parameters[3] = new SqlParameter("@FromDate", ConvertDatetimeDB(Params.FromDate));
Parameters[4] = new SqlParameter("@ToDate", ConvertDatetimeDB(Params.ToDate));
var execResult = objDataEngine.ExecuteCommand("WebReloadFundSearch", CommandType.StoredProcedure, Parameters);
var _PrepaidList = new List <PurchaseOrder>();
while (execResult.Read())
{
var _Po = new PurchaseOrder();
_Po.TxnId = ConvertToInt(execResult["TxnId"]);
_Po.DocNo = Convert.ToString(execResult["DocNo"]);
_Po.TxnDate = DateConverter(execResult["TxnDate"]);
_Po.TxnAmt = ConverterDecimal(execResult["POAmt"]);
_Po.Balance = ConverterDecimal(execResult["POBal"]);
_Po.SelectedStatus = Convert.ToString(execResult["Sts"]);
_Po.CreationDate = DateConverter(execResult["CreationDate"]);
_Po.XRefDoc = Convert.ToString(execResult["Remarks"]);
_Po.UserId = Convert.ToString(execResult["CreatedBy"]);
_PrepaidList.Add(_Po);
}
;
objDataEngine.CloseConnection();
return(_PrepaidList);
}
public DeliveryAdvice WebReloadAllocationSelect(int TxnId, string AcctNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@TxnId", TxnId);
var Reader = objDataEngine.ExecuteCommand("WebReloadAllocationSelect", CommandType.StoredProcedure, Parameters);
while (Reader.Read())
{
var _DeliveryAdvice = new DeliveryAdvice
{
DocNo = Convert.ToString(Reader["DocNo"]),
AcctNo = Convert.ToInt64(Reader["AcctNo"]),
Remarks = Convert.ToString(Reader["Remarks"]),
TxnDate = DateConverter(Reader["TxnDate"]),
EffDateFrom = DateConverter(Reader["EffDateFrom"]),
SelectedStatus = Convert.ToString(Reader["Sts"]),
TxnAmt = ConverterDecimal(Reader["DAAmt"]),
TxnId = ConvertInt(Reader["TxnId"]),
ParentTxnId = Convert.ToString(Reader["ParentTxnId"]),
CreatedBy = Convert.ToString(Reader["CreatedBy"]),
CreationDate = DateConverter(Reader["CreationDate"]),
UserId = Convert.ToString(Reader["UserId"])
};
return(_DeliveryAdvice);
}
return(new DeliveryAdvice());
}
public List <DeliveryAdvice> WebReloadAllocationListSelect(string TxnId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(TxnId) ? new SqlParameter("@ParentTxnId", DBNull.Value) : new SqlParameter("@ParentTxnId", ConvertIntToDb(TxnId));
var execResult = objDataEngine.ExecuteCommand("WebReloadAllocationListSelect", CommandType.StoredProcedure, Parameters);
var _DeliveryList = new List <DeliveryAdvice>();
while (execResult.Read())
{
_DeliveryList.Add(new DeliveryAdvice
{
TxnDate = DateConverter(execResult["TxnDate"]),
EffDateFrom = DateConverter(execResult["EffDateFrom"]),
TxnAmt = ConverterDecimal(execResult["DAAmt"]),
DABal = ConverterDecimal(execResult["DaBal"]),
SelectedStatus = Convert.ToString(execResult["Sts"]),
Remarks = Convert.ToString(execResult["Remarks"]),
CreatedBy = Convert.ToString(execResult["CreatedBy"]),
CreationDate = DateConverter(execResult["CreationDate"]),
DocNo = Convert.ToString(execResult["DocNo"]),
PoTxnId = Convert.ToString(execResult["POTxnId"]),
DaTxnId = Convert.ToString(execResult["DATxnId"])
});
}
objDataEngine.CloseConnection();
return(_DeliveryList);
}
public ManualSlipEntry GetManualSlipEntryTxnDetail(string TxnId)
{
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(TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", TxnId);
var execResult = objDataEngine.ExecuteCommand("WebMerchManualTxnSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _ManualSlipEntryTxnDetail = new ManualSlipEntry
{
BusnLocation = Convert.ToString(execResult["Dealer"]),
SelectedTermId = Convert.ToString(execResult["TermId"]),
SelectedTxnCd = ConvertInt(execResult["TxnCd"]),
SiteId = Convert.ToString(execResult["SiteId"]),
InvoiceNo = ConvertInt(execResult["InvoiceNo"]),
CardNo = Convert.ToString(execResult["CardNo"]),
CardExpire = Convert.ToString(execResult["CardExpiry"]),
AuthCardNo = Convert.ToString(execResult["DriverCard"]),
AuthCardExp = Convert.ToString(execResult["AuthCardExpiry"]),
TxnDate = DateConverter(execResult["TxnDate"]),
RcptNo = Convert.ToString(execResult["RcptNo"]),
DisplayTotalAmt = ConverterDecimal(execResult["Amt"]),
AuthNo = Convert.ToString(execResult["AuthNo"]),
Odometer = ConvertInt(execResult["Odometer"]),
DriverCd = ConvertInt(execResult["DriverCd"]),
Rrn = Convert.ToString(execResult["Rrn"]),
Descp = Convert.ToString(execResult["Descp"]),
SettleId = Convert.ToString(execResult["SettleId"]),
Stans = ConvertInt(execResult["Stan"]),
TxnId = Convert.ToString(execResult["TxnId"]),
SelectedSts = Convert.ToString(execResult["sts"]),
VATAmt = ConverterDecimal(execResult["VATAmt"]),
VATNo = Convert.ToString(execResult["VATNo"]),
AppvCd = Convert.ToString(execResult["AuthNo"]),
_CreationDatenUserId = new CreationDatenUserId
{
CreationDate = DateConverter(execResult["CreationDate"]),
UserId = Convert.ToString(execResult["sts"])
},
};
return(_ManualSlipEntryTxnDetail);
}
;
return(new ManualSlipEntry());
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <VoiceAuthDetail> WebVaeDetailSelect(string BusnLocation, string CardNo, string Ids)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo);
Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
Parameters[2] = String.IsNullOrEmpty(Ids) ? new SqlParameter("@VaeIds", DBNull.Value) : new SqlParameter("@VaeIds", Ids);
var execResult = objDataEngine.ExecuteCommand("[WebVaeDetailSelect]", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _Detail = new VoiceAuthDetail
{
AcctNo = Convert.ToString(execResult["AcctNo"]),
AcctName = Convert.ToString(execResult["AcctName"]),
SelectedAcctStatus = Convert.ToString(execResult["AcctSts"]),
CorpCd = Convert.ToString(execResult["CorpCd"]),
AcctBalance = ConverterDecimal(execResult["AcctBal"]),
CreditLimit = ConverterDecimal(execResult["CreditLimit"]),
CardNo = Convert.ToString(execResult["CardNo"]),
SelectedCardType = Convert.ToString(execResult["CardType"]),
SelectedCardStatus = Convert.ToString(execResult["CardSts"]),
MemberSince = Convert.ToString(execResult["MemSince"]),
SelectedProductGroup = Convert.ToString(execResult["ProdGroup"]),
BusnLocation = Convert.ToString(execResult["BusnLocation"]),
BusnName = Convert.ToString(execResult["BusnName"]),
SelectedBusnStatus = Convert.ToString(execResult["BusnSts"]),
FloorLimit = ConverterDecimal(execResult["FloorLimit"]),
XRefCardNo = Convert.ToString(execResult["AuthCardNo"])
};
_Detail.ProdCd = await BaseClass.WebGetProductCode(_Detail.SelectedProductGroup);
if (!string.IsNullOrEmpty(Ids))
{
_Detail.termId = Convert.ToString(execResult["TermId"]);
_Detail.SelectedTxnCd = Convert.ToString(execResult["TxnCd"]);
_Detail.AuthNo = Convert.ToString(execResult["AuthNo"]);
_Detail.RespCd = Convert.ToString(execResult["RespCd"]);
_Detail.TxnAmt = ConverterDecimal(execResult["TxnAmt"]);
}
return(_Detail);
}
return(new VoiceAuthDetail());
}
public List <ManualTxnProduct> GetManualTxnProductList(string TxnId)
{
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(TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", TxnId);
var execResult = objDataEngine.ExecuteCommand("WebMerchManualTxnDetailListSelect", CommandType.StoredProcedure, Parameters);
var _ManualTxnDetailList = new List <ManualTxnProduct>();
while (execResult.Read())
{
_ManualTxnDetailList.Add(new ManualTxnProduct
{
BatchId = Convert.ToString(execResult["Batch Id"]),
SelectedProdCd = Convert.ToString(execResult["Prod"]),
Quantity = ConverterDecimal(execResult["Quantity"]),
ProdAmt = ConverterDecimal(execResult["Prod Amount"]),
ProdDesc = Convert.ToString(execResult["Prod Description"]),
LastUpdDate = DateConverter(execResult["Last Update Date"]),
SettleId = Convert.ToString(execResult["SettleId"]),
TxnId = Convert.ToString(execResult["TxnId"]),
TxnDetailId = Convert.ToString(execResult["TxnDetailId"]),
VATAmt = ConverterDecimal(execResult["VATAmt"]),
VATRate = ConverterDecimal(execResult["VATRate"]),
SelectedVATCd = Convert.ToString(execResult["VATCd"]),
_CreationDatenUserId = new CreationDatenUserId
{
CreationDate = DateConverter(execResult["Creation Date"]),
UserId = Convert.ToString(execResult["User Id"])
},
});
}
;
return(_ManualTxnDetailList);
}
finally
{
objDataEngine.CloseConnection();
}
}
public List <NegativeFiles> WebNegativeUnlockListSelect(NegativeFiles Params)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[4];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(Params.SelectedInd) ? new SqlParameter("@Ind", DBNull.Value) : new SqlParameter("@Ind", Params.SelectedInd);
Parameters[2] = String.IsNullOrEmpty(Params.SelectedRefTo) ? new SqlParameter("@RefTo", DBNull.Value) : new SqlParameter("@refTo", Params.SelectedRefTo);
Parameters[3] = String.IsNullOrEmpty(Params.SearchKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@refKey", Params.SearchKey);
var execResult = objDataEngine.ExecuteCommand("WebNegativeUnlockListSelect", CommandType.StoredProcedure, Parameters);
var _NegativeFiles = new List <NegativeFiles>();
while (execResult.Read())
{
if (Params.SelectedInd == "E")
{
_NegativeFiles.Add(new NegativeFiles
{
RefKey = Convert.ToString(execResult["RefKey"]),
LastUpdate = DateConverter(execResult["LastUpdDate"])
});
}
else if (Params.SelectedRefTo == "ACCT")
{
_NegativeFiles.Add(new NegativeFiles
{
AcctNo = Convert.ToString(execResult["AcctNo"]),
//RefId = DateConverter(execResult["RefId"])
RefId = Convert.ToString(execResult["RefId"])
});
}
else
{
_NegativeFiles.Add(new NegativeFiles
{
CardNo = Convert.ToString(execResult["CardNo"]),
RefId = Convert.ToString(execResult["RefId"])
});
}
}
;
objDataEngine.CloseConnection();
return(_NegativeFiles);
}
public List <ManualSlipEntry> GetManualSlipEntryBatchList()
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
var execResult = objDataEngine.ExecuteCommand("WebMerchManualBatchListSelect", CommandType.StoredProcedure, Parameters);
var _ManualSlipEntryBatList = new List <ManualSlipEntry>();
while (execResult.Read())
{
_ManualSlipEntryBatList.Add(new ManualSlipEntry
{
BusnLocation = Convert.ToString(execResult["Dealer"]), //
SelectedTermId = Convert.ToString(execResult["Terminal Id"]), //
SiteId = Convert.ToString(execResult["Site Id"]),
BatchId = Convert.ToString(execResult["Batch Id"]), //
InvoiceNo = ConvertInt(execResult["Invoice No"]), //
SettleDate = DateConverter(execResult["Settle Date"]), //
TotalCnt = ConvertInt(execResult["Total Count"]), //
TotalAmt = ConverterDecimal(execResult["Total Amount"]), //
DisplayTotalAmt = ConverterDecimal(execResult["Total Amount"]),
Descp = Convert.ToString(execResult["Description"]), //
SelectedSts = Convert.ToString(execResult["Status"]), //
TxnDescp = Convert.ToString(execResult["Txn Description"]), //
SettleId = Convert.ToString(execResult["SettleId"]),
_CreationDatenUserId = new CreationDatenUserId
{
CreationDate = DateConverter(execResult["Creation Date"]), //
UserId = Convert.ToString(execResult["User Id"]) //
}
});
}
;
return(_ManualSlipEntryBatList);
}
finally
{
objDataEngine.CloseConnection();
}
}
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 MsgRetriever SaveAMaint(AuditLoggerModel _auditLog)
//{
// var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
// objDataEngine.InitiateConnection();
// SqlParameter[] Parameters = new SqlParameter[4];
// Parameters[0] = string.IsNullOrEmpty(_auditLog.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _auditLog.SelectedModule);
// Parameters[1] = string.IsNullOrEmpty(_auditLog.TblName) ? new SqlParameter("@TblName", DBNull.Value) : new SqlParameter("@TblName", _auditLog.TblName);
// Parameters[2] = string.IsNullOrEmpty(_auditLog.Date) ? new SqlParameter("@Date", DBNull.Value) : new SqlParameter("@Date", _auditLog.Date);
// Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
// Parameters[3].Direction = ParameterDirection.ReturnValue;
// var Cmd = objDataEngine.ExecuteWithReturnValue("WebAuditMaintSearch", CommandType.StoredProcedure, Parameters);
// var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
// var Descp = GetMessageCode(Result);
// objDataEngine.CloseConnection();
// return Descp;
// }
public AuditLoggerModel GetAudLoggerDetail(AuditLoggerModel _AudLogger)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = string.IsNullOrEmpty(_AudLogger.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _AudLogger.SelectedModule);
Parameters[1] = new SqlParameter("@AuditId", _AudLogger.AudId);
var execResult = objDataEngine.ExecuteCommand("WebAuditMaintSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _auditLog = new AuditLoggerModel
{
AudId = Convert.ToString(execResult["AuditId"]),
SelectedTblName = Convert.ToString(execResult["TableName"]),
FieldName = Convert.ToString(execResult["FieldName"]),
RefKey = Convert.ToString(execResult["Ref Key"]),
subRefKey1 = Convert.ToString(execResult["Sub Ref Key1"]),
subRefKey2 = Convert.ToString(execResult["Sub Ref Key2"]),
ActionAud = Convert.ToString(execResult["Action"]),
OldData = Convert.ToString(execResult["Old Data"]),
NewData = Convert.ToString(execResult["New Data"]),
ActionBy = Convert.ToString(execResult["Actioned By"]),
CreationDate = Convert.ToString(execResult["Creation Date"]),
};
return(_auditLog);
}
;
return(new AuditLoggerModel());
}
finally
{
objDataEngine.CloseConnection();
}
}
public List <SecurityViewModel> WebGetUserAccessModuleList(string UserId)
{
//Level code = > 0=Module, 1=Page & 2=PageControl
// Status Code => 0=Invisible, 1=Editable, 2= ReadOnly
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(UserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", UserId);
Parameters[2] = new SqlParameter("@Lvl", "0");
var execResult = objDataEngine.ExecuteCommand("WebUserAccessLevelListSelect", CommandType.StoredProcedure, Parameters);
var _SecurityViewModel = new List <SecurityViewModel>();
//get WebModule list
while (execResult.Read())
{
_SecurityViewModel.Add(new SecurityViewModel
{
_WebModule = new WebModule
{
Level = ConvertInt(execResult["Lvl"]),
ModuleId = Convert.ToString(execResult["ModuleId"]),
ShortDescp = Convert.ToString(execResult["ShortDescp"]),
Descp = Convert.ToString(execResult["Descp"]),
Sts = ConvertInt(execResult["Sts"])
}
});
}
return(_SecurityViewModel);
}
finally
{
objDataEngine.CloseConnection();
}
}
public List <BusnLocTerminal> GetBusnLocTermList(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 execResult = objDataEngine.ExecuteCommand("WebBusnLocationTerminalListSelect", CommandType.StoredProcedure, Parameters);
var _BusnLocTermList = new List <BusnLocTerminal>();
while (execResult.Read())
{
_BusnLocTermList.Add(new BusnLocTerminal
{
TermId = Convert.ToString(execResult["TermId"]),
SelectedStatus = Convert.ToString(execResult["Status"]),
RawStatus = Convert.ToString(execResult["Sts"]),
DeployDate = DateConverter(execResult["DeployDate"]),
Replacement = Convert.ToString(execResult["ReplacedByTermId"]),
ReplacedDate = DateConverter(execResult["ReplacedDate"]),
SelectedReasonCode = Convert.ToString(execResult["Reason"]),
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(_BusnLocTermList);
}
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 ManualSlipEntry GetMerchManualTxnProductDetail(string TxnId, string TxnDetailId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", TxnId);
Parameters[2] = String.IsNullOrEmpty(TxnDetailId) ? new SqlParameter("@TxnDetailId", DBNull.Value) : new SqlParameter("@TxnDetailId", TxnDetailId);
var execResult = objDataEngine.ExecuteCommand("WebMerchManualTxnDetailSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _ManualTxnProduct = new ManualSlipEntry
{
SelectedProdCd = Convert.ToString(execResult["ProdCd"]),
Quantity = ConvertInt(execResult["Qty"]).ToString("0"),
ProdAmt = ConverterDecimal(execResult["ProdAmt"]),
ProdDesc = Convert.ToString(execResult["Descp"]),
UnitPrice = ConverterDecimal(execResult["UnitPrice"]),
SettleId = Convert.ToString(execResult["SettleId"]),
TxnId = Convert.ToString(execResult["TxnId"]),
TxnDetailId = Convert.ToString(execResult["TxnDetailId"]),
VATAmt = ConverterDecimal(execResult["VATAmt"]),
VATRate = ConverterDecimal(execResult["VATRate"]),
SelectedVATCd = Convert.ToString(execResult["VATCd"]),
};
return(_ManualTxnProduct);
}
;
return(new ManualSlipEntry());
}
finally
{
objDataEngine.CloseConnection();
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (!filterContext.HttpContext.Request.IsAjaxRequest())
{
if (filterContext.HttpContext.Session["ProcessId"] == null)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@IssNo", 1);
var execResult = objDataEngine.ExecuteCommand("[WebGetPrcs]", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var ProcessId = Convert.ToString(execResult["PrcsId"]);
var ProcessDate = BaseClass.DateConverter(execResult["PrcsDate"]);
filterContext.HttpContext.Session["ProcessId"] = ProcessId;
filterContext.HttpContext.Session["ProcessDate"] = ProcessDate;
}
;
}
}
base.OnActionExecuting(filterContext);
}
public List <AuditLoggerModel> GetAuditSearch(AuditLoggerModel _auditLog)
{
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = string.IsNullOrEmpty(_auditLog.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _auditLog.SelectedModule);
Parameters[1] = string.IsNullOrEmpty(_auditLog.SelectedTblName) ? new SqlParameter("@TblName", DBNull.Value) : new SqlParameter("@TblName", _auditLog.SelectedTblName);
Parameters[2] = new SqlParameter("@Date", ConvertDatetimeDB(_auditLog.Date));
var execResult = objDataEngine.ExecuteCommand("WebAuditMaintSearch", CommandType.StoredProcedure, Parameters);
var AuditSearch = new List <AuditLoggerModel>();
while (execResult.Read())
{
AuditSearch.Add(new AuditLoggerModel
{
SelectedTblName = Convert.ToString(execResult["TableName"]),
FieldName = Convert.ToString(execResult["FieldName"]),
RefKey = Convert.ToString(execResult["Ref Key"]),
ActionAud = Convert.ToString(execResult["Action"]),
OldData = Convert.ToString(execResult["Old Data"]),
NewData = Convert.ToString(execResult["New Data"]),
CreationDate = DateConverter(execResult["Creation Date"]),
// UserId=Convert.ToString(execResult["UserId"])
});
}
;
return(AuditSearch);
}
finally
{
objDataEngine.CloseConnection();
}
}
