public DatabaseUpdateModel(Info info)
{
InventoryLastUpdated = info.InventoryLastUpdated.Year <= 2010 ? "Never" : info.InventoryLastUpdated.ToShortDateString();
OrdersLastUpdated = info.OrdersLastUpdated.Year <= 2010 ? "Never" : info.OrdersLastUpdated.ToShortDateString();
Colours = new ColourService().GetAll();
}
public IActionResult Index(int amountOfColours = 10)
{
var cssColours = new ColourService();
var stringBuilder = new StringBuilder();
stringBuilder.AppendLine($"<h2>{amountOfColours} kleuren</h2>");
foreach (string s in ColourService.GenerateCssColours(amountOfColours))
{
stringBuilder.AppendLine($"<div style =\"width:75px; height:50px; display:inline-block; background:{s};\"></div>");
}
stringBuilder.AppendLine($"<h2>{amountOfColours} tinten grijs</h2>");
foreach (string grijs in ColourService.GenerateGreyScales(amountOfColours))
{
stringBuilder.AppendLine($"<div style =\"width:75px; height:50px; background:{grijs} ; display:inline-block;\"></div>");
}
stringBuilder.AppendLine($"<h2>Kleur variaties (Rood, Groen en Blauw)</h2>");
foreach (string rood in ColourService.GenerateCssColours(amountOfColours, ColourService.ColourVariant.Reddish))
{
stringBuilder.AppendLine($"<div style =\"width:75px; height:50px; background:{rood} ; display:inline-block;\"></div>");
}
stringBuilder.AppendLine($"</br>");
foreach (string rood in ColourService.GenerateCssColours(amountOfColours, ColourService.ColourVariant.Greenish))
{
stringBuilder.AppendLine($"<div style =\"width:75px; height:50px; background:{rood} ; display:inline-block;\"></div>");
}
stringBuilder.AppendLine($"</br>");
foreach (string rood in ColourService.GenerateCssColours(amountOfColours, ColourService.ColourVariant.Blueish))
{
stringBuilder.AppendLine($"<div style =\"width:75px; height:50px; background:{rood} ; display:inline-block;\"></div>");
}
return(Content(stringBuilder.ToString(), "text/html"));
}
public JsonResult GetBaseProductId(int ProductGroupId, int ColourId)
{
ProductGroup ProductGroup = new ProductGroupService(_unitOfWork).Find(ProductGroupId);
Colour Colour = new ColourService(_unitOfWork).Find(ColourId);
if (ProductGroup != null && Colour != null)
{
string ConsumptionProductName = ProductGroup.ProductGroupName.ToString().Trim() + "-" + Colour.ColourName.ToString().Trim() + "-Bom";
var Product = new ProductService(_unitOfWork).Find(ConsumptionProductName);
if (Product != null)
{
return Json(Product.ProductId);
}
else
{
return Json(0);
}
}
else
{
return Json(0);
}
}
public ActionResult CopyFromExisting(CopyFromExistingDesignColourConsumptionViewModel vm)
{
if (ModelState.IsValid)
{
Product OldProduct = _ProductService.Find(vm.ProductId);
FinishedProduct NewProduct = new FinishedProduct();
ProductGroup productgroup = new ProductGroupService(_unitOfWork).Find(vm.ProductGroupId);
Colour Colour = new ColourService(_unitOfWork).Find(vm.ColourId);
string ConsumptionProductName = productgroup.ProductGroupName.ToString().Trim() + "-" + Colour.ColourName.ToString().Trim() + "-Bom";
var FirstProductQuality = (from p in db.FinishedProduct
where p.ProductGroupId == productgroup.ProductGroupId && p.ColourId == Colour.ColourId
select new
{
ProductQualityId = p.ProductQualityId
}).FirstOrDefault();
NewProduct.ProductCode = ConsumptionProductName;
NewProduct.ProductName = ConsumptionProductName;
NewProduct.ProductGroupId = new ProductGroupService(_unitOfWork).Find(ProductGroupConstants.Bom).ProductGroupId;
NewProduct.DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
NewProduct.IsActive = true;
NewProduct.CreatedDate = DateTime.Now;
NewProduct.ModifiedDate = DateTime.Now;
NewProduct.CreatedBy = User.Identity.Name;
NewProduct.ModifiedBy = User.Identity.Name;
NewProduct.ReferenceDocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductGroup).DocumentTypeId;
NewProduct.ReferenceDocId = productgroup.ProductGroupId;
NewProduct.IsSample = false;
if (FirstProductQuality != null)
{
NewProduct.ProductQualityId = FirstProductQuality.ProductQualityId;
}
NewProduct.ObjectState = Model.ObjectState.Added;
_ProductService.Create(NewProduct);
var ProductList = (from p in db.FinishedProduct
where p.ProductGroupId == productgroup.ProductGroupId && p.ColourId == Colour.ColourId
select new
{
ProductId = p.ProductId
}).ToList();
foreach (var item in ProductList)
{
BomDetail bomdetail = new BomDetail();
bomdetail.BaseProductId = item.ProductId;
bomdetail.BatchQty = 1;
bomdetail.ConsumptionPer = 100;
bomdetail.ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.Weaving).ProcessId;
bomdetail.ProductId = NewProduct.ProductId;
bomdetail.Qty = 1;
bomdetail.CreatedDate = DateTime.Now;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.CreatedBy = User.Identity.Name;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Added;
_BomDetailService.Create(bomdetail);
}
IEnumerable<BomDetail> BomDetailList = new BomDetailService(_unitOfWork).GetBomDetailList(OldProduct.ProductId);
foreach (BomDetail item in BomDetailList)
{
BomDetail bomdetail = new BomDetail();
bomdetail.BaseProductId = NewProduct.ProductId;
bomdetail.BatchQty = item.BatchQty;
bomdetail.ConsumptionPer = item.ConsumptionPer;
bomdetail.Dimension1Id = item.Dimension1Id;
bomdetail.ProcessId = item.ProcessId;
bomdetail.ProductId = item.ProductId;
bomdetail.Qty = item.Qty;
bomdetail.CreatedDate = DateTime.Now;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.CreatedBy = User.Identity.Name;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Added;
_BomDetailService.Create(bomdetail);
}
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return PartialView("CopyFromExisting", vm);
}
return Json(new { success = true, Url = "/DesignColourConsumptionHeader/Edit/" + NewProduct.ProductId });
}
return PartialView("CopyFromExisting", vm);
}
public ActionResult Create(DesignColourConsumptionHeaderViewModel svm)
{
if (ModelState.IsValid)
{
if (svm.BaseProductId == 0)
{
ProductQuality Quality = new ProductQualityService(_unitOfWork).Find(svm.ProductQualityName);
FinishedProduct product = new FinishedProduct();
string ConsumptionProductName = svm.ProductGroupName.ToString().Trim() + "-" + svm.ColourName.ToString().Trim() + "-Bom";
product.ProductCode = ConsumptionProductName;
product.ProductName = ConsumptionProductName;
product.ProductGroupId = new ProductGroupService(_unitOfWork).Find(ProductGroupConstants.Bom).ProductGroupId;
product.DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
product.IsActive = true;
product.ReferenceDocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductGroup).DocumentTypeId;
product.ReferenceDocId = svm.ProductGroupId;
product.StandardWeight = svm.Weight;
product.CreatedDate = DateTime.Now;
product.ModifiedDate = DateTime.Now;
product.CreatedBy = User.Identity.Name;
product.ModifiedBy = User.Identity.Name;
product.ObjectState = Model.ObjectState.Added;
product.IsSample = false;
product.ProductQualityId = Quality.ProductQualityId;
_ProductService.Create(product);
ProductGroup ProductGroup = new ProductGroupService(_unitOfWork).Find(svm.ProductGroupName);
Colour Colour = new ColourService(_unitOfWork).Find(svm.ColourName);
if (ProductGroup != null && Colour != null)
{
var ProductList = (from p in db.FinishedProduct
where p.ProductGroupId == ProductGroup.ProductGroupId && p.ColourId == Colour.ColourId
select new
{
ProductId = p.ProductId
}).ToList();
foreach (var item in ProductList)
{
BomDetail bomdetail = new BomDetail();
bomdetail.BaseProductId = item.ProductId;
bomdetail.BatchQty = 1;
bomdetail.ConsumptionPer = 100;
bomdetail.ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.Weaving).ProcessId;
bomdetail.ProductId = product.ProductId;
bomdetail.Qty = 1;
bomdetail.CreatedDate = DateTime.Now;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.CreatedBy = User.Identity.Name;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Added;
_BomDetailService.Create(bomdetail);
}
}
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return View(svm);
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.DesignColourConsumption).DocumentTypeId,
DocId = product.ProductId,
ActivityType = (int)ActivityTypeContants.Added,
}));
//return RedirectToAction("Create").Success("Data saved successfully");
return RedirectToAction("Edit", new { id = product.ProductId }).Success("Data saved Successfully");
}
else
{
List<LogTypeViewModel> LogList = new List<LogTypeViewModel>();
Product product = _ProductService.Find((int)svm.BaseProductId);
Product ExRec = Mapper.Map<Product>(product);
string ConsumptionProductName = svm.ProductGroupName.ToString().Trim() + "-" + svm.ColourName.ToString().Trim() + "-Bom";
product.ProductCode = ConsumptionProductName;
product.ProductName = ConsumptionProductName;
product.ReferenceDocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductGroup).DocumentTypeId;
product.ReferenceDocId = svm.ProductGroupId;
product.ModifiedBy = User.Identity.Name;
product.ModifiedDate = DateTime.Now;
product.StandardWeight = svm.Weight;
StringBuilder logstring = new StringBuilder();
_ProductService.Update(product);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = product,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return View("Create", svm);
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.DesignColourConsumption).DocumentTypeId,
DocId = product.ProductId,
ActivityType = (int)ActivityTypeContants.Modified,
xEModifications = Modifications,
}));
return RedirectToAction("Index").Success("Data saved successfully");
}
}
PrepareViewBag();
return View(svm);
}
public ActionResult _CreatePost(DesignConsumptionLineViewModel svm)
{
if (ModelState.IsValid)
{
FinishedProduct product = new FinishedProduct();
if (svm.BaseProductId == 0)
{
ProductQuality Quality = new ProductQualityService(_unitOfWork).Find(svm.QualityName);
string ConsumptionProductName = "";
if (svm.ColourName != "" && svm.ColourName != null)
{
ConsumptionProductName = svm.DesignName.ToString().Trim() + "-" + svm.ColourName.ToString().Trim() + "-Bom";
}
else
{
ConsumptionProductName = svm.DesignName.ToString().Trim() + "-Bom";
}
int ProductGroupId = new ProductGroupService(_unitOfWork).Find(svm.DesignName).ProductGroupId;
product.ProductCode = ConsumptionProductName;
product.ProductName = ConsumptionProductName;
product.ProductGroupId = new ProductGroupService(_unitOfWork).Find(ProductGroupConstants.Bom).ProductGroupId;
product.DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
product.IsActive = true;
product.ReferenceDocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductGroup).DocumentTypeId;
product.ReferenceDocId = ProductGroupId;
product.StandardWeight = svm.Weight;
product.CreatedDate = DateTime.Now;
product.ModifiedDate = DateTime.Now;
product.CreatedBy = User.Identity.Name;
product.ModifiedBy = User.Identity.Name;
product.ObjectState = Model.ObjectState.Added;
product.IsSample = false;
product.ProductQualityId = Quality.ProductQualityId;
new ProductService(_unitOfWork).Create(product);
ProductGroup ProductGroup = new ProductGroupService(_unitOfWork).Find(svm.DesignName);
Colour Colour = new ColourService(_unitOfWork).Find(svm.ColourName);
if (ProductGroup != null && Colour != null)
{
var ProductList = (from p in db.FinishedProduct
where p.ProductGroupId == ProductGroup.ProductGroupId && p.ColourId == Colour.ColourId
select new
{
ProductId = p.ProductId
}).ToList();
foreach (var item in ProductList)
{
BomDetail bomdetail = new BomDetail();
bomdetail.BaseProductId = item.ProductId;
bomdetail.BatchQty = 1;
bomdetail.ConsumptionPer = 100;
bomdetail.ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.Weaving).ProcessId;
bomdetail.BaseProcessId = svm.BaseProcessId;
bomdetail.ProductId = product.ProductId;
bomdetail.Qty = 1;
bomdetail.CreatedDate = DateTime.Now;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.CreatedBy = User.Identity.Name;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Added;
_BomDetailService.Create(bomdetail);
}
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.DesignColourConsumption).DocumentTypeId,
DocId = product.ProductId,
ActivityType = (int)ActivityTypeContants.Added,
}));
}
else
{
//product = new FinishedProductService(_unitOfWork).Find(svm.BaseProductId);
product.ProductId = svm.BaseProductId;
}
if (svm.BomDetailId == 0)
{
BomDetail bomdetail = new BomDetail();
bomdetail.BaseProductId = svm.BaseProductId;
bomdetail.BatchQty = 1;
bomdetail.ConsumptionPer = svm.ConsumptionPer;
bomdetail.Dimension1Id = svm.Dimension1Id;
bomdetail.ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.Weaving).ProcessId;
bomdetail.BaseProcessId = svm.BaseProcessId;
bomdetail.ProductId = svm.ProductId;
bomdetail.Qty = svm.Qty;
bomdetail.CreatedDate = DateTime.Now;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.CreatedBy = User.Identity.Name;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Added;
_BomDetailService.Create(bomdetail);
if (bomdetail.BaseProductId == bomdetail.ProductId)
{
PrepareViewBag(svm);
//return View(svm).Danger(DataValidationMsg);
ModelState.AddModelError("", "Invalid Product is Selected!");
return(PartialView("_Create", svm));
}
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.DesignConsumption).DocumentTypeId,
DocId = bomdetail.BomDetailId,
ActivityType = (int)ActivityTypeContants.Added,
}));
if (svm.ContentType == "Main Contents")
{
return(RedirectToAction("_CreateMainContentForBaseProduct", new { id = product.ProductId }));
}
else if (svm.ContentType == "OverTuft Contents")
{
return(RedirectToAction("_CreateOverTuftContentForBaseProduct", new { id = product.ProductId }));
}
else
{
return(RedirectToAction("_CreateOtherContentForBaseProduct", new { id = product.ProductId }));
}
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
BomDetail bomdetail = _BomDetailService.Find(svm.BomDetailId);
BomDetail ExRec = Mapper.Map <BomDetail>(bomdetail);
bomdetail.BaseProductId = svm.BaseProductId;
bomdetail.BatchQty = 1;
bomdetail.ConsumptionPer = svm.ConsumptionPer;
bomdetail.Dimension1Id = svm.Dimension1Id;
bomdetail.ProductId = svm.ProductId;
bomdetail.Qty = svm.Qty;
bomdetail.ModifiedDate = DateTime.Now;
bomdetail.ModifiedBy = User.Identity.Name;
bomdetail.ObjectState = Model.ObjectState.Modified;
_BomDetailService.Update(bomdetail);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = bomdetail,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.DesignConsumption).DocumentTypeId,
DocId = bomdetail.BomDetailId,
ActivityType = (int)ActivityTypeContants.Modified,
xEModifications = Modifications,
}));
return(Json(new { success = true }));
}
}
PrepareViewBag(svm);
return(PartialView("_Create", svm));
}
public ColourController(ColourService colourService)
{
_colourService = colourService;
}
