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