//SALES
public ActionResult SalesList(int page = 1, int?good = null)
{
ViewBag.Goods = new SelectList(repository.PureGoods().ToList(), "Id", "Title");//категории для формирования DropListDown
List <Sale> itemsperpage = new List <Sale>();
itemsperpage = repository.Sales(page, good).ToList();//все элементы на странице
List <Sale> totalitems = new List <Sale>();
totalitems = repository.Sales(good).ToList();//всего элементов в категории
//формируем модель для отображения
SaleListView model = new SaleListView()
{
good = good,
Sales = itemsperpage,
paginginfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = PageSize,
TotalItems = totalitems.Count()
}
};
return(View(model));
}
public ActionResult SaleHistory(SaleListView listview)
{
List <SalePoint> salepointlist = AgroExpressDBAccess.GetallEnabledSalePoint();
if (salepointlist != null)
{
listview.salepointlist = salepointlist.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
}
List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea();
if (arealist != null)
{
listview.arealist = arealist.Select(x => new SelectListItem
{
Value = x.PKAreaId.ToString(),
Text = x.AreaName
});
}
List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea();
if (sarealist != null)
{
listview.subarealist = sarealist.Select(x => new SelectListItem
{
Value = x.PKSubAreaId.ToString(),
Text = x.SubAreaName
});
}
var customerlist = AgroExpressDBAccess.GetallEnabledCustomer();
if (customerlist != null)
{
listview.selectedcustomerlist = customerlist.Select(x => new SelectListItem
{
Value = x.PKCustomerId.ToString(),
Text = x.FullName
});
}
var productList = AgroExpressDBAccess.GetAllEnabledProduct();
if (productList != null)
{
listview.selectedproductlist = productList.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
}
var saleifo = AgroExpressDBAccess.GetSaleInfoByDate(listview.EntryDateMin, listview.EntryDateMax.AddDays(1));
if (listview.AmountVMax != null)
{
saleifo = saleifo.Where(a => a.Amount <= listview.AmountVMax).ToList();
}
if (listview.AmountVMin != null)
{
saleifo = saleifo.Where(a => a.Amount >= listview.AmountVMin).ToList();
}
if (listview.CustomerID != null)
{
saleifo = saleifo.Where(a => a.CustomerId == listview.CustomerID).ToList();
}
if (listview.SelectedProductID != null)
{
saleifo = saleifo.Where(a => a.ProductId == listview.SelectedProductID).ToList();
}
List <Area> AreList = new List <Area>();
List <SubArea> subAreList = AgroExpressDBAccess.GetallEnabledSubArea();
if (listview.SalePointId != null)
{
AreList = AgroExpressDBAccess.GetAreaBySalePointID((int)listview.SalePointId);
if (AreList != null)
{
subAreList = subAreList
.Where(x => AreList.Any(y => y.PKAreaId == x.AreaId)).ToList();
}
customerlist = customerlist.Where(customer => subAreList.Any(subarea => subarea.PKSubAreaId == customer.SubAreaId)).ToList();
saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList();
}
if (listview.AreaId != null)
{
subAreList = subAreList.Where(su => su.AreaId == listview.AreaId).ToList();
customerlist = customerlist.Where(customer => subAreList.Any(subarea => subarea.PKSubAreaId == customer.SubAreaId)).ToList();
saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList();
}
if (listview.SubAreaId != null)
{
customerlist = customerlist.Where(customer => customer.SubAreaId == listview.SubAreaId).ToList();
saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList();
}
List <SaleList> sale = new List <SaleList>();
if (saleifo != null)
{
foreach (var li in saleifo)
{
sale.Add(new SaleList
{
DateTime = li.DateTime,
CustomerName = li.customer.FullName,
ProductName = li.product.ProductName,
Amount = li.Amount,
SMSSent = li.SMSSent,
OperatorName = li.OperatorName
});
}
}
listview.salelist = sale;
return(View(listview));
}
public ActionResult SaleHistory()
{
SaleListView listview = new SaleListView();
List <SalePoint> salepointlist = AgroExpressDBAccess.GetallEnabledSalePoint();
if (salepointlist != null)
{
listview.salepointlist = salepointlist.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
}
List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea();
if (arealist != null)
{
listview.arealist = arealist.Select(x => new SelectListItem
{
Value = x.PKAreaId.ToString(),
Text = x.AreaName
});
}
List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea();
if (sarealist != null)
{
listview.subarealist = sarealist.Select(x => new SelectListItem
{
Value = x.PKSubAreaId.ToString(),
Text = x.SubAreaName
});
}
var customerlist = AgroExpressDBAccess.GetallEnabledCustomer();
if (customerlist != null)
{
listview.selectedcustomerlist = customerlist.Select(x => new SelectListItem
{
Value = x.PKCustomerId.ToString(),
Text = x.FullName
});
}
var productList = AgroExpressDBAccess.GetAllEnabledProduct();
if (productList != null)
{
listview.selectedproductlist = productList.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
}
listview.EntryDateMax = System.DateTime.Now.Date.AddDays(1);
listview.EntryDateMin = listview.EntryDateMax.AddDays(-30);
var saleifo = AgroExpressDBAccess.GetSaleInfoByDate(listview.EntryDateMin, listview.EntryDateMax);
List <SaleList> sale = new List <SaleList>();
if (saleifo != null)
{
foreach (var li in saleifo)
{
sale.Add(new SaleList
{
DateTime = li.DateTime,
CustomerName = li.customer.FullName,
ProductName = li.product.ProductName,
Amount = li.Amount,
Total = (li.Amount * li.Rate) + (li.Amount * li.ServiceCharge),
SMSSent = li.SMSSent,
OperatorName = li.OperatorName
});
}
}
listview.salelist = sale;
return(View(listview));
}
