public async Task <List <EventRcptList> > WebNtfyEventRcptListSelect(string ScheduleId) { var objEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objEngine.InitiateConnection(); var list = new List <EventRcptList>(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); Parameters[0] = String.IsNullOrEmpty(ScheduleId) ? new SqlParameter("@EventScheduleId", DBNull.Value) : new SqlParameter("@EventScheduleId", ScheduleId); var getObjData = await objEngine.ExecuteCommandAsync("[WebNtfyEventRcptListSelect]", CommandType.StoredProcedure, Parameters); while (getObjData.Read()) { //a1.Id, a1.ContactName, a1.ContactNo, a1.ContentId, a1.ChannelInd, a1.LangInd var item = new EventRcptList { ChannelInd = ConvertInt(getObjData["ChannelInd"]), ContactName = Convert.ToString(getObjData["ContactName"]), ContactNo = Convert.ToString(getObjData["ContactNo"]), LangInd = Convert.ToString(getObjData["LangInd"]), ContentId = Convert.ToInt64(getObjData["ContentId"]), Id = Convert.ToInt64(getObjData["Id"]) }; list.Add(item); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <IEnumerable <LookupParameters> > WebProdGroupRefSelect(string ProdGroup) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { await objDataEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = new SqlParameter("@ProdGroup", String.IsNullOrEmpty(ProdGroup) ? (object)DBNull.Value : ProdGroup); var execResult = await objDataEngine.ExecuteCommandAsync("WebProdGroupRefSelect", CommandType.StoredProcedure, Parameters); var _Parameters = new List <LookupParameters>(); while (execResult.Read()) { var _Parameter = new LookupParameters(); _Parameter.SelectedProductGroup = Convert.ToString(execResult["Product Group"]); _Parameter.Descp = Convert.ToString(execResult["Description"]); _Parameter.ProductCode = Convert.ToString(execResult["Product Code"]); _Parameter.ProductName = Convert.ToString(execResult["Product Name"]); _Parameter.SelectedProductCategory = Convert.ToString(execResult["Product Category"]); _Parameter.SelectedProductType = Convert.ToString(execResult["Product Type"]); _Parameter.UnitPrice = ConverterDecimal(execResult["Unit Price"]); _Parameter.LastUpdated = Convert.ToString(execResult["Updated On"]); _Parameter.UserId = Convert.ToString(execResult["Updated By"]); _Parameters.Add(_Parameter); } return(_Parameters); } finally { objDataEngine.CloseConnection(); } }
public async static Task <IEnumerable <SelectListItem> > WebGetNonFleetTxnCode() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", 1); var getObjData = await objEngine.ExecuteCommandAsync("WebGetNonFleetTxnCode", CommandType.StoredProcedure, Parameters); var list = new List <SelectListItem>(); while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToString(getObjData["Descp"]), Value = Convert.ToString(getObjData["TxnCd"]) }); } return(list); } finally { objEngine.CloseConnection(); } }
public async static Task <IEnumerable <SelectListItem> > WebGetMap() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web); try { await objEngine.InitiateConnectionAsync(); SqlCommand cmd = new SqlCommand(); var getObjData = await objEngine.ExecuteCommandAsync("WebGetMapId", CommandType.StoredProcedure); var list = new List <SelectListItem>(); while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToString(getObjData["User Id"]), Value = Convert.ToString(getObjData["User Id"]) }); } return(list); } finally { objEngine.CloseConnection(); } }
public static async Task <IEnumerable <SelectListItem> > WebGetCycleStmt(string cycNo) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@CycNo", String.IsNullOrEmpty(cycNo) ? (object)DBNull.Value : cycNo); var getObjData = await objEngine.ExecuteCommandAsync("WebGetCycleStmt", CommandType.StoredProcedure, Parameters); var list = new List <SelectListItem>(); while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToDateTime(getObjData["StmtDate"]).ToString("yyyy-MM-dd"), Value = Convert.ToString(getObjData["CycStmtId"]) + ":" + Convert.ToDateTime(getObjData["StmtDate"]).ToString("yyyy-MM-dd"), Selected = Convert.ToString(getObjData["StmtDate"]) == "1" ? true : false }); } return(list); }catch (Exception ex) { System.Exception expt = new Exception("Error calls SP", ex); throw expt; }finally { objEngine.CloseConnection(); } }
public async Task <List <TmplDisplayer> > WebEventTypeTemplateSelect(string EventTypeId) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@EventTypeId", EventTypeId); var execResult = await objEngine.ExecuteCommandAsync("WebEventTypeTemplateSelect", CommandType.StoredProcedure, Parameters); var _Parameters = new TmplDisplayer(); var list = new List <TmplDisplayer>(); while (execResult.Read()) { _Parameters = new TmplDisplayer { ContentTmplt = Convert.ToString(execResult["Template Displayer"]), Descp = Convert.ToString(execResult["Descp"]), LangInd = Convert.ToString(execResult["Template Language Indicator"]), Type = Convert.ToString(execResult["Type"]) }; list.Add(_Parameters); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <TxnAdjustment> > WebMultiTxnAdjustmentListSelect() { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); var execResult = await objDataEngine.ExecuteCommandAsync("WebMultiTxnAdjustmentListSelect", CommandType.StoredProcedure, Parameters); var _List = new List <TxnAdjustment>(); while (execResult.Read()) { _List.Add(new TxnAdjustment { BatchId = Convert.ToString(execResult["Batchid"]), TxnNo = Convert.ToString(execResult["Txn No"]), ChequeAmt = ConverterDecimal(execResult["Cheque Amt"]), DisplayTotAmt = ConverterDecimal(execResult["Total Txn Amt"]), CreationDate = Convert.ToString(execResult["CreationDate"]), CreatedBy = Convert.ToString(execResult["User Id"]), SelectedTxnCode = Convert.ToString(execResult["TxnCd"]), SelectedOwner = Convert.ToString(execResult["Owner"]), SelectedSts = Convert.ToString(execResult["Sts"]), ChequeNo = Convert.ToString(execResult["Rrn"]) }); } return(_List); } finally { objDataEngine.CloseConnection(); } }
public async Task <LocationAcceptListModel> LocationAcceptanceSelect(string AcctNo, string BusnLoc, string CardNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", AcctNo); Parameters[2] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo); Parameters[2] = String.IsNullOrEmpty(BusnLoc) ? new SqlParameter("@BusnLoc", DBNull.Value) : new SqlParameter("@BusnLoc", BusnLoc); var reader = await objDataEngine.ExecuteCommandAsync("WebLocationAcceptanceSelect", CommandType.StoredProcedure, Parameters); var LocationAccptInfo = new LocationAcceptListModel(); while (reader.Read()) { LocationAccptInfo.s_state = Convert.ToString(reader["BusnLocation"]); LocationAccptInfo.UserId = Convert.ToString(reader["User Id"]); LocationAccptInfo.CreationDate = DateConverter(reader["Creation Date"]); return(LocationAccptInfo); } return(new LocationAcceptListModel()); } finally { objDataEngine.CloseConnection(); } }
public static async Task <IEnumerable <SelectListItem> > iFrameGetTxnCategory() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); var getObjData = await objEngine.ExecuteCommandAsync("iFrameGetTxnCategory", CommandType.StoredProcedure); var list = new List <SelectListItem>(); while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToString(getObjData["Descp"]), Value = Convert.ToString(getObjData["Category"]) }); } if (list.Count > 0) { list.First().Selected = true; } return(list); } finally { objEngine.CloseConnection(); } }
public async static Task <IEnumerable <SelectListItem> > WebUserAccessListSelect(string AccessInd = "I") { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[2]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", "1"); Parameters[1] = String.IsNullOrEmpty(AccessInd) ? new SqlParameter("@AccessInd", DBNull.Value) : new SqlParameter("@AccessInd", AccessInd); var getObjData = await objEngine.ExecuteCommandAsync("WebUserAccessListSelect", CommandType.StoredProcedure, Parameters); var list = new List <SelectListItem>(); while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToString(getObjData["UserId"]), Value = Convert.ToString(getObjData["UserId"]) }); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <LookupParameters> > WebUndefinedProdType() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", GetIssNo); var getObjData = await objEngine.ExecuteCommandAsync("WebUndefinedProdType", CommandType.StoredProcedure, Parameters); var list = new List <LookupParameters>(); while (getObjData.Read()) { var item = new LookupParameters { ProductCode = Convert.ToString(getObjData["ProdCd"]), ProductName = Convert.ToString(getObjData["ProdName"]), Descp = Convert.ToString(getObjData["ProdDescp"]), SelectedProductCategory = Convert.ToString(getObjData["ProdCategory"]), SelectedProductType = Convert.ToString(getObjData["ProdType"]), UnitPrice = ConverterDecimal(getObjData["ProdUnitPrice"]) }; list.Add(item); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <TxnAdjustment> > WebMerchantMultiTxnAdjustmentListSelect() { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); var execResult = await objDataEngine.ExecuteCommandAsync("WebMerchantMultiTxnAdjustmentListSelect", CommandType.StoredProcedure, Parameters); var _List = new List <TxnAdjustment>(); while (execResult.Read()) { _List.Add(new TxnAdjustment { BatchId = Convert.ToString(execResult["Batch Id"]), CreationDate = DateConverter(execResult["Creation Date"]), SelectedAdjTxnCode = Convert.ToString(execResult["Txn Code"]), InvoiceNo = Convert.ToString(execResult["Invoice No"]), TxnCount = Convert.ToString(execResult["Txn Cnt"]), BillingTxnAmt = ConverterDecimal(execResult["Txn Amount"]), SelectedOwner = Convert.ToString(execResult["Owner"]), SelectedSts = Convert.ToString(execResult["Status"]), }); } return(_List); } catch (Exception) { throw; } }
/* * public async Task<MsgRetriever> WebNtfEvtConfDelete(string ScheduleId) * { * SqlParameter[] Parameters = new SqlParameter[2]; * SqlCommand cmd = new SqlCommand(); * var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); * try * { * await objDataEngine.InitiateConnectionAsync(); * Parameters[0] = new SqlParameter("@ScheduleId", ScheduleId); * Parameters[1] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); * Parameters[1].Direction = ParameterDirection.ReturnValue; * var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebNtfEvtConfDelete", 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> WebNtfEvtConfRcptDelete(string @SchRcptId) //{ // SqlParameter[] Parameters = new SqlParameter[2]; // SqlCommand cmd = new SqlCommand(); // var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); // try // { // await objDataEngine.InitiateConnectionAsync(); // Parameters[0] = new SqlParameter("@SchRcptId", @SchRcptId); // Parameters[1] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); // Parameters[1].Direction = ParameterDirection.ReturnValue; // var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebNtfEvtConfRcptDelete", 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 <List <LookupParameters> > WebNtfyEventConfSelect(string PlanId) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { await objDataEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@EventScheduleId", PlanId); var execResult = await objDataEngine.ExecuteCommandAsync("[WebNtfyEventConfSelect]", CommandType.StoredProcedure, Parameters); var _Parameters = new List <LookupParameters>(); while (execResult.Read()) { var _Parameter = new LookupParameters { BitmapAmt = Convert.ToString(execResult["ParamInd"]), EvtPlanDetailId = Convert.ToString(execResult["EventPlanDetailId"]), EventScheduleId = PlanId, EventTypeId = Convert.ToString(execResult["EventTypeId"]), EventPlanId = Convert.ToString(execResult["EventPlanId"]), DetailedDescp = Convert.ToString(execResult["Descp"]), type = Convert.ToString(execResult["Type"]), TypeDesc = Convert.ToString(execResult["TypeDescp"]), SelectedPriority = Convert.ToString(execResult["Severity"]), SelectedOwner = Convert.ToString(execResult["OwnerType"]), SelectedStatus = Convert.ToString(execResult["Sts"]), SelectedRefTo = Convert.ToString(execResult["Refto"]), RefKey = Convert.ToString(execResult["Refkey"]), CompanyName = Convert.ToString(execResult["CmpyName"]), MaxOccur = Convert.ToString(execResult["MaxOccur"]), SelectedFrequency = Convert.ToString(execResult["OccurPeriodType"]), MinIntVal = Convert.ToString(execResult["MinIntVal"]), MaxIntVal = Convert.ToString(execResult["MaxIntVal"]), MinMoneyVal = ConverterDecimal(execResult["MinMoneyVal"]), MaxMoneyVal = ConverterDecimal(execResult["MaxMoneyVal"]), MinDateVal = DateConverter(execResult["MinDateVal"]), MaxDateVal = DateConverter(execResult["MaxDateVal"]), MinTimeVal = Convert.ToString(execResult["MinTimeVal"]), MaxTimeVal = Convert.ToString(execResult["MaxTimeVal"]), VarCharVal = Convert.ToString(execResult["VarCharVal"]), PeriodType = Convert.ToString(execResult["PeriodType"]), PeriodInterval = Convert.ToString(execResult["PeriodInterval"]), ApplyAllInd = BoolConverter(execResult["AllAppyInd"]), DefaultInd = BoolConverter(execResult["DefaultInd"]), LastUpdated = Convert.ToString(execResult["LastUpdDate"]), UpdatedBy = Convert.ToString(execResult["UserId"]), ParamInd = Convert.ToString(execResult["ParamInd"]), NotifyInd = ConvertInt(execResult["EvtTypeChannelInd"]) }; _Parameters.Add(_Parameter); } return(_Parameters); } finally { objDataEngine.CloseConnection(); } }
public async Task <List <PinMailerBatchList> > GetPinMailerBatchList() { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); var execResult = await objDataEngine.ExecuteCommandAsync("PINMailerGetBatch", CommandType.StoredProcedure, Parameters); var _PinMailerBatchList = new List <PinMailerBatchList>(); while (await execResult.ReadAsync()) { _PinMailerBatchList.Add(new PinMailerBatchList { BatchID = ConvertToInt(execResult["BatchId"]), CreationDate = DateTimeConverter(execResult["CreationDate"]), Sts = Convert.ToString(execResult["Sts"]), Count = ConvertToInt(execResult["Count"]) }); } ; return(_PinMailerBatchList); } finally { objDataEngine.CloseConnection(); } }
public async Task <List <MultiPayment> > WebGetGLCode(MultiPayment _multi) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = String.IsNullOrEmpty(_multi.SelectedAdjTxnCode) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _multi.SelectedAdjTxnCode); var execResult = await objDataEngine.ExecuteCommandAsync("WebGetGlCode", CommandType.StoredProcedure, Parameters); var _List = new List <MultiPayment>(); while (execResult.Read()) { _List.Add(new MultiPayment { GLTxnCode = Convert.ToString(execResult["AcctTxnCd"]), GLDescp = Convert.ToString(execResult["GLTxnDescp"]), GLCodeDescp = Convert.ToString(execResult["Descp"]) }); } return(_List); } finally { objDataEngine.CloseConnection(); } }
public async Task <IEnumerable <SelectListItem> > WebGetPymtTxnCd(string GlSettlementCd, string TxnCat) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = new SqlParameter("@TxnCat", TxnCat); Parameters[2] = String.IsNullOrEmpty(GlSettlementCd) ? new SqlParameter("@settleval", DBNull.Value) : new SqlParameter("@settleval", GlSettlementCd); var execResult = await objDataEngine.ExecuteCommandAsync("WebGetPymtTxnCd", CommandType.StoredProcedure, Parameters); var _List = new List <SelectListItem>(); while (execResult.Read()) { _List.Add(new SelectListItem { Text = Convert.ToString(execResult["Descp"]), Value = Convert.ToString(execResult["TxnCd"]) }); } return(_List); } finally { objDataEngine.CloseConnection(); } }
public async Task <List <SelectListItem> > WebGetEvtInd() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); var getObjData = await objEngine.ExecuteCommandAsync("[WebGetEvtInd]", CommandType.StoredProcedure); var list = new List <SelectListItem>(); list.Add(new SelectListItem { Text = "", Value = "" }); while (getObjData.Read()) { var item = new SelectListItem { Text = Convert.ToString(getObjData["Descp"]), Value = Convert.ToString(getObjData["RefCd"]), }; list.Add(item); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <LookupParameters> > WebEventTypeListSelect() { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); var getObjData = await objEngine.ExecuteCommandAsync("[WebEventTypeListSelect]", CommandType.StoredProcedure); var list = new List <LookupParameters>(); while (getObjData.Read()) { var item = new LookupParameters { EventTypeId = Convert.ToString(getObjData["ID"]), SelectedEventType = Convert.ToString(getObjData["Type"]), ShortDescp = Convert.ToString(getObjData["Short Description"]), DetailedDescp = Convert.ToString(getObjData["Detailed Description"]), SelectedStatus = Convert.ToString(getObjData["Status"]), LastUpdated = DateConverter(getObjData["Update Date"]), UpdatedBy = Convert.ToString(getObjData["Update By"]) }; list.Add(item); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <LookupParameters> > WebEventSelect(string EventId) { var objEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); objEngine.InitiateConnection(); try { var list = new List <LookupParameters>(); SqlParameter[] Parameters = new SqlParameter[1]; SqlCommand cmd = new SqlCommand(); Parameters[0] = String.IsNullOrEmpty(EventId) ? new SqlParameter("@EventId", DBNull.Value) : new SqlParameter("@EventId", EventId); var getObjData = await objEngine.ExecuteCommandAsync("WebEvtSelect", CommandType.StoredProcedure, Parameters); while (getObjData.Read()) { var info = new LookupParameters { Id = Convert.ToString(getObjData["EvtId"]), EventScheduleId = Convert.ToString(getObjData["EventScheduleId"]), ShortDescp = Convert.ToString(getObjData["ShortDescp"]), type = Convert.ToString(getObjData["Type"]), SelectedPriority = Convert.ToString(getObjData["Severity"]), SelectedOwner = Convert.ToString(getObjData["OwnerType"]), TypeDesc = Convert.ToString(getObjData["TypeDescp"]), SelectedRefTo = Convert.ToString(getObjData["Refto"]), RefKey = Convert.ToString(getObjData["Refkey"]), CompanyName = Convert.ToString(getObjData["CmpyName"]), DetailedDescp = Convert.ToString(getObjData["EvtDescp"]), MaxOccur = Convert.ToString(getObjData["MaxOccur"]), SelectedFrequency = Convert.ToString(getObjData["OccurPeriodType"]), MinIntVal = Convert.ToString(getObjData["MinIntVal"]), MaxIntVal = Convert.ToString(getObjData["MaxIntVal"]), MinMoneyVal = Convert.ToString(getObjData["MinMoneyVal"]), MaxMoneyVal = Convert.ToString(getObjData["MaxMoneyVal"]), MinDateVal = Convert.ToString(getObjData["MinDateVal"]), MaxDateVal = Convert.ToString(getObjData["MaxDateVal"]), MinTimeVal = Convert.ToString(getObjData["MinTimeVal"]), MaxTimeVal = Convert.ToString(getObjData["MaxTimeVal"]), VarCharVal = Convert.ToString(getObjData["VarCharVal"]), PeriodType = Convert.ToString(getObjData["PeriodType"]), PeriodInterval = Convert.ToString(getObjData["PeriodInterval"]), NotifyInd = ConvertInt(getObjData["ChannelInd"]), LastUpdated = Convert.ToString(getObjData["LastUpdDate"]), UpdatedBy = Convert.ToString(getObjData["UserId"]), ParamInd = Convert.ToString(getObjData["ParamInd"]), SentDate = DateConverter(getObjData["SentDate"]) }; String BitmapAmt = Convert.ToString(getObjData["ParamInd"]); info.BitmapAmt = BitmapAmt; list.Add(info); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <LookupParameters> > WebEventTypeSelect(string EventTypeId) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@EventTypeId", EventTypeId); var execResult = await objEngine.ExecuteCommandAsync("WebEventTypeSelect", CommandType.StoredProcedure, Parameters); var _Parameters = new LookupParameters(); var list = new List <LookupParameters>(); while (execResult.Read()) { _Parameters = new LookupParameters { EventTypeId = Convert.ToString(execResult["EvtTypeID"]), EventPlanId = Convert.ToString(execResult["EvtPlanId"]), ShortDescp = Convert.ToString(execResult["Short Description"]), TypeDesc = Convert.ToString(execResult["Short Description"]), SelectedEventType = Convert.ToString(execResult["Type"]), SelectedPriority = Convert.ToString(execResult["Severity"]), SelectedOwner = Convert.ToString(execResult["Scope"]), SelectedStatus = Convert.ToString(execResult["Status"]), ApplyAllInd = BoolConverter(execResult["ApplyAllInd"]), DetailedDescp = Convert.ToString(execResult["Full Description"]), BitmapAmt = Convert.ToString(execResult["BitmapAmt"]), MaxOccur = Convert.ToString(execResult["Total Occurs"]), SelectedFrequency = Convert.ToString(execResult["Set Frequency Type"]), MinIntVal = Convert.ToString(execResult["MinIntVal"]), MaxIntVal = Convert.ToString(execResult["MaxIntVal"]), EvtPlanDetailId = Convert.ToString(execResult["EvtPlanDetailId"]), MinMoneyVal = ConverterDecimal(execResult["MinMoneyVal"]), MaxMoneyVal = ConverterDecimal(execResult["MaxMoneyVal"]), MinDateVal = DateConverter(execResult["MinDateVal"]), MaxDateVal = DateConverter(execResult["MaxDateVal"]), MinTimeVal = Convert.ToString(execResult["MinTimeVal"]), MaxTimeVal = Convert.ToString(execResult["MaxTimeVal"]), VarCharVal = Convert.ToString(execResult["VarCharVal"]), PeriodType = Convert.ToString(execResult["Period Type"]), PeriodInterval = Convert.ToString(execResult["Period Interval"]), NotifyInd = ConvertInt(execResult["NtfyInd"]), LastUpdated = Convert.ToString(execResult["Update On"]), UpdatedBy = Convert.ToString(execResult["Update by"]), DefaultInd = BoolConverter(execResult["DefaultInd"]) }; list.Add(_Parameters); } return(list); } finally { objEngine.CloseConnection(); } }
public async Task <List <ManualSlipEntry> > GetManualSlipEntryTxnList(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 = await objDataEngine.ExecuteCommandAsync("WebMerchManualTxnListSelect", CommandType.StoredProcedure, Parameters); var _ManualSlipEntryTxnList = new List <ManualSlipEntry>(); while (execResult.Read()) { _ManualSlipEntryTxnList.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"]), // RcptNo = Convert.ToString(execResult["Receipt No"]), // TxnDate = DateConverter(execResult["Transaction Date"]), // CardNo = Convert.ToString(execResult["Card No"]), AuthCardNo = Convert.ToString(execResult["Driver Card"]), // DisplayTxnAmt = ConverterDecimal(execResult["Txn Amount"]), ShownTxnAmt = ConverterDecimal(execResult["Txn Amount"]), // Descp = Convert.ToString(execResult["Description"]), // AuthNo = Convert.ToString(execResult["Auth Resp"]), // Odometer = ConvertInt(execResult["Odometer Reading"]), ArrayCnt = ConvertInt(execResult["Array Count"]), SelectedTxnCd = ConvertInt(execResult["TxnCd"]), TxnId = Convert.ToString(execResult["TxnId"]), SelectedSts = Convert.ToString(execResult["Sts"]), VATNo = Convert.ToString(execResult["VATNo"]), VATAmt = ConverterDecimal(execResult["VATAmt"]), _CreationDatenUserId = new CreationDatenUserId { CreationDate = DateConverter(execResult["Creation Date"]), UserId = Convert.ToString(execResult["User Id"]) }, }); } ; return(_ManualSlipEntryTxnList); } finally { objDataEngine.CloseConnection(); } }
public async Task <List <MerchPostedTxnSearch> > WebMerchTxnSearch(TxnSearchModel _model) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[7]; Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo); Parameters[1] = String.IsNullOrEmpty(_model.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", _model.BusnLocation); Parameters[2] = String.IsNullOrEmpty(_model.SelectedMerchTxnCd) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _model.SelectedMerchTxnCd); Parameters[3] = String.IsNullOrEmpty(_model.MerchAcctNo) ? new SqlParameter("@MerchAcctNo", DBNull.Value) : new SqlParameter("@MerchAcctNo", _model.MerchAcctNo); Parameters[4] = String.IsNullOrEmpty(_model.MerchFromDate) ? new SqlParameter("@FrmTxnDate", DBNull.Value) : new SqlParameter("@FrmTxnDate", DateConverterDB(_model.MerchFromDate)); Parameters[5] = String.IsNullOrEmpty(_model.MerchToDate) ? new SqlParameter("@ToTxnDate", DBNull.Value) : new SqlParameter("@ToTxnDate", DateConverterDB(_model.MerchToDate)); Parameters[6] = String.IsNullOrEmpty(_model.SelectedTxnCategory) ? new SqlParameter("@TxnCat", DBNull.Value) : new SqlParameter("@TxnCat", _model.SelectedTxnCategory); var execResult = await objDataEngine.ExecuteCommandAsync("WebMerchTxnSearch", CommandType.StoredProcedure, Parameters); var _MerchPostedTxnSearch = new List <MerchPostedTxnSearch>(); while (execResult.Read()) { _MerchPostedTxnSearch.Add(new MerchPostedTxnSearch { SelectedDealer = Convert.ToString(execResult["Dealer"]), TermBatch = Convert.ToString(execResult["TermBatch"]), TxnDate = Convert.ToString(execResult["TxnDate"]), cardNo = Convert.ToString(execResult["CardNo"]), TxnDesp = Convert.ToString(execResult["TxnDescp"]), TxnAmt = ConverterDecimal(execResult["BillingAmt"]), TermId = Convert.ToString(execResult["TermId"]), AuthNo = Convert.ToString(execResult["AuthNo"]), AuthCardNo = Convert.ToString(execResult["AuthCardNo"]), PrcsDate = Convert.ToString(execResult["PrcsDate"]), TxnId = Convert.ToString(execResult["TxnId"]), ProductQty = Convert.ToString(execResult["ProductQty"]), ProductAmt = ConverterDecimal(execResult["ProductAmt"]), VATAmt = ConverterDecimal(execResult["VAT Amt"]), BaseAmt = ConverterDecimal(execResult["Base Amt"]), VATCd = Convert.ToString(execResult["VATCd"]), VATRate = ConverterDecimal(execResult["VATRate"]), ProductDescp = Convert.ToString(execResult["ProductDescp"]) }); } ; return(_MerchPostedTxnSearch); } finally { objDataEngine.CloseConnection(); } }
public async Task <List <TxnAdjustment> > GetTxnAdjustmentList(string AcctNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", AcctNo); var execResult = await objDataEngine.ExecuteCommandAsync("WebTxnAdjustmentListSelect", CommandType.StoredProcedure, Parameters); var _TxnAdjustmentList = new List <TxnAdjustment>(); var _TxnAdjustmentInfo = new List <TxnAdjustment>(); while (execResult.Read()) { _TxnAdjustmentList.Add(new TxnAdjustment { RefType = Convert.ToString(execResult["Txn Type"]), TxnDate = DateConverter(execResult["Txn Date"]), TotAmnt = ConverterDecimal(execResult["Txn Amount"]), DisplayTotAmt = ConverterDecimal(execResult["Txn Amount"]), BillingTxnAmt = ConverterDecimal(execResult["Billing Amount"]), Descp = Convert.ToString(execResult["Txn Description"]), StsDescp = Convert.ToString(execResult["Status"]), SelectedSts = Convert.ToString(execResult["Sts"]), UserId = Convert.ToString(execResult["User Id"]), //R SelectedTxnCd = Convert.ToString(execResult["TxnCd"]), TxnId = Convert.ToString(execResult["Txn Id"]), //R WithHeldUnsettleId = ConvertInt(execResult["WU Id"]), //R CreationDate = DateConverter(execResult["Creation Date"]), //R AppvRemarks = Convert.ToString(execResult["AppvRemarks"]), _CardnAccNo = new CardnAccNo { AccNo = Convert.ToString(execResult["Account No"]), CardNo = Convert.ToString(execResult["Card No"]) } }); } ; return(_TxnAdjustmentList); } finally { objDataEngine.CloseConnection(); } }
public async Task <TxnAdjustment> WebMerchantMultiTxnAdjustmentSelect(string InvoiceNo, string BatchId) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = new SqlParameter("@OrigBatchId", BatchId); Parameters[1] = new SqlParameter("@IssNo", GetIssNo); Parameters[2] = String.IsNullOrEmpty(InvoiceNo) ? new SqlParameter("@InvoiceNo", DBNull.Value) : new SqlParameter("@InvoiceNo", InvoiceNo); var execResult = await objDataEngine.ExecuteCommandAsync("WebMerchantMultiTxnAdjustmentSelect", CommandType.StoredProcedure, Parameters); var _Adj = new TxnAdjustment(); var txnList = new List <MultipleTxnRecord>(); while (execResult.Read()) { _Adj.SelectedTxnCd = Convert.ToString(execResult["TxnCd"]); _Adj.SelectedTxnType = Convert.ToString(execResult["Txn Type"]); _Adj.TxnDate = DateConverter(execResult["TxnDate"]); _Adj.ChequeAmt = ConverterDecimal(execResult["Cheque Amt"]); _Adj.SelectedOwner = Convert.ToString(execResult["Owner"]); _Adj.SelectedSts = Convert.ToString(execResult["Sts"]); _Adj.GroupingBatchId = Convert.ToString(execResult["Grouping BatchId"]); _Adj.BatchId = Convert.ToString(execResult["BatchId"]); _Adj.InvoiceNo = Convert.ToString(execResult["Invoice No"]); _Adj.SelectedSts = Convert.ToString(execResult["Approval Status"]); _Adj.StsDescp = Convert.ToString(execResult["Approval Desc"]); txnList.Add(new MultipleTxnRecord { TxnAmt = ConverterDecimal(execResult["Amt"]), MerchantAcctNo = Convert.ToString(execResult["Merchant No"]), AcctName = Convert.ToString(execResult["Merchant Name"]), TxnId = Convert.ToString(execResult["Ids"]), Descp = Convert.ToString(execResult["Description"]) }); } if (txnList.Any()) { _Adj.MultipleTxnRecord = txnList; } return(_Adj); } finally { objDataEngine.CloseConnection(); } }
public async static Task <MsgRetriever> GetMessageCode(int msgCd) { FleetDataEngine Engine = new FleetDataEngine(AccessMode.Admin, DBType.Maint); try { await Engine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[2]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@MsgCd", msgCd); Parameters[1] = new SqlParameter("@LangId", "EN"); var Reader = await Engine.ExecuteCommandAsync("WebGetMsg", CommandType.StoredProcedure, Parameters); while (Reader.Read()) { if (msgCd < 54999) { var tempData = new MsgRetriever { flag = Convert.ToInt32(Reader["Flag"]), desp = Convert.ToString(Reader["Descp"]) }; return(tempData); } else { var tempData = new MsgRetriever { flag = Convert.ToInt32(Reader["Flag"]), desp = Convert.ToString(Reader["Descp"]) }; return(tempData); } } return(new MsgRetriever { flag = 1, desp = "***" }); } finally { Engine.CloseConnection(); } }
public async Task <TxnAdjustment> GetTxnAdjustmentDetail(TxnAdjustment _TxnAdjustment) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { await objDataEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId); var execResult = await objDataEngine.ExecuteCommandAsync("WebTxnAdjustmentSelect", CommandType.StoredProcedure, Parameters); var _GetTxnAdjustmentDetail = new TxnAdjustment(); _GetTxnAdjustmentDetail._CardnAccNo = new CardnAccNo(); while (execResult.Read()) { _GetTxnAdjustmentDetail.TxnId = Convert.ToString(execResult["TxnId"]); _GetTxnAdjustmentDetail.TxnDate = DateConverter(execResult["TxnDate"]); _GetTxnAdjustmentDetail.DueDate = DateConverter(execResult["DueDate"]); _GetTxnAdjustmentDetail.SelectedTxnCd = Convert.ToString(execResult["TxnCd"]); _GetTxnAdjustmentDetail._CardnAccNo.CardNo = Convert.ToString(execResult["CardNo"]); _GetTxnAdjustmentDetail.TotAmnt = ConverterDecimal(execResult["TxnAmt"]); _GetTxnAdjustmentDetail.Totpts = ConverterDecimal(execResult["Pts"]); _GetTxnAdjustmentDetail.Descp = Convert.ToString(execResult["Descp"]); _GetTxnAdjustmentDetail.AppvCd = Convert.ToString(execResult["AppvCd"]); _GetTxnAdjustmentDetail.SelectedSts = Convert.ToString(execResult["Sts"]); _GetTxnAdjustmentDetail.UserId = Convert.ToString(execResult["UserId"]); _GetTxnAdjustmentDetail.WithHeldUnsettleId = ConvertInt(execResult["WithheldUnsettleId"]); _GetTxnAdjustmentDetail.CreationDate = DateConverter(execResult["CreationDate"]); _GetTxnAdjustmentDetail.SelectedOwner = Convert.ToString(execResult["Owner"]); } ; //if (string.IsNullOrEmpty(_GetTxnAdjustmentDetail.SelectedSts)) //{ // _GetTxnAdjustmentDetail.SelectedSts = "H"; //} return(_GetTxnAdjustmentDetail); } finally { objDataEngine.CloseConnection(); } }
public async Task <LookupParameters> WebRefSelect(string RefType, string RefCd, string RefNo, string RefId) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); var _globalVariable = new LookupParameters(); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[5]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", 1); Parameters[1] = String.IsNullOrEmpty(RefNo) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", RefNo); Parameters[2] = String.IsNullOrEmpty(RefId) ? new SqlParameter("@RefId", DBNull.Value) : new SqlParameter("@RefId", RefNo); Parameters[3] = String.IsNullOrEmpty(RefType) ? new SqlParameter("@RefType", DBNull.Value) : new SqlParameter("@RefType", RefType); Parameters[4] = String.IsNullOrEmpty(RefCd) ? new SqlParameter("@RefCd", DBNull.Value) : new SqlParameter("@RefCd", RefCd); var getObjData = await objEngine.ExecuteCommandAsync("WebRefSelect", CommandType.StoredProcedure, Parameters); while (getObjData.Read()) { if (RefType == "State") { _globalVariable.Country = Convert.ToString(getObjData["CtryCd"]); _globalVariable.StateCode = Convert.ToString(getObjData["StateCd"]); _globalVariable.StateName = Convert.ToString(getObjData["Descp"]); } else if (RefType == "City") { _globalVariable.ParameterCode = Convert.ToString(getObjData["ParamCd"]); _globalVariable.Country = Convert.ToString(getObjData["RefNo"]); _globalVariable.StateCode = Convert.ToString(getObjData["RefId"]); _globalVariable.CityName = Convert.ToString(getObjData["Descp"]); } else { _globalVariable.ParameterCode = Convert.ToString(getObjData["ParamCd"]); _globalVariable.ParameterDescp = Convert.ToString(getObjData["Descp"]); } } return(_globalVariable); } finally { objEngine.CloseConnection(); } }
public async Task <List <LookupParameters> > WebRefListSelect(string refType) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[2]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = new SqlParameter("@RefType", String.IsNullOrEmpty(refType) ? (object)DBNull.Value : refType); var getObjData = await objEngine.ExecuteCommandAsync("WebRefListSelect", CommandType.StoredProcedure, Parameters); var list = new List <LookupParameters>(); while (getObjData.Read()) { var item = new LookupParameters(); if (refType.ToLower() == "state") { item.Country = Convert.ToString(getObjData["Country"]); item.ParameterCode = Convert.ToString(getObjData["CtryCd"]); item.StateName = Convert.ToString(getObjData["StateName"]); item.StateCode = Convert.ToString(getObjData["StateCd"]); } else if (refType.ToLower() == "city") { item.Country = Convert.ToString(getObjData["Country"]); item.StateName = Convert.ToString(getObjData["State"]); item.ParameterCode = Convert.ToString(getObjData["ParamCd"]); item.CityName = Convert.ToString(getObjData["City"]); } else { item.ParameterDescp = Convert.ToString(getObjData["Descp"]); item.ParameterCode = Convert.ToString(getObjData["ParamCd"]); } list.Add(item); } return(list); } finally { objEngine.CloseConnection(); } }
public async static Task <IEnumerable <SelectListItem> > WebGetRefLib(string refType, string RefNo = null, string RefInd = null, string RefId = null, bool PrependNull = true) { var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { await objEngine.InitiateConnectionAsync(); SqlParameter[] Parameters = new SqlParameter[5]; SqlCommand cmd = new SqlCommand(); Parameters[0] = new SqlParameter("@IssNo", 1); Parameters[1] = new SqlParameter("@RefType", String.IsNullOrEmpty(refType) ? (object)DBNull.Value : refType); Parameters[2] = String.IsNullOrEmpty(RefNo) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", RefNo); Parameters[3] = String.IsNullOrEmpty(RefInd) ? new SqlParameter("@RefInd", DBNull.Value) : new SqlParameter("@RefInd", RefInd); Parameters[4] = String.IsNullOrEmpty(RefId) ? new SqlParameter("@RefId", DBNull.Value) : new SqlParameter("@RefId", RefId); var getObjData = await objEngine.ExecuteCommandAsync("WebGetRefLib", CommandType.StoredProcedure, Parameters); var list = new List <SelectListItem>(); if (PrependNull) { list.Add(new SelectListItem { Text = "", Value = "" }); } while (getObjData.Read()) { list.Add(new SelectListItem { Text = Convert.ToString(getObjData["Descp"]), Value = Convert.ToString(getObjData["RefCd"]), Selected = Convert.ToString(getObjData["RefCd"]) == "1" ? true : false }); } if (list.Count > 0) { list.First().Selected = true; } return(list); } finally { objEngine.CloseConnection(); } }
/* * public async Task<AcctSOA> WebAcctSOASummSelect(AcctSOA _AcctSOA) * { * var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); * try * { * await objDataEngine.InitiateConnectionAsync(); * SqlParameter[] Parameters = new SqlParameter[1]; * Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo); * * var Reader = await objDataEngine.ExecuteCommandAsync("WebAcctSOASummSelect", CommandType.StoredProcedure, Parameters); * * while (Reader.Read()) * { * * var _AcctSOASelect = new AcctSOA * { * CompanyID = Convert.ToString(Reader["Company Id"]), * CompanyName = Convert.ToString(Reader["Company Name"]), * BasicCard = Convert.ToString(Reader["Basic Card"]), * SelectedStmtDate = Convert.ToString(Reader["Cycle Date"]), * LastAgeCd = Convert.ToString(Reader["Last Age Code"]), * CreditLimit = ConverterDecimal(Reader["Credit Limit"]), * OpeningBal = ConverterDecimal(Reader["Opening Balance"]), * MTDDebits = ConverterDecimal(Reader["MTD Debits"]), * AvaiCredLimits = ConverterDecimal(Reader["Available Credit Limit"]), * CurrBalance = ConverterDecimal(Reader["Current Balance"]), * MTDCreds = ConverterDecimal(Reader["MTD Credits"]), * TotMinimumPymt = Convert.ToString(Reader["Total Minimun Payment"]), * CrrtDueMinimumOymt = ConverterDecimal(Reader["Current Due Minimun Payment"]), * PastDueMinimumPymt = Convert.ToString(Reader["Past Due Minimun Payment"]), * PymtDueDate = Convert.ToString(Reader["Payment DueDate"]), * LastPymtDate = Convert.ToString(Reader["Last Payment Date"]), * LastPymtAmt = ConverterDecimal(Reader["Last Payment Amount"]) * }; * return _AcctSOASelect; * } * return new AcctSOA(); * } * finally * { * objDataEngine.CloseConnection(); * * } * } */ /* * public async Task<List<AcctSOA>> WebAcctSOASummList(AcctSOA _AcctSOA) * { * var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); * * try * { * objDataEngine.InitiateConnection(); * SqlParameter[] Parameters = new SqlParameter[1]; * Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo); * * var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOASummList", CommandType.StoredProcedure, Parameters); * * var _SOAList = new List<AcctSOA>(); * while (execResult.Read()) * { * * _SOAList.Add(new AcctSOA * { * Month = Convert.ToString(execResult["Mth"]), * SelectedStmtDate = Convert.ToString(execResult["Statement Date"]), * ClseBalance = Convert.ToString(execResult["Closing Balance"]), * MinimumPayment = Convert.ToString(execResult["Minimun Payment"]), * Debits = Convert.ToString(execResult["Debits"]), * Credits = Convert.ToString(execResult["Credits"]), * Sales = Convert.ToString(execResult["Sales"]), * DBAdjust = Convert.ToString(execResult["DB adjustment"]), * Charges = Convert.ToString(execResult["Charges"]), * Payment = Convert.ToString(execResult["Payment"]), * CRAdjust = Convert.ToString(execResult["CR Adjustment"]), * age = Convert.ToString(execResult["Age"]), * Rchq = Convert.ToString(execResult["RChq"]), * Lpay = Convert.ToString(execResult["Lpay"]), * Rv = Convert.ToString(execResult["Rv"]), * Dun = Convert.ToString(execResult["Dun"]) * }); * }; * return _SOAList; * } * finally * { * objDataEngine.CloseConnection(); * } * * * } */ /* * public async Task<List<AcctSOA>> WebAcctSOATxnCategoryList(AcctSOA _AcctSOA) * { * var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); * * try * { * objDataEngine.InitiateConnection(); * SqlParameter[] Parameters = new SqlParameter[2]; * Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo); * Parameters[1] = String.IsNullOrEmpty(_AcctSOA.SelectedStmtDate) ? new SqlParameter("@StmtDate", DBNull.Value) : new SqlParameter("@StmtDate", _AcctSOA.SelectedStmtDate); * * var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOATxnCategoryList", CommandType.StoredProcedure, Parameters); * * var _SOATxnCategoryList = new List<AcctSOA>(); * while (execResult.Read()) * { * * _SOATxnCategoryList.Add(new AcctSOA * { * TxnCode = Convert.ToString(execResult["Transaction Code"]), * TxnEventCd = Convert.ToString(execResult["Transaction Event Code"]), * TxnDesc = Convert.ToString(execResult["Transaction Desc"]), * TotalCount = Convert.ToString(execResult["Total Count"]), * TotalAmt = ConverterDecimal(execResult["Total Amount"]), * TotalItemQty =Convert.ToString(execResult["Total Item Quantity"]), * TotalItemAmt = ConverterDecimal(execResult["Total Item Amount"]), * SelectedStmtDate = Convert.ToString(execResult["Statement Date"]), * CompanyName = Convert.ToString(execResult["Company Name"]), * AcctNo = Convert.ToString(execResult["Account No"]), * }); * }; * return _SOATxnCategoryList; * } * finally * { * objDataEngine.CloseConnection(); * } * } */ public async Task <List <AcctSOA> > WebAcctSOATxnList(AcctSOA _AcctSOA) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo); Parameters[1] = String.IsNullOrEmpty(_AcctSOA.SelectedStmtDate) ? new SqlParameter("@StmtDate", DBNull.Value) : new SqlParameter("@StmtDate", _AcctSOA.SelectedStmtDate); Parameters[2] = String.IsNullOrEmpty(_AcctSOA.TxnCode) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _AcctSOA.TxnCode); var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOATxnList", CommandType.StoredProcedure, Parameters); var _SOATxnList = new List <AcctSOA>(); while (execResult.Read()) { _SOATxnList.Add(new AcctSOA { //CompanyName = Convert.ToString(execResult["Company Name"]), CardHolderNo = Convert.ToString(execResult["CardHolder No"]), DriverCardNo = Convert.ToString(execResult["Driver Card No"]), TxnDate = Convert.ToString(execResult["Transaction Date"]), txnTime = Convert.ToString(execResult["Transaction Time"]), PostDate = Convert.ToString(execResult["Post Date"]), TxnCode = Convert.ToString(execResult["Txn Code"]), Curr = Convert.ToString(execResult["Curr"]), TxnAmt = ConverterDecimal(execResult["Transaction Amount"]), Amt = ConverterDecimal(execResult["Amount"]), ChqRefNo = Convert.ToString(execResult["Chq Ref No"]), MerchantID = Convert.ToString(execResult["Merchant ID"]), MerchantName = Convert.ToString(execResult["Merchant Name"]), DBAName = Convert.ToString(execResult["Trading Name Description"]), MCC = Convert.ToString(execResult["Mcc"]), RRn = Convert.ToString(execResult["RRN"]), }); } ; return(_SOATxnList); } finally { objDataEngine.CloseConnection(); } }