public async Task <ActionResult> AllReceiver() { Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); List <StockOut> stockOuts = await applicationDbContext.StockOuts.Include("Product").Include("Product.Category").Where(x => x.Receiver_Id == null).ToListAsync(); foreach (var stockOut in stockOuts) { stockOut.Receiver_Id = User.Identity.GetUserId(); applicationDbContext.Entry(stockOut).State = System.Data.Entity.EntityState.Modified; BusinessUser businessUser = await applicationDbContext.BusinessUsers.FirstOrDefaultAsync(x => x.User_Id == stockOut.Receiver_Id && x.Business_Id == business_working); if (stockOut.Product.Category.ActionOut == ActionConstants.Sum) { businessUser.Cash += stockOut.SalePrice * stockOut.Quantity; } else if (stockOut.Product.Category.ActionOut == ActionConstants.Rest) { businessUser.Cash -= stockOut.SalePrice * stockOut.Quantity; } applicationDbContext.Entry(businessUser).State = System.Data.Entity.EntityState.Modified; await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_Out_Receive, stockOut.Id, stockOut.Product.Name, business_working); } await applicationDbContext.SaveChangesAsync(); return(Json(true)); }
public async Task <ActionResult> Create(ProductModel model) { Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); if (ModelState.IsValid) { Product product = new Product() { Id = Guid.NewGuid(), Name = model.Product, Category_Id = Guid.Parse(model.Category), Description = "", Stock = model.Stock, User_Id = User.Identity.GetUserId(), CurrentPrice = decimal.Parse(model.CurrentPrice.Replace(".", ",")), LastUpdated = DateTime.Now, NoCountOut = model.NoCountOut, Business_Id = business_working, SalePrice = decimal.Parse(model.SalePrice.Replace(".", ",")), isAccesory = model.isAccesory }; applicationDbContext.Products.Add(product); await applicationDbContext.SaveChangesAsync(); await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_Create, product.Id, model.Product, business_working); return(RedirectToAction("Index")); } ViewBag.Categories = await applicationDbContext.Categories.Where(x => x.Business_Id == business_working).OrderBy(x => x.Name).ToListAsync(); return(View(model)); }
public async Task <ActionResult> Edit(string id, ProductModel model) { Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); if (ModelState.IsValid) { Guid prod_id = Guid.Parse(id); Product product = await applicationDbContext.Products.FirstOrDefaultAsync(x => x.Id == prod_id); product.Name = model.Product; product.Category_Id = Guid.Parse(model.Category); product.Stock = model.Stock; product.CurrentPrice = decimal.Parse(model.CurrentPrice.Replace(".", ",")); product.SalePrice = decimal.Parse(model.SalePrice.Replace(".", ",")); product.LastUpdated = DateTime.Now; product.NoCountOut = model.NoCountOut; product.isAccesory = model.isAccesory; applicationDbContext.Entry(product).State = System.Data.Entity.EntityState.Modified; await applicationDbContext.SaveChangesAsync(); await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_Edit, product.Id, model.Product, business_working); return(RedirectToAction("Index")); } ViewBag.Categories = await applicationDbContext.Categories.Where(x => x.Business_Id == business_working).OrderBy(x => x.Name).ToListAsync(); return(View(model)); }
public async Task <ActionResult> Delete(string id) { Guid out_id = Guid.Parse(id); Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); StockOut stockOut = await applicationDbContext.StockOuts.Include("Product").FirstOrDefaultAsync(x => x.Id == out_id); if (stockOut != null) { if (stockOut.Receiver_Id != null) { if (!stockOut.Product.NoCountOut) { BusinessUser businessUser = await applicationDbContext.BusinessUsers.FirstOrDefaultAsync(x => x.User_Id == stockOut.Receiver_Id && x.Business_Id == business_working); /*Operacion inversa para revertir la situaciĆ³n*/ if (stockOut.Product.Category.ActionOut == ActionConstants.Sum) { businessUser.Cash -= stockOut.SalePrice * stockOut.Quantity; } else if (stockOut.Product.Category.ActionOut == ActionConstants.Rest) { businessUser.Cash += stockOut.SalePrice * stockOut.Quantity; } applicationDbContext.Entry(businessUser).State = System.Data.Entity.EntityState.Modified; } } stockOut.Product.Stock += stockOut.Quantity; stockOut.Product.LastUpdated = DateTime.Now; applicationDbContext.Entry(stockOut.Product).State = System.Data.Entity.EntityState.Modified; applicationDbContext.Entry(stockOut).State = System.Data.Entity.EntityState.Deleted; await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_Out_Remove, stockOut.Id, stockOut.Product.Name, business_working); await applicationDbContext.SaveChangesAsync(); } ViewBag.Msg = "La salida ha sido eliminada correctamente"; return(RedirectToAction("Index")); }
public async Task <ActionResult> Create(StockOutModel model) { Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); if (ModelState.IsValid) { Guid productId = Guid.Parse(model.ProductName); Product product = await applicationDbContext.Products.Include("Category").FirstOrDefaultAsync(x => x.Id == productId); StockOut stockOut = new StockOut() { Id = Guid.NewGuid(), Product_Id = productId, Date = DateTime.Now, Quantity = model.Quantity, SalePrice = decimal.Parse(model.SalePrice.Replace(".", ",")), User_Id = User.Identity.GetUserId(), Gain = decimal.Parse(model.SalePrice.Replace(".", ",")) - product.CurrentPrice, Description = model.Description }; if (RoleManager.IsInRole(RoleManager.Editor) || RoleManager.IsInRole(RoleManager.Administrator)) { stockOut.Receiver_Id = User.Identity.GetUserId(); BusinessUser businessUser = await applicationDbContext.BusinessUsers.FirstOrDefaultAsync(x => x.User_Id == stockOut.Receiver_Id && x.Business_Id == business_working); if (product.Category.ActionOut == ActionConstants.Sum) { businessUser.Cash += stockOut.SalePrice * stockOut.Quantity; } else if (product.Category.ActionOut == ActionConstants.Rest) { businessUser.Cash -= stockOut.SalePrice * stockOut.Quantity; } applicationDbContext.Entry(businessUser).State = System.Data.Entity.EntityState.Modified; } applicationDbContext.StockOuts.Add(stockOut); if (!product.NoCountOut) { product.Stock -= stockOut.Quantity; product.LastUpdated = DateTime.Now; applicationDbContext.Entry(product).State = System.Data.Entity.EntityState.Modified; } if (model.AccesoriesIds != null) { foreach (var acc in model.AccesoriesIds) { Guid accesory = Guid.Parse(acc); Product acc_product = await applicationDbContext.Products.Include("Category").FirstOrDefaultAsync(x => x.Id == accesory); StockOut acc_stockOut = new StockOut() { Id = Guid.NewGuid(), Product_Id = accesory, Date = DateTime.Now, Quantity = 1, SalePrice = 0, User_Id = User.Identity.GetUserId(), Gain = 0 - acc_product.CurrentPrice, Description = $"Con producto {product.Name}" }; applicationDbContext.StockOuts.Add(acc_stockOut); if (!acc_product.NoCountOut) { acc_product.Stock -= acc_stockOut.Quantity; acc_product.LastUpdated = DateTime.Now; applicationDbContext.Entry(acc_product).State = System.Data.Entity.EntityState.Modified; } } } await applicationDbContext.SaveChangesAsync(); await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_Out_Create, product.Id, product.Name, business_working); return(RedirectToAction("Index")); } ViewBag.Categories = await applicationDbContext.Categories.Where(x => x.Business_Id == business_working).OrderBy(x => x.Name).ToListAsync(); return(View(model)); }
public async Task <ActionResult> Create(StockInModel model) { Guid business_working = Guid.Parse(Session["BusinessWorking"].ToString()); if (ModelState.IsValid) { Guid productId = Guid.Parse(model.ProductName); StockIn stockIn = new StockIn() { Id = Guid.NewGuid(), Product_Id = productId, Date = DateTime.Now, Quantity = model.Quantity, ShopPrice = decimal.Parse(model.ShopPrice.Replace(".", ",")), User_Id = User.Identity.GetUserId(), Description = model.Description }; if (Guid.Parse(model.Provider) != Guid.Empty) { stockIn.Provider_Id = Guid.Parse(model.Provider); } applicationDbContext.StockIns.Add(stockIn); Product product = await applicationDbContext.Products.Include("Category").FirstOrDefaultAsync(x => x.Id == productId); product.CurrentPrice = ((product.CurrentPrice * product.Stock) + (stockIn.ShopPrice * stockIn.Quantity)) / (product.Stock + stockIn.Quantity); product.Stock += stockIn.Quantity; product.LastUpdated = DateTime.Now; if (RoleManager.IsInRole(RoleManager.Editor) || RoleManager.IsInRole(RoleManager.Administrator)) { BusinessUser businessUser = await applicationDbContext.BusinessUsers.FirstOrDefaultAsync(x => x.User_Id == stockIn.User_Id && x.Business_Id == business_working); if (product.Category.ActionIn == ActionConstants.Sum) { businessUser.Cash += stockIn.ShopPrice * stockIn.Quantity; } else if (product.Category.ActionIn == ActionConstants.Rest) { businessUser.Cash -= stockIn.ShopPrice * stockIn.Quantity; } applicationDbContext.Entry(businessUser).State = System.Data.Entity.EntityState.Modified; } applicationDbContext.Entry(product).State = System.Data.Entity.EntityState.Modified; await applicationDbContext.SaveChangesAsync(); await ActivityPublisher.Publish(User.Identity.GetUserId(), ActivityTypeConstants.Stock_In_Create, stockIn.Id, product.Name, business_working); return(RedirectToAction("Index")); } ViewBag.Categories = await applicationDbContext.Categories.Where(x => x.Business_Id == business_working).OrderBy(x => x.Name).ToListAsync(); ViewBag.Providers = await applicationDbContext.Providers.Where(x => x.Business_Id == business_working).OrderBy(x => x.Name).ToListAsync(); return(View(model)); }