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