private ProductionLinesModel GetProductionLine(int lineId) { ProductionLinesModel model = new ProductionLinesModel(); using (ProductionLineService service = new ProductionLineService()) { var dto = service.Get(lineId); model = Mapper.Map <ProductionLinesDto, ProductionLinesModel>(dto); } return(model); }
private ProductionLinesModel GetProductionLine(int prodLineId) { ProductionLinesModel productionLine = new ProductionLinesModel(); using (ProductionLineService service = new ProductionLineService()) { var dto = service.Get(prodLineId); productionLine = Mapper.Map <ProductionLinesDto, ProductionLinesModel>(dto); } return(productionLine); }
public JsonResult UpdateProdLineResult(ProductionLineManagementModel model) { TPO.Web.Core.ResponseMessage responseMessage; try { using (ProductionLineService svc = new ProductionLineService()) { var dto = svc.Get(model.Id); dto = AutoMapper.Mapper.Map <ProductionLineManagementModel, ProductionLinesDto>(model, dto); using (ProdLineTypeService typeSvc = new ProdLineTypeService()) { ProdLineTypeDto typeDto = typeSvc.Get(dto.LineTypeID); if (typeDto != null) { switch (typeDto.ProdLineTypeCode) { case "TPO": case "RW": { switch (typeDto.ProdLineTypeCode) { case "TPO": { dto.TPOMorC = model.TPOLineRolls; } break; case "RW": { dto.TPOMorC = model.RollsProcessed; } break; } dto.RCComp = "NA"; } break; case "RC": case "CO": { switch (typeDto.ProdLineTypeCode) { case "RC": { dto.RCComp = model.Compatibilizer; } break; case "CO": { dto.RCComp = model.Adhesive; } break; } dto.TPOMorC = "NA"; } break; default: { dto.TPOMorC = "NA"; dto.RCComp = "NA"; } break; } } } dto.ModifiedBy = CurrentUser; dto.LastModified = DateTime.Now; if (dto.ID > 0) { svc.Update(dto); } else { dto.RepOrder = 1; dto.DateEntered = DateTime.Now; dto.EnteredBy = CurrentUser; dto.PlantID = CurrentPlantId; dto.ID = svc.Add(dto); } model = AutoMapper.Mapper.Map <ProductionLinesDto, ProductionLineManagementModel>(dto); } responseMessage = SetResponseMesssage(ActionTypeMessage.SuccessfulSave); } catch (Exception exc) { responseMessage = SetResponseMesssage(ActionTypeMessage.FailedSave, exc.Message); } model.ResponseMessage = responseMessage; return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult GridByType(int lineID, int?rows, int?page) { rows = rows ?? DefaultPageSize; page = page ?? DefaultPage; int lineDescription; List <CurrentScrimViewModel> list = new List <CurrentScrimViewModel>(); List <TPOCurrentRawMaterialDto> materialslist = new List <TPOCurrentRawMaterialDto>(); if (lineID != null) { using (var service = new ProductionLineService()) { lineDescription = service.Get(lineID).ID; } using (var service = new TPOCurrentRawMaterialService()) { materialslist = service.GetAll().Where(q => q.LineID == lineDescription).ToList(); } foreach (var dto in materialslist) { RawMaterialReceivedDto rawMaterialReceivedDto = new RawMaterialReceivedDto(); RawMaterialDto rawMaterialDto = new RawMaterialDto(); CurrentScrimViewModel csvm = new CurrentScrimViewModel(); csvm.Id = dto.ID; csvm.PlantId = CurrentPlantId; using (var service = new RawMaterialReceivedService()) { rawMaterialReceivedDto = service.Get(dto.RawMaterialReceivedID ?? 0); csvm.LotNumber = rawMaterialReceivedDto.LotNumber; csvm.RawMaterialID = rawMaterialReceivedDto.Id; } using (var service = new RawMaterialService()) { rawMaterialDto = service.Get(Convert.ToInt32(rawMaterialReceivedDto.RawMaterialId)); csvm.RawMaterialCode = rawMaterialDto.Code; } csvm.EnteredBy = dto.EnteredBy; csvm.ModifiedBy = dto.ModifiedBy; csvm.DateEntered = dto.DateEntered; csvm.LastModified = dto.LastModified; list.Add(csvm); } } int total; total = list.Count(); List <CurrentScrimViewModel> currentPageDtos = new List <CurrentScrimViewModel>(); if (rows.HasValue) { currentPageDtos.AddRange(list.OrderByDescending(r => r.DateEntered).Skip((page.Value - 1) * rows.Value).Take(rows.Value).ToList()); } else { currentPageDtos.AddRange(list); } return(BuildJsonResult(currentPageDtos, total)); }
public JsonResult CurrentScrimAjaxCreate(string id, int lineId) { ResponseMessage responseMessage; try { CurrentScrimViewModel currentSrimViewModel = JsonConvert.DeserializeObject <CurrentScrimViewModel>(id); if (currentSrimViewModel != null) { TPOCurrentRawMaterialDto tpoCurrentRawMaterialdto = new TPOCurrentRawMaterialDto(); if (currentSrimViewModel.Id > 0) { using (TPOCurrentRawMaterialService service = new TPOCurrentRawMaterialService()) { tpoCurrentRawMaterialdto = service.Get(currentSrimViewModel.Id); } using (RawMaterialReceivedService service = new RawMaterialReceivedService()) { RawMaterialReceivedDto rawMaterialDto = new RawMaterialReceivedDto(); rawMaterialDto = service.GetAll() .Where(q => q.Id == Convert.ToInt32(currentSrimViewModel.LotNumber)) .ToList() .FirstOrDefault(); tpoCurrentRawMaterialdto.RawMaterialReceivedID = rawMaterialDto.Id; } } else { tpoCurrentRawMaterialdto.PlantID = CurrentPlantId; using (ProductionLineService service = new ProductionLineService()) { tpoCurrentRawMaterialdto.LineID = service.Get(lineId).ID; } using (RawMaterialReceivedService service = new RawMaterialReceivedService()) { RawMaterialReceivedDto rawMaterialDto = new RawMaterialReceivedDto(); rawMaterialDto = service.GetAll() .Where(q => q.Id == Convert.ToInt32(currentSrimViewModel.LotNumber)) .ToList() .FirstOrDefault(); tpoCurrentRawMaterialdto.RawMaterialReceivedID = rawMaterialDto.Id; } } using (TPOCurrentScrimService service = new TPOCurrentScrimService()) { if (currentSrimViewModel.Id > 0) { service.UpdateTPOCurrentRawMaterial(tpoCurrentRawMaterialdto); } else { service.AddTPOCurrentRawMaterial(tpoCurrentRawMaterialdto); } } } responseMessage = SetResponseMesssage(ActionTypeMessage.SuccessfulSave); } catch (Exception exc) { responseMessage = SetResponseMesssage(ActionTypeMessage.FailedSave, exc.Message); } return(Json(responseMessage, JsonRequestBehavior.AllowGet)); }
public JsonResult GetWorkOrderShiftData(int lineID, int shiftID, int workOrderID, DateTime prodDate) { WorkOrderShiftDataModel model = new WorkOrderShiftDataModel(); //Set default units of measure using (UnitOfMeasureService svc = new UnitOfMeasureService()) { var lengthDefault = svc.GetDefaultByTypeCode("L"); if (lengthDefault != null) { model.LengthUnitOfMeasure = lengthDefault.Code; } var weightDefault = svc.GetDefaultByTypeCode("W"); if (weightDefault != null) { model.WeightUnitOfMeasure = weightDefault.Code; } } //Get production line ProductionLinesDto lineDto = null; using (ProductionLineService lineSvc = new ProductionLineService()) { lineDto = lineSvc.Get(lineID); } if (lineDto != null) { List <TPOCProductRollDto> rollDtos = new List <TPOCProductRollDto>(); using (TPOCProductRollService rollSvc = new TPOCProductRollService()) { if (lineDto.TPOMorC == "M") { //Get master rolls rollDtos.AddRange(rollSvc.GetMasterRollsByShift(lineID, shiftID, prodDate)); } else { //Get child rolls rollDtos.AddRange(rollSvc.GetChildRollsByShift(lineID, shiftID, prodDate)); } } //Filter for rolls specific to the work order var workOrderRolls = rollDtos.Where(r => r.WorkOrderID == workOrderID).ToList(); model.RollCount1 = workOrderRolls.Count; model.Length1 = workOrderRolls.Sum(r => r.Length); model.Weight1 = workOrderRolls.Sum(r => r.Weight); model.ShiftRollWeight = rollDtos.Sum(r => r.Weight); //Get scraps List <TPOLineScrapDto> scrapDtos = new List <TPOLineScrapDto>(); using (TPOLineScrapService scrapSvc = new TPOLineScrapService()) { scrapDtos.AddRange(scrapSvc.GetByShift(shiftID, prodDate)); } //Filter for scraps specific to the work order var woScraps = scrapDtos.Where(s => s.WorkOrderID == workOrderID).ToList(); for (int i = 0; i < woScraps.Count; i++) { switch (woScraps[i].TPOLineScrapTypeDescription) { case "Second": { model.Length2 += woScraps[i].Length; model.Weight2 += woScraps[i].Weight; } break; case "Third": { model.Length3 += woScraps[i].Length; model.Weight3 += woScraps[i].Weight; } break; case "Fourth": { model.Length4 += woScraps[i].Length; model.Weight4 += woScraps[i].Weight; } break; } } model.ShiftScrapWeight = scrapDtos.Sum(s => s.Weight); //Get downtime List <DownTimeDto> dtDtos = new List <DownTimeDto>(); using (DownTimeService dtSvc = new DownTimeService()) { dtDtos.AddRange(dtSvc.GetByShift(lineID, shiftID, prodDate)); } var woDowntime = dtDtos.Where(dt => dt.WorkOrderID == workOrderID).ToList(); model.DownTimeMinutes = woDowntime.Sum(dt => dt.DownTimeMinutes); model.ShiftDownTimeMinutes = dtDtos.Sum(dt => dt.DownTimeMinutes); //Get production line schedule List <ProductionLineScheduleDto> plSchedDtos = new List <ProductionLineScheduleDto>(); using (ProductionLineScheduleService plSchedSvc = new ProductionLineScheduleService()) { plSchedDtos.AddRange(plSchedSvc.GetByShift(lineID, shiftID, prodDate)); } model.ScheduledRunTime = plSchedDtos.Sum(s => s.MinutesScheduled); //Check if feeder entry forms need to be used if (lineDto.LineDescCode == "TPO") { model.RMUse = true; List <TPOFormulationLineProductDto> formDtos = new List <TPOFormulationLineProductDto>(); using (TPOFormulationLineProductService formSvc = new TPOFormulationLineProductService()) { formDtos.AddRange(formSvc.GetByWorkOrder(lineID, workOrderID)); } if (formDtos.Count > 0) { model.Form = formDtos.First().TPOFormulationID; model.Extruders = formDtos.First().TPOFormulationExtruders; } List <WorkOrderShiftDataDto> eorDtos = new List <WorkOrderShiftDataDto>(); using (WorkOrderShiftDataService eorSvc = new WorkOrderShiftDataService()) { eorDtos.AddRange(eorSvc.GetByShift(lineID, shiftID, prodDate)); if (eorDtos.Count == 0) { eorSvc.Add(new WorkOrderShiftDataDto() { LineID = lineID, ProductionDate = prodDate, ShiftID = shiftID, WorkOrderID = workOrderID, PlantID = CurrentPlantId, EnteredBy = CurrentUser, DateEntered = DateTime.Now, ModifiedBy = CurrentUser, LastModified = DateTime.Now }); } else { model.ScrimA = eorDtos.First().ScrimAreaUsed; model.ScrimW = eorDtos.First().ScrimWeightUsed; model.Resin = eorDtos.First().DrainedResin; } } } } return(Json(model, JsonRequestBehavior.AllowGet)); }