public IActionResult AuthorizationPage(LoginPageModel model)
{
var userClaims = new List <Claim>()
{
new Claim(ClaimTypes.Name, model.UserName)
};
var userIdentities = new ClaimsIdentity(userClaims, "ApplicationUserIdentity");
var userPricipal = new ClaimsPrincipal(new[] { userIdentities });
using (var context = new ProductsDatabaseContext())
{
var user = context.SalesPeoples.FirstOrDefault(x => x.Login == model.UserName && x.Password == model.Password);
if (user != null)
{
HttpContext.SignInAsync(userPricipal);
return(RedirectToAction("Index", "Sales"));
}
}
return(RedirectToAction("NotAuthorized"));
}
public IActionResult SalesReport()
{
using (var context = new ProductsDatabaseContext())
{
var result = from sales in context.Sales
join products in context.Products on sales.ProductId equals products.ProductId
join salespeople in context.SalesPeoples on sales.SellerId equals salespeople.SellerId
select new SalesReportItemModel()
{
TransactionId = sales.TransactionId,
TransactionDate = sales.TransactionDate,
ProductId = sales.ProductId,
ProductName = products.ProductName,
SellerId = sales.SellerId,
SellerName = salespeople.SellerName,
Amount = sales.Amount,
Price = sales.Price,
Total = sales.Amount * sales.Price
};
var model = new SalesReportModel()
{
SalesItems = result.ToList()
};
return(View(model));
}
}
public IActionResult Index(SalesEntryFormModel inputData)
{
using (var context = new ProductsDatabaseContext())
{
var productInfo = context.Products.FirstOrDefault(x => x.ProductId == inputData.ProductId);
if (productInfo != null)
{
context.Sales.Add(
new Sale()
{
Amount = inputData.Amount,
ProductId = inputData.ProductId,
SellerId = inputData.SalesPersonId,
TransactionDate = DateTime.UtcNow,
Price = productInfo.Price.Value
}
);
context.SaveChanges();
return(RedirectToAction("SalesReport", "Sales"));
}
}
return(View(inputData));
}
public IActionResult Index()
{
using (var context = new ProductsDatabaseContext())
{
var userInfo = context.SalesPeoples.FirstOrDefault(x => x.Login == HttpContext.User.Identity.Name);
if (userInfo != null)
{
var productsList = new List <SelectListItem>();
foreach (var item in context.Products)
{
productsList.Add(new SelectListItem()
{
Value = item.ProductId.ToString(), Text = item.ProductName
});
}
return(View(new SalesEntryFormModel()
{
SalesmanLogin = userInfo.Login, CurrentDate = DateTime.Now.ToString("yyyy/MM/dd"), SalesPersonId = userInfo.SellerId, ProductList = productsList
}));
}
else
{
return(RedirectToAction("OptOut", "Home"));
}
}
}
public IEnumerable <Product> GetProductsFromDb()
{
var result = new List <Product>();
using (var context = new ProductsDatabaseContext())
{
var productsInDb = context.Products;
foreach (var item in productsInDb)
{
result.Add(item);
}
}
return(result);
}
public IActionResult Suppliers()
{
using (var context = new ProductsDatabaseContext())
{
var result = new List <SupplierDto>();
foreach (var item in context.Supliers)
{
result.Add(new SupplierDto()
{
SupplierId = item.SuplierId,
SupplierName = item.SuplierName,
SupplierAddress = item.Address
});
}
var model = new SuppliersModel()
{
Suppliers = result
};
return(View(model));
}
}
public IActionResult ProductsList()
{
using (var context = new ProductsDatabaseContext())
{
var result = from products in context.Products
join categories in context.Categories on products.CategoryId equals categories.CategoryId
join suppliers in context.Supliers on products.SuplierId equals suppliers.SuplierId
select new ProductDto()
{
ProductId = products.ProductId,
Price = products.Price.Value,
ProductName = products.ProductName,
CategoryName = categories.CategoryName,
SupplierName = suppliers.SuplierName
};
var model = new ProductsModel()
{
Products = result.ToList()
};
return(View(model));
}
}
