public async Task CreateTracking(string username, TrackingDto trackingDto) { var user = Unit.All <Entity.User>().FirstOrDefault(u => u.Name == username); var project = await Unit.Repo <Entity.Project, INamedRepository <Entity.Project> >().FindOrCreateAsync(trackingDto.ProjectName); var task = await Unit.Repo <Entity.Task, INamedRepository <Entity.Task> >().FindOrCreateAsync(trackingDto.TaskName, t => { t.Project = project; t.Description = trackingDto.TaskDescription; t.Type = trackingDto.TaskType; }); var tracking = new Entity.Tracking { Task = task, AsOfDate = trackingDto.TrackingDate, RangeFrom = trackingDto.StartTime.ToSpan(), RangeTo = trackingDto.EndTime.ToSpan(), User = user }; var repo = Unit.Repo <Entity.Tracking>(); repo.Create(tracking); await repo.Commit(); }
public async Task <ActionResult <TrackingDto> > DeleteAsync(int trackingId) { TrackingDto tracking = _trackingApplicationServices.Delete(trackingId); await _signalRService.TrackingServerEvents.DeleteTracking(tracking); return(Ok(tracking)); }
public async Task <ActionResult <TrackingDto> > Update(int trackingId, [FromBody] TrackingDto tracking) { tracking = _trackingApplicationServices.Update(trackingId, tracking); await _signalRService.TrackingServerEvents.UpdateTracking(tracking); return(Ok(tracking)); }
public async Task <ActionResult <TrackingDto> > Update(int trackingId, [FromBody] JsonPatchDocument <TrackingDto> trackingPatch) { TrackingDto tracking = _trackingApplicationServices.UpdatePatch(trackingId, trackingPatch); await _signalRService.TrackingServerEvents.UpdateTracking(tracking); return(Ok(tracking)); }
public async Task <ActionResult <TrackingDto> > Insert([FromBody] TrackingDto tracking) { tracking = _trackingApplicationServices.Insert(tracking); await _signalRService.TrackingServerEvents.NewTracking(tracking); return(Ok(tracking)); }
public TrackingDto Update(TrackingDto tracking) { Tracking trackingUpdate = _context.Trackings.Where(w => w.TrackingId == tracking.TrackingId).FirstOrDefault(); trackingUpdate = _mapper.Map <Tracking>(tracking); _context.Trackings.Update(trackingUpdate); _context.SaveChanges(); return(_mapper.Map <TrackingDto>(trackingUpdate)); }
public TrackingDto GetByTrackingId(int trackingId) { TrackingDto tracking = _mapper.Map <TrackingDto>(_context.Trackings .Include(t => t.Order).ThenInclude(o => o.Client) .Include(t => t.TrackingStatus) .Include(t => t.TrackingProducts).ThenInclude(tp => tp.Product) .Where(w => w.TrackingId == trackingId).FirstOrDefault()); tracking.Total = tracking.TrackingProducts.Sum(tp => tp.Product.Price); return(tracking); }
public TrackingDto UpdatePatch(int trackingId, JsonPatchDocument <TrackingDto> trackingPatch) { Tracking trackingUpdate = _context.Trackings.Where(w => w.TrackingId == trackingId).FirstOrDefault(); TrackingDto trackingUpdateDto = _mapper.Map <TrackingDto>(trackingUpdate); trackingPatch.ApplyTo(trackingUpdateDto); _mapper.Map(trackingUpdateDto, trackingUpdate); //_context.Trackings.Update(trackingUpdate); _context.SaveChanges(); return(_mapper.Map <TrackingDto>(trackingUpdate)); }
public TrackingDto Insert(TrackingDto tracking) { Tracking trackingCreate = new Tracking(); try { _mapper.Map(tracking, trackingCreate); _context.Trackings.Add(trackingCreate); _context.SaveChanges(); } catch (Exception ex) { throw ex; } return(_mapper.Map <TrackingDto>(trackingCreate)); }
public async Task <TrackingDto> GetShipmentTracking(GetShipmentTrackingInput input) { var resultDto = new TrackingDto() { Status = ShippingStatus.NotYetShipped.GetLocalizedEnum(_localizationManager) }; Shipment shipment = null; if (input.OrderId.HasValue && input.OrderId > 0) { var order = await _orderManager.GetByIdAsync(input.OrderId.Value); if (order != null) { await _orderManager.OrderRepository.EnsureCollectionLoadedAsync(order, t => t.Shipments); shipment = order.Shipments.FirstOrDefault(); } } else { shipment = await _shipmentManager.GetByIdAsync(input.ShipmentId.Value); } if (await IsShippingSettingAvailable()) { return(resultDto); } var traces = await _shipmentTracker.GetShipmentTracesAsync(shipment, input.Refresh); resultDto.Status = ((ShippingStatus)traces.State).GetLocalizedEnum(_localizationManager); resultDto.Traces = traces.Traces.Select(t => { return(new TrackingItemDto() { Station = t.AcceptStation, Time = t.AcceptTime, Remark = t.Remark }); }).ToList(); return(resultDto); }
public static XLWorkbook ExportaTracking(TrackingDto data, string filtro, string valor) { if (!Directory.Exists(@"C:\Templates")) { if (!File.Exists(@"C:\Templates\TrackingList.xlsx")) { return(null); } } XLWorkbook book = new XLWorkbook(@"C:\Templates\TrackingList.xlsx"); var hojaE = book.Worksheet("Entry List"); int index = 7; hojaE.Cell("B3").Value = filtro; hojaE.Cell("B4").Value = DateTime.Now.Date; hojaE.Cell("C3").Value = valor; foreach (var item in data.EntryList) { hojaE.Cell("A" + index).Value = item.Euid; hojaE.Cell("B" + index).Value = item.Year; hojaE.Cell("C" + index).Value = item.Country; hojaE.Cell("D" + index).Value = item.Location; hojaE.Cell("E" + index).Value = item.Rng; hojaE.Cell("F" + index).Value = item.Plt; hojaE.Cell("G" + index).Value = item.Ent; hojaE.Cell("H" + index).Value = item.ExpName; hojaE.Cell("I" + index).Value = item.ProjectLead; hojaE.Cell("J" + index).Value = item.Cc; hojaE.Cell("K" + index).Value = item.Crop; hojaE.Cell("L" + index).Value = item.Obs; hojaE.Cell("M" + index).Value = item.ProjectCode; hojaE.Cell("N" + index).Value = item.GmoEvent; hojaE.Cell("O" + index).Value = item.Sag; hojaE.Cell("P" + index).Value = item.CodInternacion; hojaE.Cell("Q" + index).Value = item.Client; hojaE.Cell("R" + index).Value = item.EntName; hojaE.Cell("S" + index).Value = item.EntRole; hojaE.Cell("T" + index).Value = item.ResImportacion; hojaE.Cell("U" + index).Value = item.GranosHilera; hojaE.Cell("V" + index).Value = item.Bi1; hojaE.Cell("W" + index).Value = item.Bi2; hojaE.Cell("X" + index).Value = item.Bi3; hojaE.Cell("Y" + index).Value = item.Bi4; hojaE.Cell("Z" + index).Value = item.Owner; hojaE.Cell("AA" + index).Value = item.CodPermanencia; hojaE.Cell("AB" + index).Value = item.LotId; index++; } var hoja = book.Worksheet("Tracking"); index = 7; hoja.Cell("B3").Value = filtro; hoja.Cell("B4").Value = DateTime.Now.Date; hoja.Cell("C3").Value = valor; foreach (var item in data.Info) { hoja.Cell("A" + index).Value = item.euid; hoja.Cell("B" + index).Value = item.indEuid; hoja.Cell("C" + index).Value = item.year; hoja.Cell("D" + index).Value = item.country; hoja.Cell("E" + index).Value = item.location; hoja.Cell("F" + index).Value = item.order; hoja.Cell("G" + index).Value = item.breedersCode1; hoja.Cell("H" + index).Value = item.breedersCode2; hoja.Cell("I" + index).Value = item.breedersCode3; hoja.Cell("J" + index).Value = item.breedersCode4; hoja.Cell("K" + index).Value = item.rng; hoja.Cell("L" + index).Value = item.ent; hoja.Cell("M" + index).Value = item.opExpName; hoja.Cell("N" + index).Value = item.projecLead; hoja.Cell("O" + index).Value = item.cc; hoja.Cell("P" + index).Value = item.shipTo; hoja.Cell("Q" + index).Value = item.crop; hoja.Cell("R" + index).Value = item.obs; hoja.Cell("S" + index).Value = item.projectCode; hoja.Cell("T" + index).Value = item.gmoEvent; hoja.Cell("U" + index).Value = item.sag; hoja.Cell("V" + index).Value = item.codInternacion; hoja.Cell("W" + index).Value = item.codReception; hoja.Cell("X" + index).Value = item.client; index++; } //Rogging var hojaR = book.Worksheet("Rogging"); hojaR.Cell("B3").Value = filtro; hojaR.Cell("B4").Value = DateTime.Now.Date; hojaR.Cell("C3").Value = valor; index = 7; if (data.Rogging != null) { foreach (var item in data.Rogging) { hojaR.Cell("A" + index).Value = item.Euid; hojaR.Cell("B" + index).Value = item.FechaRogging; hojaR.Cell("C" + index).Value = item.Reason; hojaR.Cell("D" + index).Value = item.Year; hojaR.Cell("E" + index).Value = item.Country; hojaR.Cell("F" + index).Value = item.Location; hojaR.Cell("G" + index).Value = item.Rng; hojaR.Cell("H" + index).Value = item.Plt; hojaR.Cell("I" + index).Value = item.Ent; hojaR.Cell("J" + index).Value = item.ExpName; hojaR.Cell("K" + index).Value = item.ProjectLead; hojaR.Cell("L" + index).Value = item.Cc; hojaR.Cell("M" + index).Value = item.Crop; hojaR.Cell("N" + index).Value = item.Obs; hojaR.Cell("O" + index).Value = item.ProjectCode; hojaR.Cell("P" + index).Value = item.GmoEvent; hojaR.Cell("Q" + index).Value = item.Sag; hojaR.Cell("R" + index).Value = item.CodInternacion; hojaR.Cell("S" + index).Value = item.Client; hojaR.Cell("T" + index).Value = item.EntName; hojaR.Cell("U" + index).Value = item.EntRole; hojaR.Cell("V" + index).Value = item.ResImportacion; hojaR.Cell("W" + index).Value = item.GranosHilera; hojaR.Cell("X" + index).Value = item.Bi1; hojaR.Cell("Y" + index).Value = item.Bi2; hojaR.Cell("Z" + index).Value = item.Bi3; hojaR.Cell("AA" + index).Value = item.Bi4; hojaR.Cell("AB" + index).Value = item.Owner; hojaR.Cell("AC" + index).Value = item.CodPermanencia; hojaR.Cell("AD" + index).Value = item.LotId; index++; } } //Cosecha var hoja2 = book.Worksheet("Cosecha"); hoja2.Cell("B3").Value = filtro; hoja2.Cell("B4").Value = DateTime.Now.Date; hoja2.Cell("C3").Value = valor; index = 7; if (data.Cosecha != null) { foreach (var item in data.Cosecha) { hoja2.Cell("A" + index).Value = item.Euid; hoja2.Cell("B" + index).Value = item.FechaCosecha; hoja2.Cell("C" + index).Value = item.Bin; hoja2.Cell("D" + index).Value = item.order; hoja2.Cell("E" + index).Value = item.breedersCode1; hoja2.Cell("F" + index).Value = item.breedersCode2; hoja2.Cell("G" + index).Value = item.breedersCode3; hoja2.Cell("H" + index).Value = item.breedersCode4; hoja2.Cell("I" + index).Value = item.crop; hoja2.Cell("J" + index).Value = item.client; hoja2.Cell("K" + index).Value = item.projecLead; hoja2.Cell("L" + index).Value = item.location; hoja2.Cell("M" + index).Value = item.opExpName; hoja2.Cell("N" + index).Value = item.gmoEvent; hoja2.Cell("O" + index).Value = item.sag; index++; } } //Secado var hoja3 = book.Worksheet("Secado"); hoja3.Cell("B3").Value = filtro; hoja3.Cell("B4").Value = DateTime.Now.Date; hoja3.Cell("C3").Value = valor; index = 7; if (data.Secado != null) { foreach (var item in data.Secado) { hoja3.Cell("A" + index).Value = item.euid; hoja3.Cell("B" + index).Value = item.fechaInicio; hoja3.Cell("C" + index).Value = item.fechaTermino; hoja3.Cell("D" + index).Value = item.cajaSecador; hoja3.Cell("E" + index).Value = item.order; hoja3.Cell("F" + index).Value = item.breedersCode1; hoja3.Cell("G" + index).Value = item.breedersCode2; hoja3.Cell("H" + index).Value = item.breedersCode3; hoja3.Cell("I" + index).Value = item.breedersCode4; hoja3.Cell("J" + index).Value = item.crop; hoja3.Cell("K" + index).Value = item.client; hoja3.Cell("L" + index).Value = item.projecLead; hoja3.Cell("M" + index).Value = item.location; hoja3.Cell("N" + index).Value = item.opExpName; hoja3.Cell("O" + index).Value = item.gmoEvent; hoja3.Cell("P" + index).Value = item.sag; index++; } } //Desgrane var hoja4 = book.Worksheet("Desgrane"); hoja4.Cell("B3").Value = filtro; hoja4.Cell("B4").Value = DateTime.Now.Date; hoja4.Cell("C3").Value = valor; index = 7; if (data.Desgrane != null) { foreach (var item in data.Desgrane) { hoja4.Cell("A" + index).Value = item.euid; hoja4.Cell("B" + index).Value = item.fecha; hoja4.Cell("C" + index).Value = item.sheller; hoja4.Cell("D" + index).Value = item.shelling; hoja4.Cell("E" + index).Value = item.instructions; hoja4.Cell("F" + index).Value = item.order; hoja4.Cell("G" + index).Value = item.breedersCode1; hoja4.Cell("H" + index).Value = item.breedersCode2; hoja4.Cell("I" + index).Value = item.breedersCode3; hoja4.Cell("J" + index).Value = item.breedersCode4; hoja4.Cell("K" + index).Value = item.crop; hoja4.Cell("L" + index).Value = item.client; hoja4.Cell("M" + index).Value = item.projecLead; hoja4.Cell("N" + index).Value = item.location; hoja4.Cell("O" + index).Value = item.opExpName; hoja4.Cell("P" + index).Value = item.gmoEvent; hoja4.Cell("Q" + index).Value = item.sag; index++; } } //Packing var hoja5 = book.Worksheet("Packing"); hoja5.Cell("B3").Value = filtro; hoja5.Cell("B4").Value = DateTime.Now.Date; hoja5.Cell("C3").Value = valor; index = 7; if (data.Packing != null) { foreach (var item in data.Packing) { hoja5.Cell("A" + index).Value = item.euid; hoja5.Cell("B" + index).Value = item.indEuid; hoja5.Cell("C" + index).Value = item.fechaPacking; hoja5.Cell("D" + index).Value = item.totalWeight; hoja5.Cell("E" + index).Value = item.totalKernels; hoja5.Cell("F" + index).Value = item.totalEars; hoja4.Cell("G" + index).Value = item.shelling; hoja4.Cell("H" + index).Value = item.instructions; hoja4.Cell("I" + index).Value = item.targears; hoja4.Cell("J" + index).Value = item.targetKern; hoja4.Cell("K" + index).Value = item.targetWg; hoja5.Cell("L" + index).Value = item.order; hoja5.Cell("M" + index).Value = item.breedersCode1; hoja5.Cell("N" + index).Value = item.breedersCode2; hoja5.Cell("O" + index).Value = item.breedersCode3; hoja5.Cell("P" + index).Value = item.breedersCode4; hoja5.Cell("Q" + index).Value = item.crop; hoja5.Cell("R" + index).Value = item.client; hoja5.Cell("S" + index).Value = item.projecLead; hoja5.Cell("T" + index).Value = item.location; hoja5.Cell("U" + index).Value = item.opExpName; hoja5.Cell("V" + index).Value = item.gmoEvent; hoja5.Cell("W" + index).Value = item.sag; index++; } } //Llenado var hoja6 = book.Worksheet("Cajas"); hoja6.Cell("B3").Value = filtro; hoja6.Cell("B4").Value = DateTime.Now.Date; hoja6.Cell("C3").Value = valor; index = 7; if (data.Caja != null) { foreach (var item in data.Shipping) { hoja6.Cell("A" + index).Value = item.euid; hoja6.Cell("B" + index).Value = item.indEuid; hoja6.Cell("C" + index).Value = item.fechaPreparacion; hoja6.Cell("D" + index).Value = item.cajaEnvio; hoja6.Cell("E" + index).Value = item.order; hoja6.Cell("F" + index).Value = item.breedersCode1; hoja6.Cell("G" + index).Value = item.breedersCode2; hoja6.Cell("H" + index).Value = item.breedersCode3; hoja6.Cell("I" + index).Value = item.breedersCode4; hoja6.Cell("J" + index).Value = item.crop; hoja6.Cell("K" + index).Value = item.client; hoja6.Cell("L" + index).Value = item.projecLead; hoja6.Cell("M" + index).Value = item.location; hoja6.Cell("N" + index).Value = item.opExpName; hoja6.Cell("O" + index).Value = item.gmoEvent; hoja6.Cell("P" + index).Value = item.sag; index++; } } //Envio var hoja7 = book.Worksheet("Envío"); hoja7.Cell("B3").Value = filtro; hoja7.Cell("B4").Value = DateTime.Now.Date; hoja7.Cell("C3").Value = valor; index = 7; if (data.Caja != null) { foreach (var item in data.Caja) { hoja7.Cell("A" + index).Value = item.shipTo; hoja7.Cell("B" + index).Value = item.cajaEnvio; hoja7.Cell("C" + index).Value = item.creacion; hoja7.Cell("D" + index).Value = item.envio; hoja7.Cell("E" + index).Value = item.shipmentCode; hoja7.Cell("F" + index).Value = item.pesoNeto; hoja7.Cell("G" + index).Value = item.pesoBruto; index++; } } return(book); }
public async Task NewTracking(TrackingDto tracking) { await Clients.All.NewTracking(tracking); }
public TrackingDto Insert(TrackingDto tracking) { return(_trackingRepository.Insert(tracking)); }
public TrackingDto Update(int trackingId, TrackingDto tracking) { tracking.TrackingId = trackingId; return(_trackingRepository.Update(tracking)); }
public async Task DeleteTracking(TrackingDto tracking) { await _hubConnection.InvokeAsync("DeleteTracking", tracking); }
public async Task NewTracking(TrackingDto tracking) { await _hubConnection.InvokeAsync("NewTracking", tracking); }
public async Task UpdateTracking(TrackingDto tracking) { await Clients.All.UpdateTracking(tracking); }
public async Task Post([FromBody] TrackingDto trackingDto) { await _service.CreateTracking(User.FindFirst(ClaimTypes.Name).Value, trackingDto); }
public async Task DeleteTracking(TrackingDto tracking) { await Clients.All.DeleteTracking(tracking); }