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());
}
