public ActionResult Create([Bind(Include = "DateTransfered,FromBranchId,ToBranchId,UserId")] ProductTransferViewModel productTransferViewModel) { if (ModelState.IsValid) { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); var productTransfer = new ProductTransfer() { //FromBranchId =1, //productTransferViewModel.FromBranchId, //ToBranchId= 2, //productTransferViewModel.ToBranchId, FromBranchId = productTransferViewModel.FromBranchId, ToBranchId = productTransferViewModel.ToBranchId, UserId = user.Id, DateTransfered = DateTime.Now }; _productTransferService.AddProductTransfer(productTransfer); return(RedirectToAction("Create", "ProductTransfers", new { id = productTransfer.ProductTransferId })); } return(View(productTransferViewModel)); }
// GET: ProductTransfer/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var productTransfer = _productTransferService.Get(t => t.ProductTransferId == id, null, "ProductTransferLineItems").FirstOrDefault(); if (productTransfer == null) { return(HttpNotFound()); } var productTransferViewModel = new ProductTransferViewModel() { FromBranchId = productTransfer.FromBranchId, FromBranchName = _branchService.FindById(productTransfer.FromBranchId).BranchName, ToBranchId = productTransfer.ToBranchId, ToBranchName = _branchService.FindById(productTransfer.ToBranchId).BranchName, ProductTransferId = productTransfer.ProductTransferId, DateTransfered = productTransfer.DateTransfered, UserId = productTransfer.UserId, UserName = userManager.FindById(productTransfer.UserId).FullName }; var productTransferLineItemViewModels = new List <ProductTransferLineItemViewModel>(); foreach (var productTransferLineItem in productTransfer.ProductTransferLineItems) { var productTransferLineItemviewModel = new ProductTransferLineItemViewModel() { ProductTransferLineItemId = productTransferLineItem.ProductTransferLineItemId, ProductId = productTransferLineItem.ProductId, Productname = _productService.FindBy(s => s.ProductcId == productTransferLineItem.ProductId).First().ProductName, Quantity = productTransferLineItem.Quantity, UnitCost = _productService.FindBy(p => p.ProductcId == productTransferLineItem.ProductId).First().UnitCost }; productTransferLineItemViewModels.Add(productTransferLineItemviewModel); } ViewBag.ProductTransferLineItemViewModels = productTransferLineItemViewModels; return(View(productTransferViewModel)); }
// GET: ProductTransfer public ActionResult Index() { var productTransfers = _productTransferService.GetAllProductTransfer(); var producttransferViewModels = new List <ProductTransferViewModel>(); foreach (var productTransfer in productTransfers) { var productTransferViewModel = new ProductTransferViewModel() { FromBranchId = productTransfer.FromBranchId, ToBranchId = productTransfer.ToBranchId, ProductTransferId = productTransfer.ProductTransferId, DateTransfered = productTransfer.DateTransfered, UserId = productTransfer.UserId, UserName = userManager.FindById(productTransfer.UserId).FullName }; productTransferViewModel.FromBranchName = _branchService.FindById(productTransferViewModel.FromBranchId).BranchName; productTransferViewModel.ToBranchName = _branchService.FindById(productTransferViewModel.ToBranchId).BranchName; producttransferViewModels.Add(productTransferViewModel); } return(View(producttransferViewModels)); }
// GET: ProductTransfer/Create public ActionResult Create(int?id) { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); if (id != null && id != 0) { var productTransfer = _productTransferService.Get(t => t.ProductTransferId == id, null, "ProductTransferLineItems").FirstOrDefault(); var productTransferViewModel = new ProductTransferViewModel() { FromBranchId = productTransfer.FromBranchId, ToBranchId = productTransfer.ToBranchId, ProductTransferId = productTransfer.ProductTransferId, DateTransfered = productTransfer.DateTransfered, UserId = productTransfer.UserId, UserName = userManager.FindById(productTransfer.UserId).FullName }; //string FromBranchName = _branchService.FindById(productTransferViewModel.FromBranchId).BranchName; //string ToBranchName = _branchService.FindById(productTransferViewModel.ToBranchId).BranchName; //productTransferViewModel.FromBranchName = FromBranchName; //productTransferViewModel.ToBranchName = ToBranchName; //ViewBag.FromBranchName = FromBranchName; //ViewBag.ToBranchName = ToBranchName; string FromBranchName = _branchService.FindById(productTransferViewModel.FromBranchId).BranchName; string ToBranchName = _branchService.FindById(productTransferViewModel.ToBranchId).BranchName; productTransferViewModel.FromBranchName = FromBranchName; productTransferViewModel.ToBranchName = ToBranchName; ViewBag.FromBranchList = new SelectList(_branchService.GetAllBranches(), "BranchId", "BranchName", productTransfer.FromBranchId); ViewBag.ToBranchList = new SelectList(_branchService.GetAllBranches(), "BranchId", "BranchName", productTransfer.ToBranchId); ViewBag.UserName = user.FullName; ViewBag.ProductTransferId = productTransfer.ProductTransferId; var productTransferLineItemViewModels = new List <ProductTransferLineItemViewModel>(); foreach (var productTransferLineItem in productTransfer.ProductTransferLineItems) { var productTransferLineItemviewModel = new ProductTransferLineItemViewModel() { ProductTransferLineItemId = productTransferLineItem.ProductTransferLineItemId, ProductId = productTransferLineItem.ProductId, Productname = _productService.FindBy(s => s.ProductcId == productTransferLineItem.ProductId).First().ProductName, Quantity = productTransferLineItem.Quantity, }; productTransferLineItemViewModels.Add(productTransferLineItemviewModel); } ViewData["ProductList"] = new SelectList(_productService.GetAllProducts(), "ProductcId", "ProductName"); ViewBag.ProductTransferLineItemViewModels = productTransferLineItemViewModels; //ViewBag.UserName = user.FullName; //ViewBag.BranchName = _branchService.FindById(user.BranchId).BranchName; return(View(productTransferViewModel)); } ViewBag.UserName = user.FullName; //ViewData["BranchList"] = new SelectList(_branchService.GetAllBranches(), "BranchId", "BranchName"); //ViewBag.FromBranchName = _branchService.FindById(1).BranchName; ; //ViewBag.ToBranchName = _branchService.FindById(2).BranchName; ; ViewBag.FromBranchList = new SelectList(_branchService.GetAllBranches(), "BranchId", "BranchName"); ViewBag.ToBranchList = new SelectList(_branchService.GetAllBranches(), "BranchId", "BranchName"); return(View()); }
public ActionResult Index() { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); //MoencoPOSContext northwindDb = new MoencoPOSContext(); //List<AspNetUsers> model = null; //if (userManager.IsInRole(user.Id, "Administrator")) //{ // model = northwindDb.Customers.ToList(); //} //if (userManager.IsInRole(user.Id, "Operator")) //{ // model = northwindDb.Customers.Where(c => c.Country == "USA").ToList(); //} var salesInvoices = new List <SalesInvoice>(); if (user.Role == "Administrator") { salesInvoices = _salesInvoiceService.Get(t => t.Status == "Paid", null, "SalesLineItems").OrderByDescending(o => o.DateSold).ToList(); } else { salesInvoices = _salesInvoiceService.Get(t => t.BranchId == user.BranchId && t.Status == "Paid", null, "SalesLineItems").OrderByDescending(o => o.DateSold).ToList(); } var salesLineItems = new List <SalesLineItem>(); foreach (var salesInvoice in salesInvoices) { foreach (var sLI in salesInvoice.SalesLineItems) { salesLineItems.Add(sLI); } } var groupedSLIs = (from tr in salesLineItems group tr by new { tr.ProductId } into groupedSLI select new { ProductID = groupedSLI.Key.ProductId, ProductName = _productService.FindById(groupedSLI.Key.ProductId).ProductName, UnitPrice = _productService.FindById(groupedSLI.Key.ProductId).UnitPrice, QuantitySold = groupedSLI.Sum(p => p.Quantity) }); List <SalesReportViewModel> salesReportViewModels = (from groupedSLI in groupedSLIs let i = groupedSLI where i != null where i != null select new SalesReportViewModel() { ProductId = i.ProductID, ProductName = i.ProductName, QuantitySold = i.QuantitySold, UnitPrice = i.UnitPrice }).ToList(); ViewBag.GroupedSLIs = salesReportViewModels.Take(10); var allSalesInvoices = _salesInvoiceService.Get(t => t.Status == "Returned", null, "SalesLineItems").OrderByDescending(o => o.DateSold).ToList(); var salesInvoiceViewModels = new List <SalesInvoiceViewModel>(); foreach (var salesInvoice in allSalesInvoices) { var salesInvoiceViewModel = new SalesInvoiceViewModel() { BranchId = salesInvoice.BranchId, CustomerId = salesInvoice.CustomerId, CustomerName = salesInvoice.Customer.FirstName + " " + salesInvoice.Customer.LastName, BranchName = salesInvoice.Branch.BranchName, DateSold = salesInvoice.DateSold, ReferenceNo = salesInvoice.ReferenceNo, SalesInvoiceId = salesInvoice.SalesInvoiceId, SalesType = salesInvoice.SalesType, UserId = salesInvoice.UserId, UserName = userManager.FindById(salesInvoice.UserId).FullName, Status = salesInvoice.Status }; salesInvoiceViewModels.Add(salesInvoiceViewModel); } ViewBag.ReturnedSales = salesInvoiceViewModels.Take(10); var productReceives = _productReceiveService.GetAllProductReceive(); var productReceivesViewModels = new List <ProductReceiveViewModel>(); foreach (var productReceive in productReceives) { var productReceiveViewModel = new ProductReceiveViewModel() { BranchId = productReceive.BranchId, BranchName = productReceive.Branch.BranchName, DateReceived = productReceive.DateReceived, ProductReceiveId = productReceive.ProductReceiveId, UserId = productReceive.UserId, UserName = userManager.FindById(productReceive.UserId).FullName }; productReceivesViewModels.Add(productReceiveViewModel); } ViewBag.ReceivedStock = salesInvoiceViewModels.Take(10); var productTransfers = _productTransferService.GetAllProductTransfer(); var producttransferViewModels = new List <ProductTransferViewModel>(); foreach (var productTransfer in productTransfers) { var productTransferViewModel = new ProductTransferViewModel() { FromBranchId = productTransfer.FromBranchId, ToBranchId = productTransfer.ToBranchId, ProductTransferId = productTransfer.ProductTransferId, DateTransfered = productTransfer.DateTransfered, UserId = productTransfer.UserId, UserName = userManager.FindById(productTransfer.UserId).FullName }; productTransferViewModel.FromBranchName = _branchService.FindById(productTransferViewModel.FromBranchId).BranchName; productTransferViewModel.ToBranchName = _branchService.FindById(productTransferViewModel.ToBranchId).BranchName; producttransferViewModels.Add(productTransferViewModel); } ViewBag.TransferredStock = salesInvoiceViewModels.Take(10); if (user != null) { ViewBag.FullName = user.FullName; } else { ViewBag.FullName = "Admin"; } //return View(model); return(View()); }