public JsonResult SalesProductDetails(SIProductDetails sIProductDetails) { var concernId = Convert.ToInt32(Session["ConcernId"]); var userId = Convert.ToInt32(Session["UserId"]); _sales.AddSIProductDetails(sIProductDetails, userId, concernId); //code = sIProductDetails.SICode; return(Json("", JsonRequestBehavior.AllowGet)); }
public ActionResult EditSIProduct(SIProductDetails sIProductDetails, int id) { var concernId = Convert.ToInt32(Session["ConcernId"]); var userId = Convert.ToInt32(Session["UserId"]); if (concernId > 0 && userId > 0) { PIRevised pIRevised = new PIRevised(); pIRevised.PICode = id.ToString(); pIRevised.UserId = userId; pIRevised.ConcernId = concernId; pIRevised.RevisedDate = DateTime.Now; pIRevised.RevisedDocs = "Product"; _permess.AddRevisedData(pIRevised); _sales.UpdateSIProductDetails(sIProductDetails, userId, concernId, id); return(RedirectToAction("EditOrders", "PermessData", new { Areas = "Permess" })); } return(RedirectToAction("LogIn", "GlobalData", new { Area = "Global" })); }
public void UpdateSIProductDetails(SIProductDetails sIProductDetails, int userId, int concernId, int Code) { 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); 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(); var prop = _context.SIProductDetails.FirstOrDefault(m => m.SIProductDetId == Code); prop.AltArticle = sIProductDetails.AltArticle; prop.ArticleId = sIProductDetails.ArticleId; prop.ColorId = sIProductDetails.ColorId; prop.ConstructionId = sIProductDetails.ConstructionId; prop.DeliveryQuantity = sIProductDetails.DeliveryQuantity; prop.Description = sIProductDetails.Description; prop.LenghtId = sIProductDetails.LenghtId; prop.OrderQuantity = sIProductDetails.OrderQuantity; prop.OverInvoice = sIProductDetails.OverInvoice; prop.ProductId = sIProductDetails.ProductId; //prop.SICode = sIProductDetails.SICode; prop.SoftnessId = sIProductDetails.SoftnessId; prop.SourceId = sIProductDetails.SourceId; prop.UnitPrice = sIProductDetails.UnitPrice; prop.WidthId = sIProductDetails.WidthId; _context.SaveChanges(); var quantity = _context.DeliveryQuantities.FirstOrDefault(x => x.SIProductDetailsCode == prop.SIProductDetailsCode); quantity.Quantity = sIProductDetails.DeliveryQuantity; _context.SaveChanges(); transaction.Commit(); } else { var prop = _context.SIProductDetails.FirstOrDefault(m => m.SIProductDetId == Code); prop.AltArticle = sIProductDetails.AltArticle; prop.ArticleId = sIProductDetails.ArticleId; prop.ColorId = sIProductDetails.ColorId; prop.ConstructionId = sIProductDetails.ConstructionId; prop.DeliveryQuantity = sIProductDetails.DeliveryQuantity; prop.Description = sIProductDetails.Description; prop.LenghtId = sIProductDetails.LenghtId; prop.OrderQuantity = sIProductDetails.OrderQuantity; prop.OverInvoice = sIProductDetails.OverInvoice; prop.ProductId = sIProductDetails.ProductId; //prop.SICode = sIProductDetails.SICode; prop.SoftnessId = sIProductDetails.SoftnessId; prop.SourceId = sIProductDetails.SourceId; prop.UnitPrice = sIProductDetails.UnitPrice; prop.WidthId = sIProductDetails.WidthId; _context.SaveChanges(); var quantity = _context.DeliveryQuantities.FirstOrDefault(x => x.SIProductDetailsCode == prop.SIProductDetailsCode); quantity.Quantity = sIProductDetails.DeliveryQuantity; _context.SaveChanges(); transaction.Commit(); } } }
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(); } } }