public JsonResult AddSalesReturn(SRIProductDetails productDetails)
{
var concernId = Convert.ToInt32(Session["ConcernId"]);
var userId = Convert.ToInt32(Session["UserId"]);
_sales.AddSalesReturn(productDetails, concernId, userId);
return(Json(new
{
redirectUrl = Url.Action("SalesReturn", "Sales", new { Area = "Permess" }),
isRedirect = true
}));
}
public void AddSalesReturn(SRIProductDetails productDetails, int concernId, int userId)
{
var code = productDetails.ProductId + "" + productDetails.ArticleId + "" + productDetails.WidthId + "" + productDetails.ConstructionId + "" + productDetails.SoftnessId + "" + productDetails.SourceId + "" + productDetails.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 = productDetails.ProductId;
product.ArticleId = productDetails.ArticleId;
product.WidthId = productDetails.WidthId;
product.ConstructionId = productDetails.ConstructionId;
product.SoftnessId = productDetails.SoftnessId;
product.SourceId = productDetails.SourceId;
product.ColorId = productDetails.ColorId;
_context.ProductNames.Add(product);
_context.SaveChanges();
productDetails.ConcernId = concernId;
productDetails.Creator = userId;
productDetails.ProductCode = code;
productDetails.CreationDate = DateTime.Now;
_context.SRIProductDetails.Add(productDetails);
_context.SaveChanges();
transaction.Commit();
}
else
{
productDetails.ConcernId = concernId;
productDetails.Creator = userId;
productDetails.ProductCode = code;
productDetails.CreationDate = DateTime.Now;
_context.SRIProductDetails.Add(productDetails);
_context.SaveChanges();
transaction.Commit();
}
}
}
