public int Add(TPOProductDto dto) { var entity = Mapper.Map <TPOProductDto, TPOProduct>(dto); //Need to set UseCELogo here entity.TPOProductCEDetail = new TPOProductCEDetail(); entity.TPOProductCEDetail.UseCELogo = dto.UseCELogo; entity.TPOProductCapCoreDetail = new TPOProductCapCoreDetail(); entity.TPOProductDimDetail = new TPOProductDimDetail(); entity.TPOProductGrabDetail = new TPOProductGrabDetail(); UnitOfMeasureService uomService = new UnitOfMeasureService(); entity.TPOProductDimDetail.DimStabTempUoM = uomService.GetByTypeCode("Y").FirstOrDefault().ID; entity.ThickTestUoM = uomService.GetByTypeCode("T").FirstOrDefault().ID; entity.ThickTestUoM2 = uomService.GetByTypeCode("T").FirstOrDefault().ID; entity.WidthTestUoM = uomService.GetByTypeCode("D").FirstOrDefault().ID; entity.ForceTestUoM = uomService.GetByTypeCode("F").FirstOrDefault().ID; entity.PunctUoM = uomService.GetByTypeCode("W").FirstOrDefault().ID; try { _repository.Repository <TPOProduct>().Insert(entity); _repository.Save(); } catch (DbEntityValidationException valEx) { HandleValidationException(valEx); } catch (Exception ex) { LogException(ex); throw; } return(entity.ID); }
public async Task <ActionResult <List <DirectSalesOrder_UnitOfMeasureDTO> > > FilterListUnitOfMeasure([FromBody] DirectSalesOrder_UnitOfMeasureFilterDTO DirectSalesOrder_UnitOfMeasureFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } UnitOfMeasureFilter UnitOfMeasureFilter = new UnitOfMeasureFilter(); UnitOfMeasureFilter.Skip = 0; UnitOfMeasureFilter.Take = 20; UnitOfMeasureFilter.OrderBy = UnitOfMeasureOrder.Id; UnitOfMeasureFilter.OrderType = OrderType.ASC; UnitOfMeasureFilter.Selects = UnitOfMeasureSelect.ALL; UnitOfMeasureFilter.Id = DirectSalesOrder_UnitOfMeasureFilterDTO.Id; UnitOfMeasureFilter.Code = DirectSalesOrder_UnitOfMeasureFilterDTO.Code; UnitOfMeasureFilter.Name = DirectSalesOrder_UnitOfMeasureFilterDTO.Name; UnitOfMeasureFilter.Description = DirectSalesOrder_UnitOfMeasureFilterDTO.Description; UnitOfMeasureFilter.StatusId = DirectSalesOrder_UnitOfMeasureFilterDTO.StatusId; List <UnitOfMeasure> UnitOfMeasures = await UnitOfMeasureService.List(UnitOfMeasureFilter); List <DirectSalesOrder_UnitOfMeasureDTO> DirectSalesOrder_UnitOfMeasureDTOs = UnitOfMeasures .Select(x => new DirectSalesOrder_UnitOfMeasureDTO(x)).ToList(); return(DirectSalesOrder_UnitOfMeasureDTOs); }
private string GetUoMCode(int uoMID) { using (UnitOfMeasureService service = new UnitOfMeasureService()) { return(service.Get(uoMID).Code); } }
protected SelectList GetLengthUoMOptions() { List <UnitOfMeasureDto> dtos = new List <UnitOfMeasureDto>(); using (UnitOfMeasureService svc = new UnitOfMeasureService()) { dtos.AddRange(svc.GetByTypeCode(UnitOfMeasureTypeDto.LENGTH)); } return(new SelectList(dtos, "ID", "Code")); }
private UnitOfMeasureModel GetUomModel(int uomId) { UnitOfMeasureModel uomModel; using (var uomService = new UnitOfMeasureService()) { var uomDto = uomService.Get(uomId); uomModel = Mapper.Map <UnitOfMeasureDto, UnitOfMeasureModel>(uomDto); } return(uomModel); }
private UnitOfMeasureModel GetUnitOfMeasure(int uomId) { UnitOfMeasureModel uom = null; using (UnitOfMeasureService service = new UnitOfMeasureService()) { var dto = service.Get(uomId); uom = Mapper.Map <UnitOfMeasureDto, UnitOfMeasureModel>(dto); } return(uom); }
public JsonResult GetUoMsByType(int typeId = 1) { List <UnitOfMeasureModel> uoms = new List <UnitOfMeasureModel>(); using (UnitOfMeasureService service = new UnitOfMeasureService()) { var dtos = service.GetAllByUoMTypeId(typeId); uoms.AddRange(Mapper.Map <List <UnitOfMeasureDto>, List <UnitOfMeasureModel> >(dtos)); } return(Json(uoms, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDefaultUoMByType(string typeCode = "") { UnitOfMeasureModel model = new UnitOfMeasureModel(); using (UnitOfMeasureService svc = new UnitOfMeasureService()) { var dto = svc.GetDefaultByTypeCode(typeCode); model = Mapper.Map <UnitOfMeasureDto, UnitOfMeasureModel>(dto); } return(Json(model, JsonRequestBehavior.AllowGet)); }
private JsonResult GetByType(string type = "") { List <UnitOfMeasureModel> data = new List <UnitOfMeasureModel>(); using (UnitOfMeasureService svc = new UnitOfMeasureService()) { var dtos = svc.GetByTypeCode(type); data.AddRange(Mapper.Map <List <UnitOfMeasureDto>, List <UnitOfMeasureModel> >(dtos)); } return(Json(data, JsonRequestBehavior.AllowGet)); }
public async Task GetUnitOfMeasuresAsync_Returns_UnitOfMeasures() { //Arrange var service = new UnitOfMeasureService(_myRestaurantContext); //Act var result = await service.GetUnitOfMeasuresAsync(); //Assert result.Should().BeAssignableTo <IEnumerable <UnitOfMeasure> >(); result.Should().HaveCount(5); }
public async Task GetUnitOfMeasureAsync_Returns_Null() { //Arrange var id = 10; var service = new UnitOfMeasureService(_myRestaurantContext); //Act var result = await service.GetUnitOfMeasureAsync(d => d.Id == id); //Assert result.Should().BeNull(); }
public JsonResult GetUomsByType(string type) { var scrimRolls = new List <UnitOfMeasureModel>(); using (var service = new UnitOfMeasureService()) { var dtos = service.GetByTypeCode(type); scrimRolls.AddRange(Mapper.Map <List <UnitOfMeasureDto>, List <UnitOfMeasureModel> >(dtos)); } return(Json(scrimRolls, JsonRequestBehavior.AllowGet)); }
public async Task GetUnitOfMeasureAsync_Returns_UnitOfMeasure() { //Arrange var id = 1; var service = new UnitOfMeasureService(_myRestaurantContext); //Act var result = await service.GetUnitOfMeasureAsync(d => d.Id == id); //Assert result.Should().BeAssignableTo <UnitOfMeasure>(); result !.Id.Should().Be(id); result.Code.Should().Be("kg"); result.Description.Should().Be("kg units"); }
protected void CalcArea() { int areaUoMId = 0; using (ScrimTypeService service = new ScrimTypeService()) { _area = 0.0; ScrimTypeDto dto = service.Get(TypeID); _area = (double)Length * dto.Width; areaUoMId = dto.AreaUoMID; } using (UnitOfMeasureService service = new UnitOfMeasureService()) { _areaUom = service.Get(areaUoMId).Code; } }
public async Task DeleteUnitOfMeasureAsync_Successfully_Deleted() { //Arrange var id = 1; var service = new UnitOfMeasureService(_myRestaurantContext); //Act var dbUnitOfMeasure = await service.GetUnitOfMeasureAsync(d => d.Id == id); await service.DeleteUnitOfMeasureAsync(dbUnitOfMeasure !); var result = await service.GetUnitOfMeasureAsync(d => d.Id == id); //Assert result.Should().BeNull(); }
private UnitOfMeasureModel GetUnitOfMeasure(string code) { //if (!_uomsByCode.ContainsKey(code)) { UnitOfMeasureModel uom = null; using (UnitOfMeasureService service = new UnitOfMeasureService()) { var dto = service.GetByCode(code); uom = Mapper.Map <UnitOfMeasureDto, UnitOfMeasureModel>(dto); //_uomsById.Add(uom.ID, uom); //_uomsByCode.Add(uom.Code, uom); } return(uom); } //return _uomsByCode[code]; }
//private Dictionary<int, UnitOfMeasureModel> _uomsById = new Dictionary<int, UnitOfMeasureModel>(); //private Dictionary<string, UnitOfMeasureModel> _uomsByCode = new Dictionary<string, UnitOfMeasureModel>(); private UnitOfMeasureModel GetUnitOfMeasure(int uomId) { //if (!_uomsById.ContainsKey(uomId)) { UnitOfMeasureModel uom = null; using (UnitOfMeasureService service = new UnitOfMeasureService()) { var dto = service.Get(uomId); uom = Mapper.Map <UnitOfMeasureDto, UnitOfMeasureModel>(dto); //_uomsById.Add(uomId, uom); //_uomsByCode.Add(uom.Code, uom); } return(uom); } //return _uomsById[uomId]; }
public JsonResult GetAllUoMResultByCode(string code) { UnitOfMeasureTypeModel uomType = Mapper.Map <UnitOfMeasureTypeDto, UnitOfMeasureTypeModel>((new UnitOfMeasureTypeService()).GetByCode(code)); if (uomType != null) { // TODO: what if uomType is null? List <UnitOfMeasureModel> uoms = new List <UnitOfMeasureModel>(); using (UnitOfMeasureService service = new UnitOfMeasureService()) { var dtos = service.GetAllByUoMTypeId(uomType.Id); uoms.AddRange(Mapper.Map <List <UnitOfMeasureDto>, List <UnitOfMeasureModel> >(dtos)); } return(Json(uoms, JsonRequestBehavior.AllowGet)); } return(null); }
public async Task AddUnitOfMeasureAsync_Returns_New_UnitOfMeasure() { //Arrange var service = new UnitOfMeasureService(_myRestaurantContext); //Act var result = await service.AddUnitOfMeasureAsync(new UnitOfMeasure { Code = "gal", Description = "gallon" }); //Assert result.Should().BeAssignableTo <UnitOfMeasure>(); result.Code.Should().Be("gal"); result.Description.Should().Be("gallon"); //Act var uoms = await service.GetUnitOfMeasuresAsync(); //Assert uoms.Should().HaveCount(6); }
public async Task UpdateUnitOfMeasureAsync_Successfully_Updated() { //Arrange var id = 3; var service = new UnitOfMeasureService(_myRestaurantContext); //Act var dbUnitOfMeasure = await service.GetUnitOfMeasureAsync(d => d.Id == id); dbUnitOfMeasure !.Code = "ml"; dbUnitOfMeasure.Description = "ml units to add"; await service.UpdateUnitOfMeasureAsync(dbUnitOfMeasure); var result = await service.GetUnitOfMeasureAsync(d => d.Id == id); //Assert result.Should().BeAssignableTo <UnitOfMeasure>(); result !.Id.Should().Be(id); result.Code.Should().Be("ml"); result.Description.Should().Be("ml units to add"); }
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)); }