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));
}
