public ActionResult EditDeliveryQuantity(DeliveryQuantity deliveryQuantity, int id) { var concernId = Convert.ToInt32(Session["ConcernId"]); var userId = Convert.ToInt32(Session["UserId"]); if (concernId > 0 && userId > 0) { _sales.UpdateDeliveryQuantity(deliveryQuantity, userId, concernId, id); return(RedirectToAction("Orders", "PermessData", new { Area = "Permess" })); } return(RedirectToAction("LogIn", "GlobalData", new { Area = "Global" })); }
public void UpdateDeliveryQuantity(DeliveryQuantity deliveryQuantity, int userId, int concernId, int id) { using (DbContextTransaction transaction = _context.Database.BeginTransaction()) { var delivery = _context.DeliveryQuantities.FirstOrDefault(x => x.DeliveryQuantityID == id); delivery.Quantity = deliveryQuantity.Quantity; delivery.ConcernId = concernId; delivery.Creator = userId; _context.SaveChanges(); var product = _context.SRIProductDetails.FirstOrDefault(x => x.SICode == deliveryQuantity.ProductCode); product.DeliveryQuantity = deliveryQuantity.Quantity; _context.SaveChanges(); transaction.Commit(); } }
public ActionResult AddQuantity(int id, DeliveryQuantity delivery) { var concernId = Convert.ToInt32(Session["ConcernId"]); var userId = Convert.ToInt32(Session["UserId"]); if (concernId > 0 && userId > 0) { //DeliveryQuantity deliveryQuantity = new DeliveryQuantity(); var del = _context.DeliveryQuantities.FirstOrDefault(x => x.SIProductDetailsCode == id.ToString()); delivery.CreationDate = DateTime.Now; delivery.SIProductDetailsCode = id.ToString(); delivery.Creator = userId; delivery.ConcernId = concernId; delivery.SIProductDetailsCode = del.SIProductDetailsCode; _context.DeliveryQuantities.Add(delivery); _context.SaveChanges(); return(RedirectToAction(nameof(Orders))); } return(RedirectToAction("LogIn", "GlobalData", new { Area = "Global" })); }
public void AddSIProductDetails(SIProductDetails sIProductDetails, int userId, int concernId) { var code = sIProductDetails.ProductId + "" + sIProductDetails.ArticleId + "" + sIProductDetails.WidthId + "" + sIProductDetails.ConstructionId + "" + sIProductDetails.SoftnessId + "" + sIProductDetails.SourceId + "" + sIProductDetails.ColorId; var productCode = _context.ProductNames.FirstOrDefault(m => m.ProductCode == code); var quantityCode = DateTime.Now.ToString("mmddfff"); var quantityCod = "5" + "" + quantityCode; using (DbContextTransaction transaction = _context.Database.BeginTransaction()) { if (productCode == null) { ProductName product = new ProductName(); product.ProductCode = code; product.ProductId = sIProductDetails.ProductId; product.ArticleId = sIProductDetails.ArticleId; product.WidthId = sIProductDetails.WidthId; product.ConstructionId = sIProductDetails.ConstructionId; product.SoftnessId = sIProductDetails.SoftnessId; product.SourceId = sIProductDetails.SourceId; product.ColorId = sIProductDetails.ColorId; _context.ProductNames.Add(product); _context.SaveChanges(); sIProductDetails.ConcernId = concernId; sIProductDetails.SIProductDetailsCode = quantityCod; sIProductDetails.ProductCode = code; sIProductDetails.CreationDate = DateTime.Now; sIProductDetails.Creator = userId; //sIProductDetails.DeliveryQuantity = 0; _context.SIProductDetails.Add(sIProductDetails); _context.SaveChanges(); DeliveryQuantity delivery = new DeliveryQuantity(); delivery.ConcernId = concernId; delivery.SIProductDetailsCode = quantityCod; delivery.DeliveryDate = DateTime.Now; delivery.ProductCode = sIProductDetails.SICode; delivery.CreationDate = DateTime.Now; delivery.Creator = userId; delivery.Quantity = sIProductDetails.DeliveryQuantity; _context.DeliveryQuantities.Add(delivery); _context.SaveChanges(); transaction.Commit(); } else { sIProductDetails.ConcernId = concernId; sIProductDetails.SIProductDetailsCode = quantityCod; sIProductDetails.ProductCode = code; sIProductDetails.CreationDate = DateTime.Now; sIProductDetails.Creator = userId; _context.SIProductDetails.Add(sIProductDetails); _context.SaveChanges(); DeliveryQuantity delivery = new DeliveryQuantity(); delivery.ConcernId = concernId; delivery.SIProductDetailsCode = quantityCod; delivery.DeliveryDate = DateTime.Now; delivery.ProductCode = sIProductDetails.SICode; delivery.CreationDate = DateTime.Now; delivery.Creator = userId; delivery.Quantity = sIProductDetails.DeliveryQuantity; _context.DeliveryQuantities.Add(delivery); _context.SaveChanges(); transaction.Commit(); } } }