public ActionResult RunAccountStatus([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut, int status = -1) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_report_msv_portfolio_AccountsByType", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var agent = GetLoggedUserId(); var reportData = _virtualOfficeService.RunMerchantServicesPortfolioByAccountsType(agent, status); var mappedResult = reportData.MapTo<IEnumerable<PortfolioAccountsByType>, IEnumerable<MsAccountStatusViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunComissionSummaryTotal([DataSourceRequest] DataSourceRequest request, int? agentId, DateTime startDate, DateTime endDate, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_report_msv_commission_details_by_totals", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var agent = agentId.HasValue && agentId != 0 ? agentId.Value : GetLoggedUserId(); var reportData = _virtualOfficeService.RunMsComissionDetailsByTotals(agent, startDate, endDate).Distinct(new MsComissionSummaryByTotalsComparer()); var mappedResult = reportData.MapTo<IEnumerable<MsCommissionSummaryByTotals>, IEnumerable<MsCommissionSummaryByTotalsViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunUpdateCommission([DataSourceRequest] DataSourceRequest request, string selectedUsers, string outPut, bool saveOutPut, string code, string name) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_Send_CommissionReport", outPutDeserialized.GetCommaSeparatedTokens()); } if (selectedUsers == null) return null; var productsCommissions = new List<CommissionByProductViewModel>(); var users = new JavaScriptSerializer().Deserialize<List<string>>(selectedUsers); var userLevel = GetUserLevel(); foreach (var userCode in users) { if (string.IsNullOrEmpty(userCode)) throw new Exception("User Id not valid"); var user = _virtualOfficeService.GetUser(userCode); var reportData = _virtualOfficeService.ProductsCommission(user.userid, user.usertype == 0); var mappedResult = reportData.Select(p => { var commissions = new[] {p.mercomm, p.agentcomm, p.distcomm, p.isocomm}; return new CommissionByProductViewModel { UserId = userCode, UserDescription = user.username, Product = p.pro_description, ProductCode = p.merproduct_sbt, MyCommission = commissions[userLevel], Actual = commissions[user.usertype], OldCommission = commissions[user.usertype], }; }); productsCommissions.AddRange(mappedResult.Where(p => p.ProductCode.StartsWith(code) && p.Product.ToLower().StartsWith(name.ToLower()))); } var result = productsCommissions.ToDataSourceResult(request); return Json(result); } catch (Exception) { return null; } }
public ActionResult RunAccountsInCollection([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "AccountsInCollection", outPutDeserialized.GetCommaSeparatedTokens()); } var reportData = _virtualOfficeService.GetAccountsInCollection(GetLoggedUserId()); var mappedResult = reportData.MapTo<IEnumerable<AccountsInCollectionResult>, IEnumerable<PrepaidAccountsInCollectionViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunTodayTransactions([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "Sp_get_Today_Transactions", outPutDeserialized.GetCommaSeparatedTokens()); } var userLevel = GetUserLevel(); var agentId = userLevel != 0 ? GetLoggedUserId() : 0; var merchantId = userLevel == 0 ? GetLoggedUserId() : 0; var reportData = _virtualOfficeService.RunTodayTransactions(agentId, merchantId); var mappedResult = reportData.MapTo<IEnumerable<PrepaidTodayTransactionsResult>, IEnumerable<PrepaidTodayTransactionsViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunTransactionsSummary([DataSourceRequest] DataSourceRequest request, string startDate, string endDate, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "Sp_TransactionsSummary", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var dateRange = GetDateRange(startDate, endDate); var userIsMerchant = GetUserCategory() == Category.Merchant; var reportData = _virtualOfficeService.GetTransactionsSummary(GetLoggedUserId(), userIsMerchant, dateRange.StartDate, dateRange.EndDate); var mappedResult = reportData.MapTo<IEnumerable<TransactionSummaryResult>, IEnumerable<TransactionSummaryViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunPortfolioSummary([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut, int? alertsMode, int status = -1) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_report_portfolio_summary", outPutDeserialized.GetCommaSeparatedTokens()); } var reportData = _virtualOfficeService.RunPrepaidPortfolioSummary(GetLoggedUserId()); switch (status) { case 1: reportData = reportData.Where(c => c.UserStatus == UserStatus.Active); break; case 0: reportData = reportData.Where(c => c.UserStatus == UserStatus.Suspended || c.UserStatus == UserStatus.Close); break; } if (alertsMode.HasValue && alertsMode.Value != 0)//Filters just accounts with Alerts { reportData = reportData.Where( c => ((status == -1 || status == 2) && c.UserStatus == UserStatus.Suspended) || ((status == -1 || status == 3) && (c.UserStatus == UserStatus.Close && decimal.Parse(c.Balance, NumberStyles.Currency) > 0)) || ((status == -1 || status == 4) && c.compliance.HasValue && c.compliance.Value)); } var mappedResult = reportData.MapTo<IEnumerable<PrepaidPortfolioResult>, IEnumerable<PrepaidPortfolioSummaryResultViewModel>>().ToList(); var result = mappedResult.ToDataSourceResult(request); _virtualOfficeService.LogReportResult(GetLoggedUserId().ToString(), "Prepaid Portfolio Summary", mappedResult.Count(), Utils.MaximunReportCount); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunChildrenByAgentReport([DataSourceRequest] DataSourceRequest request, string name, string code, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_Send_CommissionReport", outPutDeserialized.GetCommaSeparatedTokens()); } var reportData = _virtualOfficeService.GetChildrenByAgent(GetLoggedUserId()); reportData = reportData.Where(r => r.Code.StartsWith(code) && r.Name.ToLower().StartsWith(name.ToLower())); var mappedResult = reportData.MapTo<IEnumerable<ChildrenByAgentReport>, IEnumerable<ChildrenByAgentViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception) { return null; } }
public ActionResult RunMerchantCreditLimits([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "GetMerchantCreditLimits", outPutDeserialized.GetCommaSeparatedTokens()); } var userCategory = GetUserCategory(); var reportData = userCategory == Category.Merchant ? _virtualOfficeService.GetMerchantCreditLimits(null, GetLoggedUserId()) : _virtualOfficeService.GetMerchantCreditLimits(GetLoggedUserId(), null); var mappedResult = reportData.MapTo<IEnumerable<GetMerchantCreditLimitsResult>, IEnumerable<MerchantCreditLimitResultViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunMerchantStatements([DataSourceRequest] DataSourceRequest request, string startDate, string endDate, int merchantId, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "Sp_GetMerchantStatement", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var reportData = _virtualOfficeService.GetMerchantStatements(merchantId, startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<MerchantStatementResult>, IEnumerable<MerchantStatementResultViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunIppBrowser([DataSourceRequest] DataSourceRequest request, DateTime startDate, DateTime endDate, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_ippBrowser", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var userLevel = GetUserLevel(); var agentId = userLevel != 0 ? GetLoggedUserId() : 0; var merchantId = userLevel == 0 ? GetLoggedUserId() : 0; var reportData = _virtualOfficeService.RunIppBrowser(agentId, merchantId, startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<IppBrowserResult>, IEnumerable<IppBrowserResultViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }
public ActionResult RunFullcargaPrepaidSummary([DataSourceRequest] DataSourceRequest request, DateTime startDate, DateTime endDate, string outPut, bool saveOutPut) { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_Fullcarga_PrepaidSalesSummary", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var userIsMerchant = GetUserCategory() == Category.Merchant; var reportData = _virtualOfficeService.GetFullcargaPrepaidSummary(GetLoggedUserId(), userIsMerchant, startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<FullcargaPrepaidSummary>, IEnumerable<FullcargaPrepaidSummaryViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); }
public ActionResult RunFullcargaInvoiceDetails([DataSourceRequest] DataSourceRequest request, string outPut, bool saveOutPut, int invoiceId = 0) { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_Fullcarga_DetailInvoice", outPutDeserialized.GetCommaSeparatedTokens()); } var userLevel = GetUserLevel(); var userId = userLevel != 0 ? GetLoggedUserId() : 0; var reportData = _virtualOfficeService.GetFullcargarInvoiceDetail(invoiceId, userId); var mappedResult = reportData.MapTo<IEnumerable<FullcargaInvoiceDetail>, IEnumerable<FullcargaInvoiceDetailViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); }
public ActionResult RunPortfolioSummary([DataSourceRequest] DataSourceRequest request,string outPut, bool saveOutPut, int status = 1) { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_report_msv_portfolio_summary", outPutDeserialized.GetCommaSeparatedTokens()); } var userId = Roles.IsUserInRole(RolesEnum.Master.ToString())? 0: GetLoggedUserId(); var reportData = _virtualOfficeService.RunMsPortfolioSummary(userId).ToList(); var accounts = reportData.Where(r => r.Status != -1 && ((r.Status == 1 && status == 1) || (r.Status != 1 && status == 0))); var mappedResult = accounts.MapTo<IEnumerable<MsPortfolioResult>, IEnumerable<MsPortfolioResultViewModel>>().ToList(); var result = mappedResult.ToDataSourceResult(request); _virtualOfficeService.LogReportResult(GetLoggedUserId().ToString(), "MS Portfolio Summary", mappedResult.Count(), Utils.MaximunReportCount); return Json(result); }
public ActionResult RunSalesDetails([DataSourceRequest] DataSourceRequest request, DateTime startDate, DateTime endDate, string outPut, bool saveOutPut, int merchantId = 0) { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_report_sales_details", outPutDeserialized.GetCommaSeparatedTokens()); } var reportData = _virtualOfficeService.RunPrepaidSalesDetails(merchantId, startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<PrepaidSalesDetailsResult>, IEnumerable<PrepaidSalesDetailsResultViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); }
public ActionResult RunTransactionSummary([DataSourceRequest] DataSourceRequest request, DateTime startDate, DateTime endDate, string outPut, bool saveOutPut) { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "sp_getTransactions", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var reportData = _virtualOfficeService.RunTransactionSummary(GetLoggedUserId(), startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<MsTransactionSummaryResult>, IEnumerable<MsTransactionSummaryViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); }
public ActionResult RunAccountRegister([DataSourceRequest] DataSourceRequest request, string startDate, string endDate, string outPut, bool saveOutPut) { try { if (saveOutPut) { var outPutDeserialized = new JavaScriptSerializer().Deserialize<List<string>>(outPut); _virtualOfficeService.UpdateUserReportOutPut(GetLoggedUserId(), "SP_ShowAccountRegister", outPutDeserialized.GetCommaSeparatedTokens()); } //SaveLastDateRangeInSession(startDate, endDate); var agentType = GetLoggedAgentType(); var reportData = _virtualOfficeService.RunAccountRegister(agentType, GetLoggedUserId(), startDate, endDate); var mappedResult = reportData.MapTo<IEnumerable<AccountRegisterResult>, IEnumerable<PrepaidAccountRegisterViewModel>>(); var result = mappedResult.ToDataSourceResult(request); return Json(result); } catch (Exception exception) { return null; } }