public IActionResult GetAll([FromBody] DataManagerRequest dm)
{
IEnumerable <HistorySaleView> DataSource = data.GetAll <HistorySaleView>();
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast <HistorySaleView>().Count();
if (dm.Skip != 0)
{
DataSource = operation.PerformSkip(DataSource, dm.Skip); //Paging
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
}
public IActionResult ForDropDown([FromBody] DataManagerRequest dm)
{
IEnumerable <Customers> DataSource = data.GetAll <Customers>();
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
int count = DataSource.Cast <Customers>().Count();
return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
}
public ActionResult allNews()
{
ClientModel m = new ClientModel();
m.lst_newsv = data.GetAll <News>();
return(View(m));
}
public ActionResult News()
{
AdminNewModel n = new AdminNewModel();
n.lst_news = data.GetAll <News>();
return(View(n));
}
public IActionResult ForDropDown([FromBody] DataManagerRequest dm)
{
IEnumerable <ProductSales> DataSource = data.GetAll <ProductSales>();
DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); // Search
}
if (dm.Where != null && dm.Where.Count > 0) // Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast <ProductSales>().Count();
return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
}
public ActionResult GetRole()
{
return(Json(data.GetAll <Roles>()));
}
public IActionResult Index()
{
var result = data.GetAll <SalesTotalByDayView>().LastOrDefault();
var resultReturn = data.GetAll <ReturnTotalByDayView>().LastOrDefault();
if (result == null)
{
ViewBag.pribl = 0;
ViewBag.totall = new SalesTotalByDayView()
{
RegDt = DateTime.Now.Date, IncomeCost = 0, SaleTotal = 0
};
}
else
{
ViewBag.pribl = result.SaleTotal - result.IncomeCost;
ViewBag.totall = result;
}
if (resultReturn == null)
{
ViewBag.rtotall = new ReturnTotalByDayView()
{
RegDt = DateTime.Now.Date, ReturnCost = 0
};
}
else
{
ViewBag.rtotall = resultReturn;
}
ViewBag.PrixodobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalIncomeTG;
ViewBag.ProdajaobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalSaleTG;
ViewBag.OptovayaobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalOptTG;
ViewBag.Prixodob = data.GetAll <AvProfit>().FirstOrDefault().TotalIncome;
ViewBag.Prodajaob = data.GetAll <AvProfit>().FirstOrDefault().TotalSale;
ViewBag.Optovayaob = data.GetAll <AvProfit>().FirstOrDefault().TotalOpt;
return(View());
}
