public ShipmentDataResponse UpdateShipmentStatusById(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { ShipmentDataRequest data = this.context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); data.ID = shipmentDataRequest.ID; data.WFL_ID = shipmentDataRequest.WFL_ID; data.SMT_STA_NR = shipmentDataRequest.SMT_STA_NR; this.context.shipmentDataRequests.Update(data); this.context.Entry(shipmentDataRequest).State = EntityState.Detached; this.context.SaveChanges(); shipmentDataResponse.ShipmentDataRequest = this.context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public ShipmentDataResponse UpdateShipmentAddressById(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); using (var context = new ApplicationDbContext(optionsBuilder.Options)) { ShipmentDataRequest data = context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); int?shipmentStaus = data.SHP_ADR_TR_TE.ToLower() != shipmentDataRequest.SHP_ADR_TR_TE.ToLower() ? ((int)Enums.ATStatus.Curated) : (data.SMT_STA_NR); data.SHP_ADR_TR_TE = shipmentDataRequest.SHP_ADR_TR_TE; data.COD_TE = shipmentDataRequest.COD_TE; data.POD_RTN_SVC = shipmentDataRequest.POD_RTN_SVC; data.SMT_STA_NR = shipmentStaus; context.shipmentDataRequests.Update(data); context.Entry(shipmentDataRequest).State = EntityState.Detached; context.SaveChanges(); shipmentDataResponse.ShipmentDataRequest = context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); shipmentDataResponse.Success = true; return(shipmentDataResponse); } } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public ShipmentDataResponse DeleteShipment(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); var context = new ApplicationDbContext(optionsBuilder.Options); ShipmentDataRequest data = context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); context.shipmentDataRequests.Remove(data); context.Entry(shipmentDataRequest).State = EntityState.Deleted; context.SaveChanges(); shipmentDataResponse.Shipments = context.shipmentDataRequests; shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public ShipmentDataResponse UpdateShipmentStatusById(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); optionsBuilder.EnableSensitiveDataLogging(true); using (var context = new ApplicationDbContext(optionsBuilder.Options)) { ShipmentDataRequest data = context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); data.ID = shipmentDataRequest.ID; data.WFL_ID = shipmentDataRequest.WFL_ID; data.SMT_STA_NR = shipmentDataRequest.SMT_STA_NR; context.shipmentDataRequests.Update(data); context.Entry(shipmentDataRequest).State = EntityState.Detached; context.SaveChanges(); shipmentDataResponse.ShipmentDataRequest = context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); shipmentDataResponse.Success = true; return(shipmentDataResponse); } } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public async Task <ActionResult> DeleteShipments([FromBody] List <ShipmentDataRequest> shipmentDataRequests) { //ShipmentService shipmentService = new ShipmentService(); ShipmentDataResponse shipmentDataResponse = _shipmentService.DeleteShipments(shipmentDataRequests); return(Ok(shipmentDataResponse)); }
public ShipmentDataResponse GetCompletedShipments(int wid) { shipmentDataResponse = this._shipperCompanyService.SelectCompletedShipments(wid); if (!shipmentDataResponse.Success) { //AuditEventEntry.WriteEntry(new Exception(shipmentDataResponse.OperationExceptionMsg)); } return(shipmentDataResponse); }
public async Task <ActionResult> UpdateShipmentStatusById([FromBody] ShipmentDataRequest shipmentDataRequest) { //shipmentService = new ShipmentService(); ShipmentDataResponse shipmentDataResponse = _shipmentService.UpdateShipmentStatusById(shipmentDataRequest); if (!shipmentDataResponse.Success) { //AuditEventEntry.WriteEntry(new Exception(shipmentDataResponse.OperationExceptionMsg)); } return(Ok(shipmentDataResponse)); }
public async Task <ActionResult> UpdateShipmentAddressById([FromBody] ShipmentDataRequest shipmentDataRequest) { shipmentService = new ShipmentService(); ShipmentDataResponse shipmentDataResponse = shipmentService.UpdateShipmentAddressById(shipmentDataRequest); //we need to update the workflow status int?workflowstatus = shipmentService.SelectShipmentTotalStatusByWorkflowId(shipmentDataRequest.WFL_ID); WorkflowDataRequest workflowDataRequest = new WorkflowDataRequest(); workflowDataRequest.ID = shipmentDataRequest.WFL_ID; workflowDataRequest.WFL_STA_TE = workflowstatus; workflowService.UpdateWorkflowStatusById(workflowDataRequest); return(Ok(shipmentDataResponse)); }
public ShipmentDataResponse GetMatchedShipmentsWithShipperCompanies(int wid) { ShipperCompnayService shipperCompanyService = new ShipperCompnayService(); shipmentDataResponse = shipperCompanyService.SelectMatchedShipmentsWithShipperCompanies(wid); if (!shipmentDataResponse.Success) { AuditEventEntry.WriteEntry(new Exception(shipmentDataResponse.OperationExceptionMsg)); } //else //{ // var json = JsonConvert.SerializeObject(shipmentDataResponse.Shipments).ToString(); // AuditEventEntry.WriteEntry(new Exception(json)); //} return(shipmentDataResponse); }
//public ShipmentDataResponse UpdateShipmentAddressByIds(List<ShipmentDataRequest> shipmentDataRequest) //{ // ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); // try // { // optionsBuilder = new DbContextOptionsBuilder<ApplicationDbContext>(); // optionsBuilder = new DbContextOptionsBuilder<ApplicationDbContext>(); // var this.context = new ApplicationDbContext(optionsBuilder.Options); // List<ShipmentDataRequest> shipmentDetailsToUpdate = new List<ShipmentDataRequest>(); // foreach (ShipmentDataRequest request in shipmentDataRequest) // { // ShipmentDataRequest data = this.context.shipmentDataRequests.Where(s => s.ID == request.ID).FirstOrDefault(); // data.ID = request.ID; // data.WFL_ID = request.WFL_ID; // data.SHP_ADR_TR_TE = request.SHP_ADR_TR_TE; // data.SMT_STA_NR = request.SMT_STA_NR; // data.ACY_TE = request.ACY_TE; // data.CON_NR = request.CON_NR; // data.POD_RTN_SVC = request.POD_RTN_SVC; // shipmentDetailsToUpdate.Add(data); // //this.context.shipmentDataRequests.Update(data); // //this.context.Entry(request).State = EntityState.Detached; // //this.context.SaveChanges(); // shipmentDataResponse.Shipments = this.context.shipmentDataRequests; // } // this.context.BulkUpdate(shipmentDetailsToUpdate); // //shipmentDataResponse.Shipments = this.context.shipmentDataRequests; // shipmentDataResponse.Success = true; // return shipmentDataResponse; // } // catch (Exception ex) // { // shipmentDataResponse.Success = false; // shipmentDataResponse.OperationExceptionMsg = ex.Message; // } // return shipmentDataResponse; //} public ShipmentDataResponse DeleteShipments(List <ShipmentDataRequest> shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { int?workflowID = shipmentDataRequest?.FirstOrDefault().WFL_ID; int shipmentCount = 0; foreach (ShipmentDataRequest request in shipmentDataRequest) { ShipmentDataRequest data = this.context.shipmentDataRequests.Where(s => s.ID == request.ID).FirstOrDefault(); this.context.shipmentDataRequests.Remove(data); this.context.Entry(request).State = EntityState.Detached; this.context.SaveChanges(); } if (workflowID.HasValue) { shipmentCount = this.context.shipmentDataRequests.Where(ship => ship.WFL_ID == workflowID).Count(); } if (shipmentCount == 0) { WorkflowService workflowService = new WorkflowService(this.context, this.addressBookService, this.entityValidationService); WorkflowDataResponse workflowDataResponse = workflowService.DeleteWorkflowById(workflowID.Value); if (workflowDataResponse.Success) { shipmentDataResponse.HasWorkflow = false; } } else { shipmentDataResponse.HasWorkflow = true; } shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public ShipmentDataResponse CreateShipments(List <ExcelDataObject> excelDataObjects, int workflowID, string addressBookEnable, out int?workflowStatus) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); workflowStatus = 0; try { List <ShipmentDataRequest> shipmentDataRequest = ExtractShipmentDataRequest(excelDataObjects, workflowID, addressBookEnable, out workflowStatus); shipmentDataResponse = CreateShipments(shipmentDataRequest); shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception exception) { shipmentDataResponse.OperationExceptionMsg = exception.Message; shipmentDataResponse.Success = true; //AuditEventEntry.WriteEntry(new Exception(exception.Message)); } return(shipmentDataResponse); }
public ShipmentDataResponse DeleteShipment(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { ShipmentDataRequest data = this.context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); this.context.shipmentDataRequests.Remove(data); this.context.Entry(shipmentDataRequest).State = EntityState.Deleted; this.context.SaveChanges(); shipmentDataResponse.Shipments = this.context.shipmentDataRequests; shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public ShipmentDataResponse UpdateShipmentAddressByIds(List <ShipmentDataRequest> shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); var context = new ApplicationDbContext(optionsBuilder.Options); foreach (ShipmentDataRequest request in shipmentDataRequest) { ShipmentDataRequest data = context.shipmentDataRequests.Where(s => s.ID == request.ID).FirstOrDefault(); data.ID = request.ID; data.WFL_ID = request.WFL_ID; data.SHP_ADR_TR_TE = request.SHP_ADR_TR_TE; data.SMT_STA_NR = request.SMT_STA_NR; data.ACY_TE = request.ACY_TE; data.CON_NR = request.CON_NR; data.POD_RTN_SVC = request.POD_RTN_SVC; context.shipmentDataRequests.Update(data); context.Entry(request).State = EntityState.Detached; context.SaveChanges(); shipmentDataResponse.Shipments = context.shipmentDataRequests; } shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
public IActionResult GetMatchedShipmentsWithShipperCompanies(int wid) { string id = HttpContext.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserId)?.Value; if (string.IsNullOrEmpty(id)) { return(Unauthorized()); } int userId = Convert.ToInt32(id); shipmentDataResponse = this._shipperCompanyService.SelectMatchedShipmentsWithShipperCompanies(wid, userId); if (!shipmentDataResponse.Success) { //AuditEventEntry.WriteEntry(new Exception(shipmentDataResponse.OperationExceptionMsg)); } //else //{ // var json = JsonConvert.SerializeObject(shipmentDataResponse.Shipments).ToString(); // AuditEventEntry.WriteEntry(new Exception(json)); //} return(Ok(shipmentDataResponse)); }
public ShipmentDataResponse CreateShipments(List <ShipmentDataRequest> shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { List <ShipmentDataRequest> validEntities = this.entityValidationService.FilterValidEntity <ShipmentDataRequest>(shipmentDataRequest); if (validEntities != null && validEntities.Any()) { this.context.BulkInsert(validEntities); shipmentDataResponse.Shipments = shipmentDataRequest; //this.context.shipmentDataRequests.ToList(); shipmentDataResponse.Success = true; } return(shipmentDataResponse); } catch (Exception exception) { throw exception; } }
public ShipmentDataResponse UpdateShipmentAddressById(ShipmentDataRequest shipmentDataRequest) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { //Shipment Update ShipmentDataRequest data = this.context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); string beforeAddress = data.SHP_ADR_TR_TE; int? shipmentStaus = data.SHP_ADR_TR_TE.ToLower() != shipmentDataRequest.SHP_ADR_TR_TE.ToLower() ? ((int)Enums.ATStatus.Curated) : (data.SMT_STA_NR); data.SHP_ADR_TR_TE = shipmentDataRequest.SHP_ADR_TR_TE; data.COD_TE = shipmentDataRequest.COD_TE; data.POD_RTN_SVC = shipmentDataRequest.POD_RTN_SVC; data.SMT_STA_NR = shipmentStaus; switch (shipmentStaus) { case 0: shipmentDataRequest.SMT_STA_TE = "Uploaded"; break; case 1: shipmentDataRequest.SMT_STA_TE = "Curated"; break; case 2: shipmentDataRequest.SMT_STA_TE = "Translated"; break; case 3: shipmentDataRequest.SMT_STA_TE = "Completed"; break; case 4: shipmentDataRequest.SMT_STA_TE = "Inactive"; break; default: shipmentDataRequest.SMT_STA_TE = "Uploaded"; break; } this.context.shipmentDataRequests.Update(data); this.context.Entry(shipmentDataRequest).State = EntityState.Detached; this.context.SaveChanges(); shipmentDataResponse.ShipmentDataRequest = this.context.shipmentDataRequests.Where(s => s.ID == shipmentDataRequest.ID).FirstOrDefault(); shipmentDataResponse.Success = true; shipmentDataResponse.BeforeAddress = string.Empty; if (!string.Equals(beforeAddress, data.SHP_ADR_TR_TE)) { shipmentDataResponse.BeforeAddress = beforeAddress; if (shipmentDataRequest.RCV_ADR_TE != null) { var matchedShipments = this.context.shipmentDataRequests.Where(s => s.RCV_ADR_TE == shipmentDataRequest.RCV_ADR_TE).ToList(); if (matchedShipments.Any()) { matchedShipments.ForEach(shipment => { shipment.SHP_ADR_TR_TE = data.SHP_ADR_TR_TE; shipment.SMT_STA_NR = shipmentStaus; }); this.context.BulkUpdate(matchedShipments); } List <AddressBook> addressBookElements = this.context.AddressBooks.Where(s => s.ConsigneeAddress == shipmentDataRequest.RCV_ADR_TE).ToList(); if (addressBookElements.Any()) { addressBookElements.FirstOrDefault().ConsigneeTranslatedAddress = data.SHP_ADR_TR_TE; addressBookElements.FirstOrDefault().ModifiedDate = DateTime.Parse(DateTime.Now.ToString()).ToLocalTime(); this.context.BulkUpdate(addressBookElements); } } } return(shipmentDataResponse); } catch (Exception ex) { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = ex.Message; } return(shipmentDataResponse); }
//[Authorize(AuthenticationSchemes = JwtBearerDefaults.AuthenticationScheme)] //[HttpPost] public ShipmentDataResponse CreateShipments(List <ExcelDataObject> excelDataObjects, int workflowID) { //int i = 0; ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { List <ShipmentDataRequest> shipmentData = new List <ShipmentDataRequest>(); foreach (ExcelDataObject excelDataObject in excelDataObjects) { bool allPropertiesNull = !excelDataObject.GetType().GetProperties().Any(prop => prop == null); if (allPropertiesNull) { ShipmentDataRequest shipmentDataRequest = new ShipmentDataRequest(); if (!string.IsNullOrWhiteSpace(excelDataObject.S_shipmentno)) { shipmentDataRequest.BIL_TYP_TE = excelDataObject.S_billtype; shipmentDataRequest.CCY_VAL_TE = string.Empty; shipmentDataRequest.COD_TE = string.Empty; shipmentDataRequest.CSG_CTC_TE = excelDataObject.S_cneectc; decimal decimalvalue = 0; shipmentDataRequest.DIM_WGT_DE = 0; if (!string.IsNullOrEmpty(excelDataObject.S_dimwei)) { if (decimal.TryParse(excelDataObject.S_dimwei, out decimalvalue)) { shipmentDataRequest.DIM_WGT_DE = decimalvalue; } } //shipmentDataRequest.DIM_WGT_DE = null; //Convert.ToDecimal(excelDataObject.S_dimwei); shipmentDataRequest.DST_CTY_TE = excelDataObject.S_dstcity; shipmentDataRequest.DST_PSL_TE = excelDataObject.S_dstpsl; shipmentDataRequest.EXP_SLC_CD = excelDataObject.S_expslic; shipmentDataRequest.EXP_TYP = "顺丰即日";//excelDataObject.S_expslic; shipmentDataRequest.IMP_NR = excelDataObject.S_impr; shipmentDataRequest.IMP_SLC_TE = excelDataObject.S_impslic; shipmentDataRequest.IN_FLG_TE = excelDataObject.S_inflight; shipmentDataRequest.ORG_CTY_TE = excelDataObject.S_orgcity; string pststring = Convert.ToString(excelDataObject.S_orgpsl); if (InputValidations.IsDecimalFormat(pststring)) { shipmentDataRequest.ORG_PSL_CD = Decimal.ToInt32(Decimal.Parse(pststring)).ToString(); } else { shipmentDataRequest.ORG_PSL_CD = pststring; } // OU_FLG_TE = Convert.ToString(excelDataObject.S_outflight), int intvalue = 0; shipmentDataRequest.PCS_QTY_NR = 0; if (!string.IsNullOrEmpty(excelDataObject.pcs)) { if (int.TryParse(excelDataObject.pcs, out intvalue)) { shipmentDataRequest.PCS_QTY_NR = intvalue; } } //shipmentDataRequest.PCS_QTY_NR = null;//Convert.ToInt32(Convert.ToDouble(excelDataObject.pcs)); shipmentDataRequest.PH_NR = excelDataObject.S_ph; shipmentDataRequest.PKG_NR_TE = excelDataObject.S_packageno; shipmentDataRequest.PKG_WGT_DE = Convert.ToDecimal(excelDataObject.S_pkgwei); shipmentDataRequest.PK_UP_TM = null; //Convert.ToString(excelDataObject.S_pkuptime), shipmentDataRequest.PYM_MTD = "寄付月结"; //excelDataObject.pymt; shipmentDataRequest.RCV_ADR_TE = excelDataObject.S_address1; shipmentDataRequest.RCV_CPY_TE = excelDataObject.S_receivercompany; shipmentDataRequest.SHP_ADR_TE = excelDataObject.address; shipmentDataRequest.SHP_ADR_TR_TE = string.Empty; shipmentDataRequest.SHP_CPY_NA = excelDataObject.S_shippercompany; shipmentDataRequest.SHP_CTC_TE = excelDataObject.S_shptctc; DateTime dDate; int intdate; shipmentDataRequest.SHP_DT = null; if (!string.IsNullOrEmpty(excelDataObject.S_shipdate)) { if (int.TryParse(excelDataObject.S_shipdate, out intdate)) { shipmentDataRequest.SHP_DT = null; } else if (DateTime.TryParse(excelDataObject.S_shipdate, out dDate)) { shipmentDataRequest.SHP_DT = Convert.ToDateTime(excelDataObject.S_shipdate); } } //if(!string.IsNullOrEmpty(excelDataObject.S_shipdate)) //{ // if (DateTime.TryParse(excelDataObject.S_shipdate, out dDate)) // { // shipmentDataRequest.SHP_DT = Convert.ToDateTime(excelDataObject.S_shipdate); // } //} shipmentDataRequest.SHP_DT = null; //Convert.ToDateTime(excelDataObject.S_shipdate); shipmentDataRequest.SHP_NR = excelDataObject.S_shpr; shipmentDataRequest.SHP_PH_TE = excelDataObject.S_shptph; shipmentDataRequest.SMT_NR_TE = excelDataObject.S_shipmentno; shipmentDataRequest.SMT_STA_NR = 0; shipmentDataRequest.SMT_STA_TE = "Uploaded"; shipmentDataRequest.SMT_VAL_DE = 0; shipmentDataRequest.SMT_WGT_DE = Convert.ToDecimal(excelDataObject.S_shptwei); shipmentDataRequest.SVL_NR = Convert.ToString(excelDataObject.svl); shipmentDataRequest.WGT_UNT_TE = excelDataObject.S_weiunit; shipmentDataRequest.WFL_ID = workflowID; shipmentDataRequest.SF_TRA_LG_ID = null; shipmentDataRequest.QQS_TRA_LG_ID = null; shipmentDataRequest.FST_INV_LN_DES_TE = excelDataObject.S_1stinvoicelinedesc; shipmentDataRequest.POD_RTN_SVC = "0"; shipmentData.Add(shipmentDataRequest); } } } shipmentService = new ShipmentService(); shipmentDataResponse = shipmentService.CreateShipments(shipmentData); shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception exception) { shipmentDataResponse.OperationExceptionMsg = exception.Message; shipmentDataResponse.Success = true; AuditEventEntry.WriteEntry(new Exception(exception.Message)); } return(shipmentDataResponse); }
public ShipmentDataResponse CreateShipments(List <ShipmentDataRequest> shipmentData) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); using (var context = new ApplicationDbContext(optionsBuilder.Options)) { foreach (ShipmentDataRequest Data in shipmentData) { ShipmentDataRequest shipmentDataRequest = new ShipmentDataRequest(); shipmentDataRequest.BIL_TYP_TE = Data.BIL_TYP_TE; shipmentDataRequest.CCY_VAL_TE = Data.CCY_VAL_TE; shipmentDataRequest.COD_TE = Data.COD_TE; shipmentDataRequest.CSG_CTC_TE = Data.CSG_CTC_TE; shipmentDataRequest.DIM_WGT_DE = Data.DIM_WGT_DE; shipmentDataRequest.DST_CTY_TE = Data.DST_CTY_TE; shipmentDataRequest.DST_PSL_TE = Data.DST_PSL_TE; shipmentDataRequest.EXP_SLC_CD = Data.EXP_SLC_CD; shipmentDataRequest.EXP_TYP = Data.EXP_TYP; shipmentDataRequest.FST_INV_LN_DES_TE = Data.FST_INV_LN_DES_TE; shipmentDataRequest.IMP_NR = Data.IMP_NR; shipmentDataRequest.IMP_SLC_TE = Data.IMP_SLC_TE; shipmentDataRequest.IN_FLG_TE = Data.IN_FLG_TE; shipmentDataRequest.ORG_CTY_TE = Data.ORG_CTY_TE; shipmentDataRequest.ORG_PSL_CD = Data.ORG_PSL_CD; shipmentDataRequest.OU_FLG_TE = Data.OU_FLG_TE; shipmentDataRequest.PCS_QTY_NR = Data.PCS_QTY_NR; shipmentDataRequest.PH_NR = Data.PH_NR; shipmentDataRequest.PKG_NR_TE = Data.PKG_NR_TE; shipmentDataRequest.PKG_WGT_DE = Data.PKG_WGT_DE; shipmentDataRequest.PK_UP_TM = null; //Data.PK_UP_TM; shipmentDataRequest.PYM_MTD = Data.PYM_MTD; shipmentDataRequest.PY_MT_TE = Data.PY_MT_TE; shipmentDataRequest.QQS_TRA_LG_ID = Data.QQS_TRA_LG_ID; shipmentDataRequest.RCV_ADR_TE = Data.RCV_ADR_TE; shipmentDataRequest.RCV_CPY_TE = Data.RCV_CPY_TE; shipmentDataRequest.SF_TRA_LG_ID = Data.SF_TRA_LG_ID; shipmentDataRequest.SHP_ADR_TE = Data.SHP_ADR_TE; shipmentDataRequest.SHP_ADR_TR_TE = Data.SHP_ADR_TR_TE; shipmentDataRequest.SHP_CPY_NA = Data.SHP_CPY_NA; shipmentDataRequest.SHP_CTC_TE = Data.SHP_CTC_TE; shipmentDataRequest.SHP_DT = null; //Data.SHP_DT; shipmentDataRequest.SHP_NR = Data.SHP_NR; shipmentDataRequest.SHP_PH_TE = Data.SHP_PH_TE; shipmentDataRequest.SMT_NR_TE = Data.SMT_NR_TE; shipmentDataRequest.SMT_STA_NR = Data.SMT_STA_NR; shipmentDataRequest.SMT_VAL_DE = Data.SMT_VAL_DE; shipmentDataRequest.SMT_WGT_DE = Data.SMT_WGT_DE; shipmentDataRequest.SVL_NR = Data.SVL_NR; shipmentDataRequest.WFL_ID = Data.WFL_ID; shipmentDataRequest.WGT_UNT_TE = Data.WGT_UNT_TE; shipmentDataRequest.POD_RTN_SVC = Data.POD_RTN_SVC; context.shipmentDataRequests.Add(shipmentDataRequest); context.Entry(shipmentDataRequest).State = EntityState.Added; } context.SaveChanges(); shipmentDataResponse.Shipments = shipmentData; //context.shipmentDataRequests.ToList(); shipmentDataResponse.Success = true; return(shipmentDataResponse); } //return shipmentDataResponse; } catch (Exception exception) { throw exception; } }
public async Task <ActionResult> ExcelFile(IList <IFormFile> excelFileName) { string[] validationSet = configuration.GetSection("ExcelFileValidation:mandatoryFields").GetChildren().Select(val => val.Value).ToArray(); string[] cellValidationSet = configuration.GetSection("ExcelFileValidation:cellValidationFields").GetChildren().Select(val => val.Value).ToArray(); string addressBookEnable = configuration["AddressBook:Enable"]; ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { int userId = Convert.ToInt32(HttpContext.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserId).Value); ShipmentDataResponse result = null; //string response = string.Empty; if (excelFileName != null) { //var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "uploads"); foreach (var file in excelFileName) { if (file.Length > 0) { //string paths = hostingEnvironment.WebRootPath; var filePath = Path.Combine(_hostingEnvironment.WebRootPath, file.FileName); //var filePath = Path.Combine(@"D:\UserExcels", file.FileName); using (var fileStream = new FileStream(filePath, FileMode.Create)) { //FileStream stream = File.Open(fileName, FileMode.Open, FileAccess.Read); //response = new ExcelExtension().Test(filePath); await file.CopyToAsync(fileStream); } ExcelExtensionReponse excelExtensionReponse = new ExcelExtension() .Test( filePath, configuration.GetSection("ExcelFileValidation:mandatoryFields").GetChildren().Select(val => val.Value).ToArray(), configuration.GetSection("ColumnValidation:regexList").GetChildren().Select(val => val.Value).ToArray(), configuration.GetSection("ColumnValidation:columnLengths").GetChildren().Select(val => val.Value).ToArray()); if (excelExtensionReponse.success) { var excelDataObject2 = JsonConvert.DeserializeObject <List <ExcelDataObject> >(excelExtensionReponse.ExcelExtensionReponseData); WorkflowController workflowController = new WorkflowController(this._hostingEnvironment, this._context, this._addressBookService, this._entityValidationService); WorkflowDataResponse response = ((WorkflowDataResponse)((ObjectResult)(workflowController.CreateWorkflow(file, userId)).Result).Value); _workflowID = response.Workflow.ID; result = _shipmentService.CreateShipments(excelDataObject2, _workflowID, addressBookEnable, out int?workflowStatus); if (result.Success) { shipmentDataResponse.Success = true; shipmentDataResponse.Shipments = result.Shipments; WorkflowDataRequest workflowDataRequest = new WorkflowDataRequest(); workflowDataRequest.ID = _workflowID; workflowDataRequest.WFL_STA_TE = workflowStatus; _workflowService.UpdateWorkflowStatusById(workflowDataRequest); } else { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = result.OperationExceptionMsg; WorkflowService workflowService = new WorkflowService(_context, _addressBookService, _entityValidationService); workflowService.DeleteWorkflowById(_workflowID); } } else { #pragma warning disable CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed Task.Run(() => iCustomLog.AddLogEntry(new UPS.DataObjects.LogData.LogDataModel() { apiType = Enum.GetName(typeof(UPS.DataObjects.LogData.APITypes), 7), dateTime = System.DateTime.Now, LogInformation = new UPS.DataObjects.LogData.LogInformation() { LogException = string.Empty, LogRequest = "Excel Uploaded", LogResponse = JsonConvert.SerializeObject(excelExtensionReponse) } })); #pragma warning restore CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed return(Ok(excelExtensionReponse)); } } } } #pragma warning disable CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed Task.Run(() => iCustomLog.AddLogEntry(new UPS.DataObjects.LogData.LogDataModel() { apiTypes = UPS.DataObjects.LogData.APITypes.ExcelUpload, apiType = Enum.GetName(typeof(UPS.DataObjects.LogData.APITypes), 7), dateTime = System.DateTime.Now, LogInformation = new UPS.DataObjects.LogData.LogInformation() { LogException = null, LogRequest = "Excel Uploaded", LogResponse = JsonConvert.SerializeObject(shipmentDataResponse) } })); #pragma warning restore CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed return(Ok(shipmentDataResponse)); } catch (Exception ex) { // new AuditEventEntry.WriteEntry(new Exception(ex.Message)); AuditEventEntry.WriteEntry(ex); return(Ok(shipmentDataResponse.OperationExceptionMsg = ex.Message)); } }
public async Task <ActionResult> ExcelFile(IList <IFormFile> excelFileName, int Emp_Id) { ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { ShipmentDataResponse result = null; //string response = string.Empty; if (excelFileName != null) { //var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "uploads"); foreach (var file in excelFileName) { if (file.Length > 0) { //string paths = hostingEnvironment.WebRootPath; var filePath = Path.Combine(hostingEnvironment.WebRootPath, file.FileName); //var filePath = Path.Combine(@"D:\UserExcels", file.FileName); using (var fileStream = new FileStream(filePath, FileMode.Create)) { //FileStream stream = File.Open(fileName, FileMode.Open, FileAccess.Read); //response = new ExcelExtension().Test(filePath); await file.CopyToAsync(fileStream); } ExcelExtensionReponse excelExtensionReponse = new ExcelExtension().Test(filePath); if (excelExtensionReponse.success) { var excelDataObject2 = JsonConvert.DeserializeObject <List <ExcelDataObject> >(excelExtensionReponse.ExcelExtensionReponseData); WorkflowController workflowController = new WorkflowController(); WorkflowDataResponse response = ((WorkflowDataResponse)((ObjectResult)(workflowController.CreateWorkflow(file, Emp_Id)).Result).Value); _workflowID = response.Workflow.ID; result = this.CreateShipments(excelDataObject2, _workflowID); if (result.Success) { shipmentDataResponse.Success = true; shipmentDataResponse.Shipments = result.Shipments; } else { shipmentDataResponse.Success = false; shipmentDataResponse.OperationExceptionMsg = result.OperationExceptionMsg; WorkflowService workflowService = new WorkflowService(); workflowService.DeleteWorkflowById(_workflowID); } } else { return(Ok(excelExtensionReponse)); } } } } return(Ok(shipmentDataResponse)); } catch (Exception ex) { AuditEventEntry.WriteEntry(new Exception(ex.Message)); return(Ok(shipmentDataResponse.OperationExceptionMsg = ex.Message)); } }
public ShipmentDataResponse SelectCompletedShipments(int workflowID) { ShipmentDataResponse mappedShipAndShipperCompanyResponse = new ShipmentDataResponse(); List <ShipmentDataRequest> shipmentDataRequests = null; try { optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>(); using (var context = new ApplicationDbContext(optionsBuilder.Options)) { shipmentDataRequests = new List <ShipmentDataRequest>(); var anonymousList = ( from s in context.shipmentDataRequests join c in context.shipperCompanyRequests on s.DST_PSL_TE equals c.SPC_PSL_CD_TE where s.WFL_ID == workflowID where s.WFL_ID == workflowID && s.SMT_STA_NR == ((int)Enums.ATStatus.Completed) orderby s.ID select new { s.ID, s.WFL_ID, s.ACY_TE, s.BIL_TYP_TE, s.CCY_VAL_TE, s.COD_TE, s.CON_NR, s.CSG_CTC_TE, s.DIM_WGT_DE, s.DST_CTY_TE, s.DST_PSL_TE, s.EXP_SLC_CD, s.EXP_TYP, s.FST_INV_LN_DES_TE, s.IMP_NR, s.IMP_SLC_TE, s.IN_FLG_TE, ORG_CTY_TE = c.SPC_CTY_TE, ORG_PSL_CD = c.SPC_PSL_CD_TE, s.OU_FLG_TE, s.PCS_QTY_NR, s.PH_NR, s.PKG_NR_TE, s.PKG_WGT_DE, s.PK_UP_TM, s.PYM_MTD, s.PY_MT_TE, s.QQS_TRA_LG_ID, s.RCV_ADR_TE, s.RCV_CPY_TE, s.SF_TRA_LG_ID, SHP_ADR_TE = c.SPC_ADR_TE, s.SHP_ADR_TR_TE, SHP_CPY_NA = c.SPC_CPY_TE, SHP_CTC_TE = c.SPC_NA, s.SHP_DT, s.SHP_NR, SHP_PH_TE = c.SPC_SND_PTY_CTC_TE, s.SMT_NR_TE, s.SMT_STA_NR, s.SMT_VAL_DE, s.SMT_WGT_DE, SPC_SLIC_NR = c.SPC_SLIC_NR, s.SVL_NR, s.WGT_UNT_TE, s.POD_RTN_SVC }).ToList(); foreach (var shipmentData in anonymousList) { ShipmentDataRequest shipmentDataRequest = new ShipmentDataRequest(); shipmentDataRequest.ID = shipmentData.ID; shipmentDataRequest.BIL_TYP_TE = shipmentData.BIL_TYP_TE; shipmentDataRequest.CCY_VAL_TE = shipmentData.CCY_VAL_TE; shipmentDataRequest.COD_TE = shipmentData.COD_TE; shipmentDataRequest.CSG_CTC_TE = shipmentData.CSG_CTC_TE; shipmentDataRequest.DIM_WGT_DE = shipmentData.DIM_WGT_DE; shipmentDataRequest.DST_CTY_TE = shipmentData.DST_CTY_TE; shipmentDataRequest.DST_PSL_TE = shipmentData.DST_PSL_TE; shipmentDataRequest.EXP_SLC_CD = shipmentData.EXP_SLC_CD; shipmentDataRequest.EXP_TYP = shipmentData.EXP_TYP; shipmentDataRequest.FST_INV_LN_DES_TE = shipmentData.FST_INV_LN_DES_TE; shipmentDataRequest.IMP_NR = shipmentData.IMP_NR; shipmentDataRequest.IMP_SLC_TE = shipmentData.IMP_SLC_TE; shipmentDataRequest.IN_FLG_TE = shipmentData.IN_FLG_TE; shipmentDataRequest.ORG_CTY_TE = shipmentData.ORG_CTY_TE; shipmentDataRequest.ORG_PSL_CD = shipmentData.ORG_PSL_CD; shipmentDataRequest.OU_FLG_TE = shipmentData.OU_FLG_TE; shipmentDataRequest.PCS_QTY_NR = shipmentData.PCS_QTY_NR; shipmentDataRequest.PH_NR = shipmentData.PH_NR; shipmentDataRequest.PKG_NR_TE = shipmentData.PKG_NR_TE; shipmentDataRequest.PKG_WGT_DE = shipmentData.PKG_WGT_DE; shipmentDataRequest.PK_UP_TM = shipmentData.PK_UP_TM; shipmentDataRequest.PYM_MTD = shipmentData.PYM_MTD; shipmentDataRequest.PY_MT_TE = shipmentData.PY_MT_TE; shipmentDataRequest.QQS_TRA_LG_ID = shipmentData.QQS_TRA_LG_ID; shipmentDataRequest.RCV_ADR_TE = shipmentData.RCV_ADR_TE; shipmentDataRequest.RCV_CPY_TE = shipmentData.RCV_CPY_TE; shipmentDataRequest.SF_TRA_LG_ID = shipmentData.SF_TRA_LG_ID; shipmentDataRequest.SHP_ADR_TE = shipmentData.SHP_ADR_TE; shipmentDataRequest.SHP_ADR_TR_TE = shipmentData.SHP_ADR_TR_TE; shipmentDataRequest.SHP_CPY_NA = shipmentData.SHP_CPY_NA; shipmentDataRequest.SHP_CTC_TE = shipmentData.SHP_CTC_TE; shipmentDataRequest.SHP_DT = shipmentData.SHP_DT; shipmentDataRequest.SHP_NR = shipmentData.SHP_NR; shipmentDataRequest.SHP_PH_TE = shipmentData.SHP_PH_TE; shipmentDataRequest.SMT_NR_TE = shipmentData.SMT_NR_TE; shipmentDataRequest.SMT_STA_NR = shipmentData.SMT_STA_NR; switch (shipmentDataRequest.SMT_STA_NR) { case 0: shipmentDataRequest.SMT_STA_TE = "Uploaded"; break; case 1: shipmentDataRequest.SMT_STA_TE = "Curated"; break; case 2: shipmentDataRequest.SMT_STA_TE = "Translated"; break; case 3: shipmentDataRequest.SMT_STA_TE = "Completed"; break; case 4: shipmentDataRequest.SMT_STA_TE = "Inactive"; break; default: shipmentDataRequest.SMT_STA_TE = "Uploaded"; break; } shipmentDataRequest.SMT_VAL_DE = shipmentData.SMT_VAL_DE; shipmentDataRequest.SMT_WGT_DE = shipmentData.SMT_WGT_DE; shipmentDataRequest.SVL_NR = shipmentData.SVL_NR; shipmentDataRequest.WFL_ID = shipmentData.WFL_ID; shipmentDataRequest.WGT_UNT_TE = shipmentData.WGT_UNT_TE; shipmentDataRequest.ACY_TE = shipmentData.ACY_TE; shipmentDataRequest.CON_NR = shipmentData.CON_NR; shipmentDataRequest.SPC_SLIC_NR = shipmentData.SPC_SLIC_NR; shipmentDataRequest.POD_RTN_SVC = shipmentData.POD_RTN_SVC; shipmentDataRequests.Add(shipmentDataRequest); } //shipmentDataRequests = anonymousList.Cast<ShipmentDataRequest>().ToList(); mappedShipAndShipperCompanyResponse.Success = true; mappedShipAndShipperCompanyResponse.Shipments = shipmentDataRequests; } } catch (Exception ex) { mappedShipAndShipperCompanyResponse.Success = false; mappedShipAndShipperCompanyResponse.OperationExceptionMsg = ex.Message; } return(mappedShipAndShipperCompanyResponse); }
public async Task <ActionResult> UpdateShipmentAddressById([FromBody] ShipmentDataRequest shipmentDataRequest) { //shipmentService = new ShipmentService(); string id = HttpContext.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserId)?.Value; int userId = !string.IsNullOrEmpty(id) ? Convert.ToInt32(id) : 0; ShipmentDataResponse shipmentDataResponse = _shipmentService.UpdateShipmentAddressById(shipmentDataRequest); if (shipmentDataResponse.Success && !string.IsNullOrEmpty(shipmentDataResponse.BeforeAddress)) { try { //AddressAuditLog Update AddressAuditLogRequest addressAuditLogRequest = new AddressAuditLogRequest(); addressAuditLogRequest.SMT_ID = shipmentDataRequest.ID; addressAuditLogRequest.CSG_ADR = shipmentDataRequest.RCV_ADR_TE; addressAuditLogRequest.BFR_ADR = shipmentDataResponse.BeforeAddress; addressAuditLogRequest.AFR_ADR = shipmentDataResponse.ShipmentDataRequest.SHP_ADR_TR_TE; addressAuditLogRequest.UPD_BY = userId; addressAuditLogRequest.UPD_FRM = "Shipment"; addressAuditLogRequest.UPD_DT = DateTime.Parse(DateTime.Now.ToString()).ToLocalTime(); addressAuditLogRequest.WFL_ID = shipmentDataResponse.ShipmentDataRequest.WFL_ID; AddressAuditLogResponse addressAuditLogResponse = addressAuditLogService.Insert(addressAuditLogRequest); if (addressAuditLogResponse.Success) { // TO DO } else { // Log the error here } } catch (Exception ex) { } } //we need to update the workflow status int?workflowstatus = _shipmentService.SelectShipmentTotalStatusByWorkflowId(shipmentDataRequest.WFL_ID); WorkflowDataRequest workflowDataRequest = new WorkflowDataRequest(); workflowDataRequest.ID = shipmentDataRequest.WFL_ID; workflowDataRequest.WFL_STA_TE = workflowstatus; _workflowService.UpdateWorkflowStatusById(workflowDataRequest); #pragma warning disable CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed Task.Run(() => iCustomLog.AddLogEntry(new UPS.DataObjects.LogData.LogDataModel() { apiTypes = UPS.DataObjects.LogData.APITypes.EFCoreContext, apiType = Enum.GetName(typeof(UPS.DataObjects.LogData.APITypes), 6), dateTime = System.DateTime.Now, LogInformation = new UPS.DataObjects.LogData.LogInformation() { LogException = null, LogRequest = JsonConvert.SerializeObject(shipmentDataRequest), LogResponse = JsonConvert.SerializeObject(shipmentDataResponse) } })); #pragma warning restore CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed return(Ok(shipmentDataResponse)); }