private static void AddWhereCondition(DashboardFilter aInfo) { var companycode = aInfo.CompanyCode; aInfo.CompanyCode = companycode.Replace(",", "','"); var divisioncode = aInfo.DivisionCode; aInfo.DivisionCode = divisioncode.Replace(",", "','"); var unitcode = aInfo.UnitCode; aInfo.UnitCode = unitcode.Replace(",", "','"); var departmentcode = aInfo.DepartmentCode; aInfo.DepartmentCode = departmentcode.Replace(",", "','"); var sectioncode = aInfo.SectionCode; aInfo.SectionCode = sectioncode.Replace(",", "','"); var subSectioncode = aInfo.SubSectionCode; aInfo.SubSectionCode = subSectioncode.Replace(",", "','"); var line = aInfo.LineCode; aInfo.LineCode = line.Replace(",", "','"); }
public int GetAllStatusPointsCount() { var emptyFilter = new DashboardFilter<StatusPointsColumnName>(); var queryFilters = _dashboardConditionFilters.GetElementFilter(emptyFilter, DashboardConditionFilterContext<AppraiserOrderSetPoint>.AppraiserOrderSetPointContext, BuildNewFilter()); return _appraiserOrderDeliveryService.GetSetPointsCount(queryFilters.ToFunc(emptyFilter)); }
// GET: DashboardFilter/DashboardDepartment public string DashboardDepartment(DashboardFilter aCompanyObj) { _aDashboardFilterHandler = new DashboardFilterHandler(); var data = _aDashboardFilterHandler.GetMpDepartments(aCompanyObj); return(JsonConvert.SerializeObject(data)); }
public IEnumerable<NewRequestViewModel> GetNewRequestCollection(DashboardFilter<NewRequestsColumnsName> filter) { var listFilter = BuildFilter(); listFilter = _dashboardConditionFilters.GetElementFilter(filter, DashboardConditionFilterContext<AppraiserOrder>.AppraiserOrderContext, listFilter); return _appraiserOrderDeliveryService.GetOrders(listFilter.ToFuncWithPagging(filter)).ToArray().Select(e => new NewRequestViewModel(e, _formsService)); }
public IEnumerable<HotListViewModel> GetHotListCollection(DashboardFilter<HotListColumnName> filter) { var hotListArg = BuildArg(); hotListArg.Order = filter.IsAsc ? "asc" : "desc"; switch (filter.ColumnName) { case HotListColumnName.Type: hotListArg.OrderColumn = "hotListType"; break; case HotListColumnName.OrderNumber: hotListArg.OrderColumn = "orderNumber"; break; case HotListColumnName.BorrowerName: hotListArg.OrderColumn = "borrower_firstName"; break; case HotListColumnName.Status: hotListArg.OrderColumn = "orderStatus"; break; case HotListColumnName.AppraiserName: hotListArg.OrderColumn = "user_lastName"; break; } hotListArg.PageNumber = filter.PageNumber; hotListArg.ElementPerPage = filter.ItemsPerPage; return _hotListManager.GetHotListCollection(hotListArg).Select(e => new HotListViewModel(e)); }
public int GetNewRequestCountCollection() { var emptyFilter = new DashboardFilter<NewRequestsColumnsName>(); var listFilter = BuildFilter(); listFilter = _dashboardConditionFilters.GetElementFilter(emptyFilter, DashboardConditionFilterContext<AppraiserOrder>.AppraiserOrderContext, listFilter); return _appraiserOrderDeliveryService.GetOrdersCount(listFilter.ToFunc(emptyFilter)); }
public int GetAllActiveAssignmentsCount() { var emptyFilter = new DashboardFilter<ActiveAssignmentColumnName>(); var listFilter = BuildFilter(); listFilter = _dashboardConditionFilters.GetElementFilter(emptyFilter, DashboardConditionFilterContext<AppraiserOrder>.AppraiserOrderListContext, listFilter); return _appraiserOrderDeliveryService.GetAppraiserOrderListItemsCount(listFilter.ToFunc(emptyFilter)); }
public void SetUp() { CurrentUser = Substitute.For<ICurrentUser>(); CurrentAppraiser = Substitute.For<ICurrentAppraiser>(); HotListManager = new HotListManagerStab(); Target = new HotListService(HotListManager, CurrentUser, new DashboardConditionFilters(CurrentUser, CurrentAppraiser)); DefaultFilter = new DashboardFilter<HotListColumnName> { ItemsPerPage = Int32.MaxValue, PageNumber = 1 }; }
public DataTable GetMpDepartments(DashboardFilter aInfo) { var departmentcode = aInfo.DepartmentCode; aInfo.DepartmentCode = departmentcode.Replace(",", "','"); this.aDashboardDa = new DashboardDA(); return(this.aDashboardDa.GetMpDepartmentsFromDb(aInfo.CompanyCode, aInfo.DivisionCode, aInfo.UnitCode, aInfo.DepartmentCode, aInfo.EmployeeType)); }
public PieChart GetExpense(DashboardFilter filter) { using var context = Context(); var organisationIds = filter.OrganisationIds; var totalExpense = context.Expense.Where(u => (u.ExpenseStatusId == (int)ExpenseStatusEnum.Approved || u.ExpenseStatusId == (int)ExpenseStatusEnum.Billed) && organisationIds.Any(t => t == u.OrganisationId) && u.CloseDate >= filter.FromDate && u.CloseDate <= filter.ToDate ) .Select(u => new { u.TotalIncludeTax, u.BaseCurrencyExchangeRate }) .Sum(u => u.TotalIncludeTax * u.BaseCurrencyExchangeRate); var totalEmployeeSalary = context.PayrollEmployee.Where(u => u.Date >= filter.FromDate && u.Date <= filter.ToDate) .Sum(u => u.Total); totalExpense += totalEmployeeSalary; var totalPendingBill = (from bill in context.Bill where organisationIds.Any(t => t == bill.IdNavigation.OrganisationId) && bill.IdNavigation.CloseDate >= filter.FromDate && bill.IdNavigation.CloseDate <= filter.ToDate && (bill.IdNavigation.ExpenseStatusId == (int)ExpenseStatusEnum.Draft || bill.IdNavigation.ExpenseStatusId == (int)ExpenseStatusEnum.WaitingForApproval) select bill.IdNavigation.TotalIncludeTax * bill.IdNavigation.BaseCurrencyExchangeRate ).Sum(); var totalPendingPurchaseOrder = (from purchaseOrder in context.PurchaseOrder where organisationIds.Any(t => t == purchaseOrder.IdNavigation.OrganisationId) && purchaseOrder.IdNavigation.CloseDate >= filter.FromDate && purchaseOrder.IdNavigation.CloseDate <= filter.ToDate && (purchaseOrder.IdNavigation.ExpenseStatusId == (int)ExpenseStatusEnum.Draft || purchaseOrder.IdNavigation.ExpenseStatusId == (int)ExpenseStatusEnum.WaitingForApproval) select purchaseOrder.IdNavigation.TotalIncludeTax * purchaseOrder.IdNavigation.BaseCurrencyExchangeRate ).Sum(); var totalUnpaid = (from expnse in context.Expense where organisationIds.Any(t => t == expnse.OrganisationId) && expnse.CloseDate >= filter.FromDate && expnse.CloseDate <= filter.ToDate && expnse.ExpenseStatusId == (int)ExpenseStatusEnum.Approved select expnse.TotalIncludeTax * expnse.BaseCurrencyExchangeRate ).Sum(); return(new PieChart { Labels = new List <string> { AppResource.GetResource("Total Expense"), AppResource.GetResource("Pending Bill"), AppResource.GetResource("Pending PO"), AppResource.GetResource("Un-Paid") }, Values = new List <decimal> { Math.Round(totalExpense.Value, 0), Math.Round(totalPendingBill.Value, 0), Math.Round(totalPendingPurchaseOrder.Value), Math.Round(totalUnpaid.Value), } }); }
public void SetUp() { AppraiserOrderDeliveryService = new AppraiserOrderDeliveryServiceStab(); SecurityContext = Substitute.For<ISecurityContext>(); CurrentAppraiser = Substitute.For<ICurrentAppraiser>(); DefaultFilter = new DashboardFilter<NewRequestsColumnsName> { ItemsPerPage = Int32.MaxValue, PageNumber = 1 }; Target = new NewRequestService(AppraiserOrderDeliveryService, SecurityContext, CurrentAppraiser, new DashboardConditionFilters(SecurityContext, CurrentAppraiser), Substitute.For<IAppraisalFormsService>()); }
public string DashboardDivision(DashboardFilter aInfo) { var userId = Session["UserId"].ToString(); if (true) { _aDashboardFilterHandler = new DashboardFilterHandler(); var data = _aDashboardFilterHandler.GetMpDivisions(userId, aInfo); return(JsonConvert.SerializeObject(data)); } }
private static void AddWhwereCondition(DashboardFilter aInfo) { var companycode = aInfo.CompanyCode; aInfo.CompanyCode = companycode.Replace(",", "','"); var divisioncode = aInfo.DivisionCode; aInfo.DivisionCode = divisioncode.Replace(",", "','"); var unitcode = aInfo.UnitCode; aInfo.UnitCode = unitcode.Replace(",", "','"); }
public DataTable GetMpUnits(string userId, DashboardFilter aInfo) { var companycode = aInfo.CompanyCode; aInfo.CompanyCode = companycode.Replace(",", "','"); var divisioncode = aInfo.DivisionCode; aInfo.DivisionCode = divisioncode.Replace(",", "','"); var unitcode = aInfo.UnitCode; aInfo.UnitCode = unitcode.Replace(",", "','"); return(this.aDashboardDa.GetMpUnitsFromDb(userId, aInfo.EmployeeType, aInfo.CompanyCode, aInfo.DivisionCode, aInfo.UnitCode, aInfo.DepartmentCode, aInfo.SectionCode, aInfo.SubSectionCode, aInfo.ActivityCode)); }
// GET: DashboardFilter/DashboardCompany public string DashboardCompany(DashboardFilter aInfo) { try { var userId = Session["UserId"].ToString(); if (true) { _aDashboardFilterHandler = new DashboardFilterHandler(); var data = _aDashboardFilterHandler.GetMpCompanies(userId, aInfo); return(JsonConvert.SerializeObject(data)); } } catch (Exception ex) { return(ex.Message); } }
public async Task <IActionResult> GetPinnar([FromBody] DashboardFilter filter) { var storeId = GetStoreId(); var fromDate = DateTime.Parse(filter.FromDate); var toDate = DateTime.Parse(filter.ToDate); var sales = await _sales.FindAsync(x => x.StoreId == storeId && x.SaleDate > fromDate && x.SaleDate < toDate); var list = new List <object>(); foreach (var group in sales.GroupBy(x => x.SaleDate)) { // DOES THIS WORK??? list.Add(new { Date = group.Key, Count = group.SelectMany(x => x.Subscriptions).Count() }); } return(Ok(list)); }
public string GetCompanyWise(DashboardFilter aInfo) { try { this.userId = Session["UserId"].ToString(); if (true) { this.aDaHandler = new DashboardDAHandler(); var data = this.aDaHandler.GetCompanywise(this.userId, aInfo); TempData["FilterData"] = data; return(JsonConvert.SerializeObject(data)); } } catch (Exception ex) { return(ex.Message); } }
public async Task <IActionResult> GetBusinessSalesData([FromBody] DashboardFilter filter) { var fromDate = DateTime.Parse(filter.FromDate); var toDate = DateTime.Parse(filter.ToDate); ////// fake data //////// var random = new Random(); var businessSalesData = new List <BusinessSalesData>(); for (var i = fromDate; i <= toDate; i = i.AddDays(1)) { businessSalesData.Add(new BusinessSalesData { Label = i.ToShortDateString(), Value = random.Next(5, 26) }); } ///////////////////////// return(Ok(businessSalesData)); }
public ActionResult GetExportToExcell(DashboardFilter aInfo) { try { DataTable data; if (TempData["FilterData"] == null) { var userId = Session["UserId"].ToString(); aDaHandler = new DashboardDAHandler(); data = aDaHandler.GetCompanywise(userId, aInfo); } else { data = TempData["FilterData"] as DataTable; } var fileName = "Daily_Attendance_Data_" + DateTime.Now.ToString("yyyy_dd_M_HH_mm_ss") + ".xls"; var gv = new GridView { DataSource = data }; gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=" + fileName); Response.ContentType = "application/ms-excel"; Response.Charset = ""; var sw = new StringWriter(); var htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); return(View("Index")); } catch (Exception ex) { throw new HttpException(404, "Not found"); } }
public List <DashboardFilter> GetSinalsOfClients(List <Dictionary <string, string> > Macs) { try { if (Macs == null || Macs.Count <= 0) { throw new Exception("Endereco mac inválido"); } List <DashboardFilter> retornos = new List <DashboardFilter>(); foreach (var item in Macs) { var id = item["Id"]; var mac = item["Mac"]; var retorno = new DashboardFilter() { Id = Convert.ToInt64(id), Mac = mac }; try { retorno.Retorno = JSONHelper.GetJSONString("http://apiniveldesinais.azurewebsites.net/api/sinais/" + mac); } catch (Exception e) { retorno.Erro = true; } retornos.Add(retorno); } return(retornos); } catch (Exception e) { throw new AppException("Erro ao obter os sinais do usuario!", e.StackTrace); } }
public PieChart GetIncome(DashboardFilter filter) { using var context = Context(); var organisationIds = filter.OrganisationIds; var totalInvoice = context.Invoice.Where(u => organisationIds.Any(t => t == u.IdNavigation.OrganisationId) && u.IdNavigation.Date >= filter.FromDate && u.IdNavigation.Date <= filter.ToDate ) .Select(u => new { u.IdNavigation.TotalIncludeTax, u.IdNavigation.BaseCurrencyExchangeRate }) .Sum(u => u.BaseCurrencyExchangeRate * u.TotalIncludeTax); var totalOpeningQuote = context.Quote.Where(u => organisationIds.Any(t => t == u.OrganisationId) && u.Date >= filter.FromDate && u.Date <= filter.ToDate && (u.StatusId != (int)QuoteEnum.Delete && u.StatusId != (int)QuoteEnum.Declined && u.StatusId != (int)QuoteEnum.Invoiced) ).Sum(u => u.TotalIncludeTax * u.BaseCurrencyExchangeRate); var totalNotePaid = context.Invoice.Where(u => organisationIds.Any(t => t == u.IdNavigation.OrganisationId) && u.IdNavigation.Date >= filter.FromDate && u.IdNavigation.Date <= filter.ToDate && u.StatusId == (int)InvoiceStatusEnum.WaitingForPayment ).Select(u => new { u.IdNavigation.TotalIncludeTax, u.IdNavigation.BaseCurrencyExchangeRate }) .Sum(u => u.BaseCurrencyExchangeRate * u.TotalIncludeTax); return(new PieChart { Labels = new List <string> { AppResource.GetResource("Total Invoice"), AppResource.GetResource("Pending Quote"), AppResource.GetResource("Un-Paid Invoice") }, Values = new List <decimal> { Math.Round(totalInvoice, 0), Math.Round(totalOpeningQuote.Value, 0), Math.Round(totalNotePaid) } }); }
public PieChart GetProfiteAndLost(DashboardFilter filter) { using var context = Context(); var organisationIds = filter.OrganisationIds; var totalInvoice = context.Invoice.Where(u => organisationIds.Any(t => t == u.IdNavigation.OrganisationId) && u.IdNavigation.Date >= filter.FromDate && u.IdNavigation.Date <= filter.ToDate ) .Select(u => new { u.IdNavigation.TotalIncludeTax, u.IdNavigation.BaseCurrencyExchangeRate }) .Sum(u => u.BaseCurrencyExchangeRate * u.TotalIncludeTax); var totalExpense = context.Expense.Where(u => (u.ExpenseStatusId == (int)ExpenseStatusEnum.Approved || u.ExpenseStatusId == (int)ExpenseStatusEnum.Billed) && organisationIds.Any(t => t == u.OrganisationId) && u.CloseDate >= filter.FromDate && u.CloseDate <= filter.ToDate ) .Select(u => new { u.TotalIncludeTax, u.BaseCurrencyExchangeRate }) .Sum(u => u.TotalIncludeTax * u.BaseCurrencyExchangeRate); var totalEmployeeSalary = context.PayrollEmployee.Where(u => u.Date >= filter.FromDate && u.Date <= filter.ToDate) .Sum(u => u.Total); totalExpense += totalEmployeeSalary; return(new PieChart { Labels = new List <string> { AppResource.GetResource("Income"), AppResource.GetResource("Expense"), AppResource.GetResource("Profit & Lost") }, Values = new List <decimal> { Math.Round(totalInvoice, 0), Math.Round(totalExpense.Value, 0), Math.Round(totalInvoice - totalExpense.Value) } }); }
/// <summary> /// Получить контакты /// </summary> /// <param name="state">Статус контакта</param> /// <param name="sub_filter">Фильтр контакта</param> /// <returns></returns> /// Возвращается список контактов, попадающих под фильтры /// Каждый элемент списка представляет из себя структуру: /// { /// "data": { /// "created_at": "2013-12-06T15:23:01.61", /// "buyer": { /// "username": "******", /// "trade_count": "30+", /// "feedback_score": "100", /// "name": "hylje (30+; 100)", /// "last_online": "2013-12-19T08:28:16+00:00", /// "real_name": string or null if ONLINE trade where you are the seller, /// "company_name": string or null if ONLINE trade where you are the seller, /// "real_name_verifiers": [{"username": "******", "verified_at": "2016-10-13T13:49:45+00:00"}] if ONLINE trade where you are the seller, /// "countrycode_by_ip": string or null if ONLINE trade where you are the seller, /// "countrycode_by_phone_number": string or null if ONLINE trade where you are the seller /// } /// "seller": { /// "username": "******", /// "trade_count": "100+", /// "feedback_score": "100", /// "name": "jeremias (100+; 100)", /// "last_online": "2013-12-19T06:28:51+00:00" /// } /// "reference_code": "123", /// "currency": "EUR", /// "amount": "105.55", /// "amount_btc": "190", /// "fee_btc": "1.9", /// "exchange_rate_updated_at": "2013-06-20T15:23:01+00:00", /// "advertisement": { /// "id": 123, /// "trade_type": "ONLINE_SELL" /// "advertiser": { /// "username": "******", /// "trade_count": "100+", /// "feedback_score": "100", /// "name": "jeremias (100+; 100)", /// "last_online": "2013-12-19T06:28:51.604754+00:00" /// } /// }, /// "contact_id": 1234 /// "canceled_at": null, /// "escrowed_at": "2013-12-06T15:23:01+00:00", /// "funded_at": "2013-12-06T15:23:01+00:00", /// "payment_completed_at": "2013-12-06T15:23:01+00:00", /// "disputed_at": null, /// "closed_at": null, /// "released_at": null, /// "is_buying": true, /// "is_selling": false, /// "account_details": ! see below, /// "account_info": Payment details of ONLINE_SELL as string, if account_details is missing., /// "floating": boolean if LOCAL_SELL /// }, /// "actions": { /// "mark_as_paid_url": "/api/contact_mark_as_paid/1/", /// "advertisement_public_view": "/ads/123", /// "message_url": "/api/contact_messages/1234", /// "message_post_url": "/api/contact_message_post/1234" /// } /// } protected string getDashboard_as_string(DashboardStates state = DashboardStates.Open, DashboardFilter sub_filter = DashboardFilter.All) { return(sendRequest("/api/dashboard/" + (state == DashboardStates.Open ? "" : Enum.GetName(typeof(DashboardStates), state).ToLower() + "/") + (sub_filter == DashboardFilter.All ? "" : Enum.GetName(typeof(DashboardFilter), sub_filter).ToLower() + "/"), null, "get")); }
public IActionResult GetExpense([FromBody] DashboardFilter filter) { return(Ok(pieChartService.GetExpense(filter))); }
public IActionResult GetProfiteAndLost([FromBody] DashboardFilter filter) { return(Ok(pieChartService.GetProfiteAndLost(filter))); }
public object GetMpCompanies(string userId, DashboardFilter aInfo) { AddWhwereCondition(aInfo); return(_aDashboardFilterMp.GetMpCompanyFromDb(userId, aInfo.EmployeeType, aInfo.CompanyCode, aInfo.DivisionCode, aInfo.UnitCode, aInfo.DepartmentCode, aInfo.SectionCode, aInfo.SubSectionCode, aInfo.ActivityCode)); }
public DataTable GetCompanywise(string userId, DashboardFilter aInfo) { AddWhereCondition(aInfo); return(aDashboardDa.GetCompanyWiseFromDb(userId, aInfo.EmployeeType, aInfo.CompanyCode, aInfo.DivisionCode, aInfo.UnitCode, aInfo.DepartmentCode, aInfo.SectionCode, aInfo.SubSectionCode, aInfo.LineCode, aInfo.CurrentDate, aInfo.ActivityCode)); }
private static Func<IQueryable<DVSUserDashboardItem>, IOrderedQueryable<DVSUserDashboardItem>> GetSortingOrder(DashboardFilter<DVSUserDashboardColumn> filter, DVSUserDashboardColumn defaultColumn, bool defaultIsAsc) { var targetOrder = OrderItems.FirstOrDefault(e => e.ColumnName == filter.ColumnName && e.IsAsc == filter.IsAsc); return targetOrder != null ? targetOrder.SortingOrder : OrderItems.Single(e => e.ColumnName == defaultColumn && e.IsAsc == defaultIsAsc).SortingOrder; }
public IEnumerable<ActiveAssignmentViewModel> GetActiveAssignments(DashboardFilter<ActiveAssignmentColumnName> filter) { var listFilter = BuildFilter(); listFilter = _dashboardConditionFilters.GetElementFilter(filter, DashboardConditionFilterContext<AppraiserOrderListItem>.AppraiserOrderListContext, listFilter); return _appraiserOrderDeliveryService.GetAppraiserOrderListItems(listFilter.ToFuncWithPagging(filter)).ToArray().Select(CreateActiveAssignmentViewModel); }
public IEnumerable<StatusPointsViewModel> GetStatusPoints(DashboardFilter<StatusPointsColumnName> filter) { var statusPointfilter = BuildNewFilter(); statusPointfilter = _dashboardConditionFilters.GetElementFilter(filter, DashboardConditionFilterContext<AppraiserOrderSetPoint>.AppraiserOrderSetPointContext, statusPointfilter); return _appraiserOrderDeliveryService.GetSetPoints(statusPointfilter.ToFuncWithPagging(filter)).ToList().Select(e => new StatusPointsViewModel(e)); }