private ApplicationUser IfUserDoesNotExitCreateTheUser(ApplicationUser user)
{
var password = TransfromerManager.DefaultPassword();
var result = _userManager.CreateAsync(user, password).Result;
return(result.Succeeded ? _userManager.FindByEmailAsync(user.Email).Result : user);
}
public IActionResult LastSevenDays(
string sortOrder,
string currentFilter,
string searchString,
int?page
)
{
ViewData["ControllerName"] = "ADMIN/REPORTS/ORDERS/LAST-7-DAYS";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var orders = !String.IsNullOrEmpty(searchString) ?
_ordersAndSalesService.Get(s => s.AddToCartDate.Date > DateTime.Now.Date.AddDays(-8) &&
s.CartNumber.Equals(searchString))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName)
: _ordersAndSalesService.Get(s => s.AddToCartDate.Date > DateTime.Now.Date.AddDays(-8))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName);
var totalIn = orders.Count();
ViewData["Totals"] = TransfromerManager.IntegerHuamanized(totalIn);
ViewData["Product"] = orders.Select(s => s.Product.Name).Distinct();
ViewData["ProductCategory"] = orders.Select(s => s.Product.ProductCategory.Name).Distinct();
var list = orders.Select(item => new OrdersView
{
Id = (int)item.Id,
Product = item.Product.Name,
Category = item.Product.ProductCategory.Name,
Customer = item.Person.FullName,
// CustNo = item.Person.MembershipNo,
Amount = TransfromerManager.DecimalHumanizedX(item.Amount),
TransactionDate = item.AddToCartDate.ToString(),
CartNumber = item.CartNumber,
TransactionNumber = item.PaymentTransactionNumber,
TransactionStatus = item.TransactionStatus,
AddToCartDate = TransfromerManager.DateHumanized(item.AddToCartDate),
//Date = item.OrderDate.ToString()
})
.ToList();
int pageSize = 20;
return(View(PaginatedList <OrdersView> .Create(list.AsQueryable(), page ?? 1, pageSize)));
}
public IActionResult Interest(
string sortOrder,
string currentFilter,
string searchString,
int?page
)
{
ViewData["ControllerName"] = "Admin/Expression Of Interest";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var orders = !String.IsNullOrEmpty(searchString) ?
_ordersAndSalesService.Get(s => s.Product.ProductTypes.Equals("Expression of Interest") &&
s.CartNumber.Equals(searchString))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName)
: _ordersAndSalesService.Get(s => s.Product.ProductTypes.Equals("Expression of Interest"))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName);
var list = orders.Select(item => new OrdersView
{
Id = (int)item.Id,
Product = item.Product.Name,
Category = item.Product.ProductCategory.Name,
Customer = item.Person.FullName,
//CustNo = item.Person.MembershipNo,
Amount = TransfromerManager.DecimalHumanizedX(item.Amount),
AddToCartDate = TransfromerManager.DateHumanized(item.AddToCartDate),
})
.ToList();
int pageSize = 20;
return(View(PaginatedList <OrdersView> .Create(list.AsQueryable(), page ?? 1, pageSize)));
}
public IActionResult Index(
string sortOrder,
string currentFilter,
string searchString,
int?page
)
{
ViewData["ControllerName"] = "ADMIN/DASHBOARD";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var sales = ReturnSales(searchString);
var orders = ReturnOrders(searchString);
var expression = ReturnExpressionOfInterest(searchString);
var customer = ReturnCustomer(searchString);
var dashboard = new DashBoardView();
dashboard.RecentOrders = ReturnPurchese(searchString).OrderByDescending(s => s.AddToCartDate).Take(50).ToList();
dashboard.Customers = TransfromerManager.IntegerHuamanized(customer);
dashboard.Sales = TransfromerManager.DecimalHumanizedX(sales);
dashboard.Orders = TransfromerManager.IntegerHuamanized(orders);
dashboard.ExpressionOfINterest = TransfromerManager.IntegerHuamanized(expression);
return(View(dashboard));
}
public IQueryable <PurchaseOrderViewModel> GetRecentOrders(Func <PurchaseOrders, bool> predicate = null)
{
var resultingData = new List <PurchaseOrderViewModel>();
var data = predicate != null
? _context.PurchaseOrders
.Include(s => s.Person)
.Include(s => s.Product).Include(s => s.Product.ProductCategory)
.Where(predicate: predicate)
.AsQueryable()
: _context.PurchaseOrders
.Include(s => s.Person)
.Include(s => s.Product).Include(s => s.Product.ProductCategory)
.AsQueryable();
foreach (var item in data)
{
resultingData.Add(new PurchaseOrderViewModel
{
Id = item.Id,
Customer = item.Person.FullName,
ProductCateogry = item.Product.ProductCategory.Name,
ProductName = item.Product.Name,
ProductType = item.Product.ProductTypes,
AddToCartDateInHuman = TransfromerManager.DateHumanized(item.AddToCartDate),
AddToCartDate = item.AddToCartDate,
Amount = TransfromerManager.DecimalHuamanized(item.Amount),
Quantity = item.Quantity,
CartNumber = item.CartNumber,
OrderDateInHuman = item.OrderDate,
PaymentTransactionNumber = item.PaymentTransactionNumber,
TransactionStatus = item.TransactionStatus
});
}
return(resultingData.AsQueryable());
}
public IActionResult SelectedPeriod(
string sortOrder,
string currentFilter,
string searchString,
int?page
)
{
ViewData["ControllerName"] = "ADMIN/REPORTS/SALES/SELECTED PERIOD";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var sales = !String.IsNullOrEmpty(searchString) ?
_ordersAndSalesService.Sales(s => !s.Product.ProductTypes.Equals("Expression of Interest") &&
s.CartNumber.Equals(searchString))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName)
: _ordersAndSalesService.Sales(s => !s.Product.ProductTypes.Equals("Expression of Interest"))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName);
var totalIn = sales.Sum(s => s.Amount);
var countIn = sales.LongCount();
ViewData["Totals"] = TransfromerManager.DecimalHumanizedX(totalIn);
ViewData["Counts"] = TransfromerManager.IntegerHuamanized(countIn);
var groupByCartNumber = sales.GroupBy(s =>
new
{
CartNum = s.CartNumber,
Customer = s.Person.FullName,
TranStatus = s.TransactionStatus,
TransDate = s.OrderDate
})
.Select(gr => new
{
Id = gr.Key.CartNum,
Customer = gr.Key.Customer,
TranStatus = gr.Key.TranStatus,
TransDate = gr.Key.TransDate,
TotalAmount = gr.Sum(s => s.Amount)
});
var list = groupByCartNumber.Select(item => new OrdersGroupView
{
CartNumber = item.Id,
Customer = item.Customer,
TransactionStatus = item.TranStatus,
TransactionDate = item.TransDate,
TotalAmount = TransfromerManager.DecimalHumanizedX(item.TotalAmount),
SoldItems = sales.Where(s => s.CartNumber.Equals(item.Id)).ToList()
});
ViewData["Product"] = sales.Select(s => s.Product.Name).Distinct();
ViewData["ProductCategory"] = sales.Select(s => s.Product.ProductCategory.Name).Distinct();
int pageSize = 20;
return(View(PaginatedList <OrdersGroupView> .Create(list.AsQueryable(), page ?? 1, pageSize)));
}
public IActionResult SelectedPeriod(
string sortOrder,
string currentFilter,
//string searchString,
string selectedPeriodValues,
int?page
)
{
ViewData["ControllerName"] = "ADMIN/REPORTS/ORDERS/SELECTED PERIOD";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
//if (searchString != null)
//{
// page = 1;
//}
//else
//{
// searchString = currentFilter;
//}
var k = selectedPeriodValues;
// ViewData["CurrentFilter"] = searchString;
var orders = !String.IsNullOrEmpty(currentFilter) ?
_ordersAndSalesService.Get(s => !s.Product.ProductTypes.Equals("Expression of Interest") &&
s.CartNumber.Equals(currentFilter))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName)
: _ordersAndSalesService.Get(s => !s.Product.ProductTypes.Equals("Expression of Interest"))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName);
var totalIn = orders.Count();
ViewData["Totals"] = TransfromerManager.IntegerHuamanized(totalIn);
ViewData["Product"] = orders.Select(s => s.Product.Name).Distinct();
ViewData["ProductCategory"] = orders.Select(s => s.Product.ProductCategory.Name).Distinct();
var list = orders.Select(item => new OrdersView
{
Id = (int)item.Id,
Product = item.Product.Name,
Category = item.Product.ProductCategory.Name,
Customer = item.Person.FullName,
CustNo = item.Person.MemberShipNo,
Amount = TransfromerManager.DecimalHumanizedX(item.Amount),
TransactionDate = item.AddToCartDate.ToString(),
CartNumber = item.CartNumber,
TransactionNumber = item.PaymentTransactionNumber,
TransactionStatus = item.TransactionStatus,
AddToCartDate = TransfromerManager.DateHumanized(item.AddToCartDate),
// Date = item.OrderDate.ToString()
})
.ToList();
int pageSize = 20;
return(View(PaginatedList <OrdersView> .Create(list.AsQueryable(), page ?? 1, pageSize)));
}
public IActionResult Index(
string sortOrder,
string currentFilter,
string searchString,
int?page
)
{
ViewData["ControllerName"] = "Admin/Orders";
ViewBag.AreaName = "Roles & Permission";
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["NumberOfUserSortParm"] = sortOrder == "NumberOfUser" ? "numberOfUser" : "NumberOfUser";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var orders = !String.IsNullOrEmpty(searchString) ?
_ordersAndSalesService.Get(s => s.CartNumber.Equals(searchString))
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName)
: _ordersAndSalesService.Get()
.OrderByDescending(s => s.AddToCartDate).ThenBy(s => s.Person.FullName);
var list = new List <OrdersView>();
foreach (var item in orders)
{
list.Add(new OrdersView
{
Id = (int)item.Id,
Product = item.Product.Name,
Category = item.Product.ProductCategory.Name,
Customer = item.Person.FullName,
CustomerId = item.Person.Id,
CustNo = item.Person.MemberShipNo,
Amount = TransfromerManager.DecimalHumanizedX(item.Amount),
TransactionDate = TransfromerManager.DateHumanized(item.AddToCartDate),
CartNumber = item.CartNumber,
TransactionNumber = item.PaymentTransactionNumber,
TransactionStatus = item.TransactionStatus,
AddToCartDate = TransfromerManager.DateHumanized(item.AddToCartDate)
});
}
//var list = orders.Select(item => new OrdersView
//{
// Id = (int)item.Id,
// Product = item.Product.Name,
// Category = item.Product.ProductCategory.Name,
// Customer = item.Customer.FullName,
// CustNo = item.Customer.MembershipNumber,
// Amount = TransfromerManager.DecimalHumanizedX(item.Amount),
// TransactionDate = item.OrderDate.ToString(),
// CartNumber = item.CartNumber,
// TransactionNumber = item.PaymentTransactionNumber,
// TransactionStatus = item.TransactionStatus,
// AddToCartDate = TransfromerManager.DateHumanized(item.AddToCartDate),
// Date = item.OrderDate.ToString()
//})
// .ToList();
int pageSize = 20;
return(View(PaginatedList <OrdersView> .Create(list.AsQueryable(), page ?? 1, pageSize)));
}
