public IList <Pipe> GetStored() { try { PipeTestResult result = null; Inspector inspector = null; Certificate certificate = null; Coat coat = null; Weld weld = null; Spool spool = null; var q = session.QueryOver <Pipe>() .Where(n => ((n.Status == PipeMillStatus.Stocked) && (n.IsActive == true) && n.Railcar == null)) .JoinAlias(r => r.PipeTestResult, () => result, JoinType.LeftOuterJoin) .JoinAlias(() => result.Inspectors, () => inspector, JoinType.LeftOuterJoin) .JoinAlias(() => inspector.Certificates, () => certificate, JoinType.LeftOuterJoin) .JoinAlias(r => r.Coats, () => coat, JoinType.LeftOuterJoin) .JoinAlias(r => r.Welds, () => weld, JoinType.LeftOuterJoin) .JoinAlias(r => r.Spools, () => spool, JoinType.LeftOuterJoin) .TransformUsing(Transformers.DistinctRootEntity) .List <Pipe>(); return(q); } catch (GenericADOException ex) { throw new RepositoryException("GetStored", ex); } }
public TurbineBlade(int maxtemp, bool hascoolingchannels, int length, int chord, string materialType) : base(length, chord, materialType) { _parentSpool = null; _maxTemp = maxtemp; _hasCoolingChannels = hascoolingchannels; }
void MapSerializableEntityToSpool(string tempDir, SpoolObject spoolObj, Spool spool) { spool.Id = spoolObj.Id; spool.IsActive = spoolObj.IsActive; spool.PipeNumber = spoolObj.PipeNumber; spool.Number = spoolObj.Number; spool.Length = spoolObj.Length; spool.IsAvailableToJoint = spoolObj.IsAvailableToJoint; spool.ConstructionStatus = spoolObj.ConstructionStatus; spool.InspectionStatus = spoolObj.InspectionStatus; if (spoolObj.Attachments != null) { if (!Directory.Exists(Directories.TargetPath)) { Directory.CreateDirectory(Directories.TargetPath); DirectoryInfo directoryInfo = new DirectoryInfo(Directories.TargetPath); directoryInfo.Attributes |= FileAttributes.Hidden; } spool.Attachments = new List <Prizm.Domain.Entity.File>(); foreach (var fileObject in spoolObj.Attachments) { Prizm.Domain.Entity.File f = ImportFile(fileObject, spool.Id); CopyAttachment(tempDir, f); } } }
public IList <Pipe> GetPipesToExport() { try { // PipeTestResult result = null; // Inspector inspector = null; // Certificate certificate = null; // var q = session.QueryOver<Pipe>() // .Where(n => ((n.ToExport == true))) // .JoinAlias(r => r.PipeTestResult, () => result, JoinType.LeftOuterJoin) // .JoinAlias(() => result.Inspectors, () => inspector, JoinType.LeftOuterJoin) // .JoinAlias(() => inspector.Certificates, () => certificate, JoinType.LeftOuterJoin) // .TransformUsing(Transformers.DistinctRootEntity) // .List<Pipe>(); //return q; Plate plate = null; Heat heat = null; PlateManufacturer plateMan = null; PipeMillSizeType type = null; PipeTest tests = null; PipeTestResult result = null; Inspector inspector = null; Certificate certificate = null; Project proj = null; SeamType seam = null; Spool spool = null; File attach = null; var q = session.QueryOver <Pipe>() .Where(n => ((n.ToExport == true))) .JoinAlias(r => r.PipeTestResult, () => result, JoinType.LeftOuterJoin) .JoinAlias(() => result.Inspectors, () => inspector, JoinType.LeftOuterJoin) .JoinAlias(() => inspector.Certificates, () => certificate, JoinType.LeftOuterJoin) .JoinAlias(p => p.Plate, () => plate, JoinType.LeftOuterJoin) .JoinAlias(() => plate.Heat, () => heat, JoinType.LeftOuterJoin) .JoinAlias(() => heat.PlateManufacturer, () => plateMan, JoinType.LeftOuterJoin) .JoinAlias(t => t.Type, () => type, JoinType.LeftOuterJoin) .JoinAlias(() => type.SeamType, () => seam, JoinType.LeftOuterJoin) .JoinAlias(() => type.PipeTests, () => tests, JoinType.LeftOuterJoin) .JoinAlias(t => t.Spools, () => spool, JoinType.LeftOuterJoin) .JoinAlias(t => t.Attachments, () => attach, JoinType.LeftOuterJoin) .JoinAlias(t => t.Project, () => proj, JoinType.LeftOuterJoin) .Fetch(o => o.PurchaseOrder).Eager .Fetch(r => r.Railcar).Eager .TransformUsing(Transformers.DistinctRootEntity) .List <Pipe>(); return(q); } catch (GenericADOException ex) { throw new RepositoryException("GetPipesToExport", ex); } }
private Spool ImportSpool(string tempDir, SpoolObject so, Pipe pipe) { Spool spool = importRepo.SpoolRepo.Get(so.Id); bool isNew = false; if (spool == null) { spool = new Spool(); isNew = true; } MapSerializableEntityToSpool(tempDir, so, spool); spool.Pipe = pipe; if (isNew) { importRepo.SpoolRepo.Save(spool); } else { importRepo.SpoolRepo.SaveOrUpdate(spool); } return(spool); }
public SpoolObject(Spool spool) { this.Id = spool.Id; this.IsActive = spool.IsActive; this.PipeNumber = spool.PipeNumber; this.Number = spool.Number; this.Length = spool.Length; this.IsAvailableToJoint = spool.IsAvailableToJoint; this.ConstructionStatus = spool.ConstructionStatus; this.InspectionStatus = spool.InspectionStatus; }
void MapSerializableEntityToSpool(SpoolObject spoolObj, Spool spool) { spool.Id = spoolObj.Id; spool.IsActive = spoolObj.IsActive; spool.PipeNumber = spoolObj.PipeNumber; spool.Number = spoolObj.Number; spool.Length = spoolObj.Length; spool.IsAvailableToJoint = spoolObj.IsAvailableToJoint; spool.ConstructionStatus = spoolObj.ConstructionStatus; spool.InspectionStatus = spoolObj.InspectionStatus; }
public void RefreshList() { string Lib = IBMi.CurrentSystem.GetValue("printerLib"), Obj = IBMi.CurrentSystem.GetValue("printerObj"); Thread spoolThread = new Thread((ThreadStart) delegate { ListViewItem curItem; List <ListViewItem> Items = new List <ListViewItem>(); SpoolFile[] Listing = IBMiUtils.GetSpoolListing(Lib, Obj); if (Listing != null) { foreach (SpoolFile Spool in Listing) { curItem = new ListViewItem(new[] { Spool.getName(), Spool.getData(), Spool.getStatus(), Spool.getJob() }, 0); curItem.Tag = Spool; Items.Add(curItem); } } else { Items.Add(new ListViewItem("No spool files found.")); } if (spoolList != null) { this.Invoke((MethodInvoker) delegate { spoolList.Items.Clear(); spoolList.Items.AddRange(Items.ToArray()); }); } }); if (Lib == "" || Obj == "") { MessageBox.Show("You must setup the Output Queue in the Connection Settings for the spool file listing to work.", "Spool Listing", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { spoolThread.Start(); } }
public SpoolObject(Spool spool) { this.Id = spool.Id; this.IsActive = spool.IsActive; this.PipeNumber = spool.PipeNumber; this.Number = spool.Number; this.Length = spool.Length; this.IsAvailableToJoint = spool.IsAvailableToJoint; this.ConstructionStatus = spool.ConstructionStatus; this.InspectionStatus = spool.InspectionStatus; if (spool.Attachments != null) { this.Attachments = new List <FileObject>(); foreach (var file in spool.Attachments) { Attachments.Add(new FileObject(file)); } } }
public IList <TurbineBladeAndSpoolTypeInfoDto> GetTurbineBladeAndSpoolTypeInfoDtos() { using (ITransaction transaction = session.BeginTransaction()) { TurbineBladeAndSpoolTypeInfoDto result = new TurbineBladeAndSpoolTypeInfoDto(); TurbineBlade turbineBladeAlias = null; Spool spoolAlias = null; QueryOver <TurbineBlade> subquery = QueryOver.Of <TurbineBlade>().Where(tb => tb.MaterialType.IsLike("%tungsten%")).Select(tb => tb.Id); var results = new List <TurbineBladeAndSpoolTypeInfoDto>(); results = session.QueryOver <TurbineBlade>(() => turbineBladeAlias) .JoinQueryOver(() => turbineBladeAlias.ParentSpool, () => spoolAlias) .Where(() => spoolAlias.Id == turbineBladeAlias.ParentSpool.Id) .WithSubquery.WhereProperty(() => turbineBladeAlias.Id) .NotIn(subquery) .And( new OrExpression( new InsensitiveLikeExpression(Projections.Property(() => turbineBladeAlias.MaterialType), "%alloy%"), Restrictions.Gt(Projections.Property(() => turbineBladeAlias.MaxTemp), 1400))) .SelectList(list => list .Select(tb => tb.Id).WithAlias(() => result.TubineBladeID) .Select(() => turbineBladeAlias.ParentSpool.Id).WithAlias(() => result.ParentSpoolID) .Select(() => turbineBladeAlias.HasCoolingChannels).WithAlias(() => result.HasCoolingChannels) .Select(() => turbineBladeAlias.MaxTemp).WithAlias(() => result.MaxTemp) .Select(() => turbineBladeAlias.MaterialType).WithAlias(() => result.MaterialType) .Select(() => turbineBladeAlias.Length).WithAlias(() => result.Length) .Select(() => turbineBladeAlias.Chord).WithAlias(() => result.Chord)) .TransformUsing(Transformers.AliasToBean <TurbineBladeAndSpoolTypeInfoDto>()) .List <TurbineBladeAndSpoolTypeInfoDto>().ToList(); transaction.Commit(); return(results); } }
public void OnGUI() { EditorGUI.BeginChangeCheck(); targetSpool = (Spool)EditorGUILayout.ObjectField(targetSpool, typeof(Spool), false); if (EditorGUI.EndChangeCheck()) { myNodes.Clear(); if (targetSpool != null) { for (int i = 0; i < targetSpool.stitchCollection.Length; i++) { myNodes.Add(new StitchNode(new Rect(100 * i, 20, 100, 100), i)); } } } if (targetSpool != null) { for (int i = 0; i < targetSpool.stitchCollection.Length; i++) { for (int j = 0; j < targetSpool.stitchCollection[i].yarns.Length; j++) { if (targetSpool.stitchCollection[i].yarns[j].choiceStitch != null) { DrawNodeCurve(myNodes[i].rect, myNodes[targetSpool.stitchCollection[i].yarns[j].choiceStitch.stitchID].rect); } } } } BeginWindows(); for (int i = 0; i < myNodes.Count; i++) { myNodes[i].rect = GUI.Window(i, myNodes[i].rect, myNodes[i].DrawGUI, targetSpool.stitchCollection[i].stitchName); } EndWindows(); for (int i = 0; i < myNodes.Count; i++) { if (GUI.Button(new Rect(myNodes[i].rect.x + myNodes[i].rect.height - 70, myNodes[i].rect.yMax, 40, 20), "Edit")) { //Open Edit Window editorToggle = true; nodeSelected = i; } /*if (GUI.Button(new Rect(myNodes[i].rect.xMax - 10, myNodes[i].rect.y + myNodes[i].rect.height / 2, 20, 20), "+")) * { * BeginAttachment(i); * } * * if (GUI.Button(new Rect(myNodes[i].rect.xMin - 10, myNodes[i].rect.y + myNodes[i].rect.height / 2, 20, 20), "O")) * { * EndAttachment(i); * }*/ } if (editorToggle) { Rect editorWindow = new Rect(position.width - position.width / 3, 0, position.width / 3, position.height); EditorGUI.DrawRect(editorWindow, Color.black); } }
protected void FinishButton_Click(object sender, EventArgs e) { codigoControl = ""; lMsjDocumento.Text = ""; string obligadocontabilidad = ""; string guiaRemision; codigoControl = ""; if (String.IsNullOrEmpty(ddlSucursal.SelectedValue)) { ddlSucursal.Items.Clear(); ddlSucursal.DataBind(); } if (String.IsNullOrEmpty(ddlEmision.SelectedValue)) { ddlEmision.Items.Clear(); ddlEmision.DataBind(); } if (String.IsNullOrEmpty(ddlAmbiente.SelectedValue)) { ddlAmbiente.Items.Clear(); ddlAmbiente.DataBind(); } if (String.IsNullOrEmpty(ddlComprobante.SelectedValue)) { ddlComprobante.Items.Clear(); ddlComprobante.DataBind(); } if (String.IsNullOrEmpty(ddlPtoEmi.SelectedValue)) { ddlPtoEmi.Items.Clear(); ddlPtoEmi.DataBind(); } if (cbObligado.Checked) { obligadocontabilidad = "SI"; } else { obligadocontabilidad = "NO"; } try { spoolComprobante = new Spool(); spoolComprobante.xmlComprobante(); spoolComprobante.InformacionTributaria(ddlAmbiente.SelectedValue, ddlEmision.SelectedValue, tbRazonSocial.Text, tbNombreComercial.Text, tbRuc.Text, "", ddlComprobante.SelectedValue, ddlSucursal.SelectedValue, ddlPtoEmi.SelectedValue, "", tbDirMatriz.Text, tbEmail.Text); spoolComprobante.infromacionDocumento(tbFechaEmision.Text, tbDirEstablecimiento.Text, tbContribuyenteEspecial.Text, obligadocontabilidad, ddlTipoIdentificacion.SelectedValue, "", tbRazonSocialComprador.Text, tbIdentificacionComprador.Text, tbMoneda.Text, "", "", "", "", "", "", "", "", "", "", "", formatCero, ""); spoolComprobante.cantidades(tbSubtotal12.Text, tbSubtotal0.Text, tbSubtotalNoSujeto.Text, tbTotalSinImpuestos.Text, tbTotalDescuento.Text, tbICE.Text, tbIVA12.Text, tbImporteTotal.Text, tbPropinas.Text, tbImporteaPagar.Text); spoolComprobante.totalImpuestos(idUser); spoolComprobante.detalles(idUser); spoolComprobante.impuestos(idUser); spoolComprobante.detallesAdicionales(idUser); spoolComprobante.informacionAdicional(idUser); codigoControl = spoolComprobante.generarDocumento(); if (!String.IsNullOrEmpty(codigoControl)) { Session["codigoControl"] = codigoControl; Response.Redirect("~/Procesando.aspx"); } else { lMsjDocumento.Text = "No se pudo crear el Comprobante."; } } catch (Exception ex) { msj = log.PA_mensajes("EM011")[0]; lMsjDocumento.Text = msj; log.mensajesLog("EM011", "", ex.Message, "Crear Factura", ""); } }
//protected void FinishButton_Click_Client(object sender, WizardNavigationEventArgs e) //{ // switch (Wizard1.ActiveStepIndex) // { // case 2: // Page.Validate("Receptor"); // if (!Page.IsValid) // { // e.Cancel = true; // } // break; // default: // break; // } //} protected void FinishButton_Click(object sender, EventArgs e) { Wizard1.Enabled = false; //if (ddlMetodoPago.SelectedValue !="Selecciona una opción") //{ // if (tbFechaV.Text.Length > 0) // { codigoControl = ""; lMsjDocumento.Text = ""; string obligadocontabilidad = ""; string guiaRemision; codigoControl = ""; if (String.IsNullOrEmpty(ddlSucursal.SelectedValue)) { ddlSucursal.Items.Clear(); ddlSucursal.DataBind(); } if (String.IsNullOrEmpty(ddlEmision.SelectedValue)) { ddlEmision.Items.Clear(); ddlEmision.DataBind(); } if (String.IsNullOrEmpty(ddlAmbiente.SelectedValue)) { ddlAmbiente.Items.Clear(); ddlAmbiente.DataBind(); } if (String.IsNullOrEmpty(ddlComprobante.SelectedValue)) { ddlComprobante.Items.Clear(); ddlComprobante.DataBind(); } if (String.IsNullOrEmpty(ddlPtoEmi.SelectedValue)) { ddlPtoEmi.Items.Clear(); ddlPtoEmi.DataBind(); } if (cbObligado.Checked) { obligadocontabilidad = "SI"; } else { obligadocontabilidad = "NO"; } try { obligadocontabilidad = "SI"; string auxtipovemta = ""; //if (tbIdentificacionComprador.Text.Length == 13) //{auxtipovemta = "04"; } spoolComprobante = new Spool(); spoolComprobante.xmlComprobante(); spoolComprobante.InformacionTributaria(ddlAmbiente.SelectedValue, ddlEmision.SelectedValue, tbRazonSocial.Text, tbNombreComercial.Text, tbRuc.Text, "", ddlComprobante.SelectedValue, "001", "001", tbFolio.Text, tbDirMatriz.Text, tbEmail.Text); spoolComprobante.infromacionDocumento(tbFechaEmision.Text, tbDirEstablecimiento.Text, "", obligadocontabilidad, ddlTipoIdentificacion.SelectedValue, "", tbRazonSocialComprador.Text, tbIdentificacionComprador.Text, tbMoneda.Text, "", "", "", "", "", "", "", "", "", "", "", formatCero, ""); spoolComprobante.cantidades(tbSubtotal12.Text, tbSubtotal0.Text, tbSubtotalNoSujeto.Text, tbTotalSinImpuestos.Text, tbTotalDescuento.Text, tbICE.Text, tbIVA12.Text, tbImporteTotal.Text, tbPropinas.Text, tbImporteaPagar.Text); spoolComprobante.totalImpuestos(idUser); spoolComprobante.detalles(idUser); spoolComprobante.impuestos(idUser); spoolComprobante.detallesAdicionales(idUser); spoolComprobante.informacionAdicional(idUser); consultaEmp(Session["idUser"].ToString()); //INFO ADICONAL spoolComprobante.infoSatcom(txt_dir_cli.Text, txt_fono.Text, tbObservaciones.Text, ddlMetodoPago.SelectedValue, tbMonto.Text, tbEmail.Text); codigoControl = spoolComprobante.generarDocumento(); if (!String.IsNullOrEmpty(codigoControl)) { registroSecuencial(ddlComprobante.SelectedValue, ddlSucursal.SelectedValue, ddlPtoEmi.SelectedValue, tbFolio.Text); Session["codigoControl"] = codigoControl; //Response.Redirect("~/Procesando.aspx"); Response.Redirect("~/Procesando.aspx", false); } else { lMsjDocumento.Text = "No se pudo crear el Comprobante."; } } catch (Exception ex) { msj = log.PA_mensajes("EM011")[0]; lMsjDocumento.Text = msj; log.mensajesLog("EM011", "", ex.Message, "Crear Factura", ""); } // } // else { lMsjDocumento.Text = "Debes seleccionar fecha de pago"; } //} //else { lMsjDocumento.Text = "Debes seleccionar método de pago"; } }
//[STAThread] static void Main() { //Thread t = new Thread(new ThreadStart(StartNewStaThread)); //t.Start(); Logger log = Logger.GetLogger(); AviationAdministration FAA = AviationAdministration.GetInstance(); NTSB NTSB = new NTSB(); #region Side tasks (testing things) //JetEngine jet1 = new JetEngine(600, 500, 5, new List<Propellants> { Propellants.Jet_A }, // new List<Oxidisers> { Oxidisers.GOX }, "Rolls-Royce", "RB-201", "100000008", 27000, 12, "88", 0, OnOff.Stopped); //JetEngine jet2 = new JetEngine(600, 500, 5, new List<Propellants> { Propellants.Jet_A }, // new List<Oxidisers> { Oxidisers.GOX }, "Rolls-Royce", "RB-201", "888888888", 27000, 12, "88", 0, OnOff.Running); //var compartments = new List<GasCompartment> //{ // new GasCompartment(20, 15), // new GasCompartment(20, 10), // new GasCompartment(20, 15), // new GasCompartment(15, 10) //}; //LighterThanAirAircraft baloon = new LighterThanAirAircraft(new SafeGasPumpManager(), 300, "He", compartments, // new List<Engine> { jet1, jet2 }, 100, "baloon Inc.", "Model-baloon", 700, 40, "88"); //Console.WriteLine(baloon); //////Console.WriteLine("\n\nComparing gas compartments:"); //baloon.ShiftGas(5,65,5); //Console.WriteLine("\n shifting gas"); //try //{ // baloon.ShiftGas(0, 1, 14.5f); // //baloon.ShiftGas(0, 0, 4.5f); // //baloon.ShiftGas(0, 4, -4.5f); //} //catch (GasCompartmentsNotFoundException e) when (e.OriginCompartment == e.DestinationCompartment) //{ // Console.WriteLine($"\n{e.Message}.\n", e.Message); //} //catch (GasCompartmentsNotFoundException e) //{ // Console.WriteLine($"\n{e.Message} (origin: {e.OriginCompartment}, destination: {e.DestinationCompartment}).\n"); //} //catch (Exception e) //{ // Console.WriteLine(e.Message); // Debug.WriteLine(e.Message); //} //finally //{ // Console.WriteLine("An attempt was made to shift lifting gas\n"); //} //Console.WriteLine(baloon); //Console.WriteLine(); //Console.WriteLine("Attemting to stop an engine"); //try //{ // baloon.StopEngine(baloon.Engines[0]); //} //catch (Exception e) //{ // Console.WriteLine(e.Message); // Console.WriteLine(e.InnerException?.Message ?? "no inner exception"); //} #endregion String[] ox = Enum.GetNames(typeof(OxidisersEnum)); foreach (var s in ox) { Console.WriteLine(s); } ServiceLocator.RegisterAll(); HeavierThanAirAircraftFactory factory = ServiceLocator.Get <HeavierThanAirAircraftFactory>(); #region factories and cultures //RotorCraft rotorCraft = factory.TryMakeRotorCraft("00000000", new List<RotorBlade>(), "standart TEST rotor", // 42, 73, "TEST manufacturer", 4242); ////Console.WriteLine(rotorCraft); //FAA.RegisterAircraft(new List<AircraftRegistration> // { // new AircraftRegistration(rotorCraft, true), // new AircraftRegistration(rotorCraft, false) //}); #region //Thread t = new Thread(new ThreadStart(StartNewStaThread)); //t.Start(); //Thread.Sleep(4000); //Console.WriteLine("\n\n\n"); //RotorCraft rotorCraft2 = factory.TryMakeRotorCraft("000000002", new List<RotorBlade>(), // "standart TEST rotor2", // 42, 73, "TEST manufacturer2", 4242); //Console.WriteLine(rotorCraft2); //log.ExportToFile(); //log.FileName = "NumberTWO"; //log.ExportToFile(); //log.AddToLog(log.FindInLog("000000002").ToString()); //log.AddToLogWithOffset("Testing the offset method"); //log.AddToLog("sdasdsadsadad"); //Thread.Sleep(2000); //Console.WriteLine(log.CalculatePostTimeDifference()); //switch (Console.ReadLine().ToUpper()) //{ // case "US": // Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); // break; // case "UK": // Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB"); // break; // default: // Console.WriteLine("wrong answer)"); // break; //} //switch (Thread.CurrentThread.CurrentCulture.ToString()) //{ // case "en-US": // Console.WriteLine("honor, behavior..."); // Console.WriteLine(TimeZone.CurrentTimeZone.StandardName); // break; // case "en-GB": // Console.WriteLine("colour, monetisation..."); // Console.WriteLine(TimeZone.CurrentTimeZone.StandardName); // break; //} #endregion #endregion #region Decorator //var turbineEngineFactory = TurbineEngineFactory.GeTurbineEngineFactory(); //var turboFan = new Turbofan(); //if (turbineEngineFactory.TryMakeTurbofan(4, 3, new Generator(), // new List<Spool>(), 600, 500, 5, new List<Propellants> { Propellants.Jet_A }, // new List<Oxidisers> { Oxidisers.GOX }, "Rolls-Royce", "RB-201", "100000008", 27000, 88, 0, OnOff.Stopped, // out turboFan)) //{ // Console.WriteLine(); // Console.WriteLine(turboFan); //} //else //{ // Console.WriteLine(); // Console.WriteLine("No engine could be created"); //} //ReheatDecorator engineDecorator = new ReheatDecorator(turboFan); //engineDecorator.Decorate(new ReheatChamber(1.5)); //engineDecorator.Reheat.Engage(); //Console.WriteLine("\n\n\n\n"); //Console.WriteLine(engineDecorator); //DumpAndBurnDecorator decorator2 = new DumpAndBurnDecorator(engineDecorator); //decorator2.Decorate(new FuelDumper(2)); //decorator2.DumpandBurn.Engage(); //Console.WriteLine("\n\n\n\n"); //Console.WriteLine(decorator2); //#endregion //#region Proxy //Console.WriteLine("\n\n\n\n"); //LighterThanAirAircraftProxy proxy = new LighterThanAirAircraftProxy(300); //Stopwatch performanceStopwatch = new Stopwatch(); //performanceStopwatch.Start(); //proxy.DumpBallast(100); //performanceStopwatch.Stop(); //Console.WriteLine("Ballast dumping took aprox. {0} ticks", performanceStopwatch.ElapsedTicks); //Console.WriteLine("\n\n"); //performanceStopwatch.Restart(); //proxy.ShiftGas(0, 1, 50); //performanceStopwatch.Start(); //Console.WriteLine("Creating a new object and shifting gas took aprox {0} ticks", performanceStopwatch.ElapsedTicks); #endregion //rotorCraft.IsOperational = false; //Console.WriteLine(rotorCraft); NHibernateProfiler.Initialize(); //aircraft registry var aircraftRegistryRepository = ServiceLocator.Get <IAircraftRegistryRepository>(); aircraftRegistryRepository.Save(new AircraftRegistry("VH-HYR", false, new DateTime(1996, 10, 10), "622")); //gas compartment var gasCompartmentRepository = ServiceLocator.Get <IGasCompartmentRepository>(); gasCompartmentRepository.Save(new GasCompartment(4000, 3800)); //generator var generatorRepository = ServiceLocator.Get <IGeneratorRepository>(); generatorRepository.Save(new Generator(42, 73)); //wing var wingRepository = ServiceLocator.Get <IWingRepository>(); wingRepository.Save(new Wing(42, 73)); ////VariableGeometryWing var VGWRepository = ServiceLocator.Get <IVariableGeometryWingRepository>(); VGWRepository.Save(new VariableGeometryWing(42, 73, 42, 73)); //aircraft var aircraftRepository = ServiceLocator.Get <IAircraftRepository>(); //it's an abstarct class //powered aircraft var poweredAircraftRepository = ServiceLocator.Get <IPoweredAircraftRepository>(); poweredAircraftRepository.Save(new PoweredAircraft(null, 42, "42", "73", 42, 73, "622")); poweredAircraftRepository.Save(new PoweredAircraft(null, 42, "42", "73", 42, 73, "888")); //lighter than air aircraft var lighterThanAirAircraftRepository = ServiceLocator.Get <ILighterThanAirAircraftRepository>(); lighterThanAirAircraftRepository.Save(new LighterThanAirAircraft(null, 42, "He", new List <GasCompartment>(), new List <Engine>(), 73, "42", "73", 42, 73, "741")); //heavier than air aircraft var heavierThanAirAircraftRepository = ServiceLocator.Get <IHeavierThanAirAircraftRepository>(); heavierThanAirAircraftRepository.Save(new HeavierThanAirAircraft(new List <Engine>(), 42, "42", "73", 42, 73, "2849")); //fixed wing aircraft var fixedWingAricraftRepository = ServiceLocator.Get <IFixedWingAircraftRepository>(); fixedWingAricraftRepository.Save(new FixedWingAircraft(new List <Wing>(), 42, 73, new List <Engine>(), 42, "42", "73", 42, 73, "666")); //rotorcraft var rotorcraftRepository = ServiceLocator.Get <IRotorCraftRepository>(); rotorcraftRepository.Save(new RotorCraft(42, new List <RotorBlade>(), "73", new List <Engine>(), 42, "42", "73", 42, 73, "19000130")); //propellant var propellantRepository = ServiceLocator.Get <IPropellantRepository>(); propellantRepository.Save(new Propellant(PropellantsEnum.MonoMethylHydrazine)); //oxidiser var oxidiserRepository = ServiceLocator.Get <IOxidiserRepository>(); oxidiserRepository.Save(new Oxidiser(OxidisersEnum.DinitrogenTetroxide)); //blade var bladeRepository = ServiceLocator.Get <IBladeRepository>(); //it's an abstract class //turbine blade var turbineBladeRepository = ServiceLocator.Get <ITurbineBladeRepository>(); turbineBladeRepository.Save(new TurbineBlade(1000, true, 18, 12, "High temp alloy")); //rotor blade var rotorBladeRepository = ServiceLocator.Get <IRotorBladeRepository>(); rotorBladeRepository.Save(new RotorBlade(true, 42, 73, "42")); //spool var spoolRepository = ServiceLocator.Get <ISpoolRepository>(); spoolRepository.Save(new Spool(new List <TurbineBlade>(), "42")); //engine var engineRepository = ServiceLocator.Get <IEngineRepository>(); //it's an abstract class //piston engine var pistonEngineRepository = ServiceLocator.Get <IPistonEngineRepository>(); pistonEngineRepository.Save(new PistonEngine(42, 73, "42", "73", "42", 73, 42, null, 73, OnOff.Stopped)); //jet engine var jetEngineRepository = ServiceLocator.Get <IJetEngineRepository>(); jetEngineRepository.Save(new JetEngine(42, 73, 42, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //rocket engine var rocketEngineRepository = ServiceLocator.Get <IRocketEngineRepository>(); rocketEngineRepository.Save(new RocketEngine(true, "42", 42, 73, 42, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //solid fuel rocket engine var solidFuelRocketEngineRepository = ServiceLocator.Get <ISolidFuelRocketEngineRepository>(); solidFuelRocketEngineRepository.Save(new SolidFuelRocketEngine(true, "42", 42, 73, 42, null, null, "42", "73", "42", 73, 42, null, 73, OnOff.Stopped)); //turbine engine var turbineEngineRepository = ServiceLocator.Get <ITurbineEngineRepository>(); turbineEngineRepository.Save(new TurbineEngine(true, 42, null, null, 42, 73, 42, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //ramjet var ramjetRepository = ServiceLocator.Get <IRamjetRepository>(); ramjetRepository.Save(new Ramjet(true, 42, 73, 42, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //turbofan var turbofanRepository = ServiceLocator.Get <ITurbofanRepository>(); turbofanRepository.Save(new Turbofan(42, true, true, 42, null, null, 73, 42, 73, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //turboshaft var turboshaftRepository = ServiceLocator.Get <ITurboshaftRepository>(); turboshaftRepository.Save(new Turboshaft(42, 73, true, 42, null, null, 73, 42, 73, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); //turbojet var turbojetRepository = ServiceLocator.Get <ITurbojetRepository>(); turbojetRepository.Save(new Turbojet(true, 42, null, null, 73, 42, 73, null, null, "42", "73", "42", 73, 42, null, 42, OnOff.Stopped)); ////testing double session use //var testSpool = turbojetRepository.LoadEntity<Spool>(159159); //var testTurbojet = turbojetRepository.LoadEntity<Turbojet>(120128); //testSpool.ParentEngine = testTurbojet; //testTurbojet.Spools.Add(testSpool); //turbojetRepository.Save(testTurbojet); ////turbojetRepository.Delete(testTurbojet); List <Spool> spools = new List <Spool>(); spools.Add(new Spool(null, "Fan")); spools.Add(new Spool(null, "IP spool")); spools.Add(new Spool(null, "LP spool")); spools.Add(new Spool(null, "HP spool")); List <TurbineBlade> blades = new List <TurbineBlade>(); for (int i = 0; i < 10; i++) { TurbineBlade tb = new TurbineBlade(1500, true, 12, 8, "Ti"); blades.Add(tb); blades.Add(new TurbineBlade(1000, false, 18, 12, "High temp alloy")); blades.Add(new TurbineBlade(1350, true, 12, 8, "Ceramic plated alloy")); blades.Add(new TurbineBlade(1275, false, 12, 8, "W (tungsten) alloy")); } spools[0] = new Spool(blades.Where(x => x.MaterialType == "High temp alloy").ToList(), spools[0].Type); spools[1] = new Spool(blades.Where(x => x.MaterialType == "W (tungsten) alloy").ToList(), spools[1].Type); spools[2] = new Spool(blades.Where(x => x.MaterialType == "Ceramic plated alloy").ToList(), spools[2].Type); spools[3] = new Spool(blades.Where(x => x.MaterialType == "Ti").ToList(), spools[3].Type); foreach (var spool in spools) { foreach (var turbineBlade in spool.Blades) { turbineBlade.ParentSpool = spool; } } foreach (var spool in spools) { spoolRepository.Save(spool); } foreach (var turbineBlade in blades) { turbineBladeRepository.Save(turbineBlade); } for (int i = 200; i < 1000; i += 50) { gasCompartmentRepository.Save(new GasCompartment(i, (float)(i - (i * 0.5)))); } aircraftRegistryRepository.Save(new AircraftRegistry("ER-AXV", false, new DateTime(2003, 9, 22), "622")); aircraftRegistryRepository.Save(new AircraftRegistry("N452TA", false, new DateTime(1997, 11, 28), "741")); aircraftRegistryRepository.Save(new AircraftRegistry("ER-AXP", false, new DateTime(2011, 11, 3), "741")); aircraftRegistryRepository.Save(new AircraftRegistry("B-6156", false, new DateTime(2006, 8, 3), "2849")); aircraftRegistryRepository.Save(new AircraftRegistry("ER-AXL", false, new DateTime(2015, 6, 5), "2849")); aircraftRegistryRepository.Save(new AircraftRegistry("D-ASSY", false, new DateTime(1997, 3, 26), "666")); aircraftRegistryRepository.Save(new AircraftRegistry("SX-BHT", false, new DateTime(2014, 5, 31), "666")); aircraftRegistryRepository.Save(new AircraftRegistry("F-OSUD", false, new DateTime(2007, 12, 4), "19000130")); aircraftRegistryRepository.Save(new AircraftRegistry("ER-ECC", false, new DateTime(2013, 3, 29), "19000130")); Console.WriteLine("\nselecting all turbineblades not made out of W, but are an alloy or can withstand temperatures in excess of 1400 C"); //SQLQuery2 //selecting all turbineblades not made out of W, but are an alloy or can withstand temperatures in excess of 1400 C IList <TurbineBladeAndSpoolTypeInfoDto> results2 = turbineBladeRepository.GetTurbineBladeAndSpoolTypeInfoDtos(); foreach (var turbineBladeAndSpoolTypeInfoDto in results2) { Console.WriteLine($"SerialNumber: {turbineBladeAndSpoolTypeInfoDto.TubineBladeID}, Material type: {turbineBladeAndSpoolTypeInfoDto.MaterialType}, Max. temp.:{turbineBladeAndSpoolTypeInfoDto.MaxTemp}"); } Console.WriteLine("\ngets the number of compartments whose capacity is greater than 300 units of volume and their actual capacity "); //SQLQuery3 //gets the number of compartments whose capacity is greater than 300 units of volume and their actual capacity List <GasCompatrmentsCountAndCapacityDto> results3_1 = gasCompartmentRepository.GetCompartmetnsCountWithLowerCapacityThan(300); foreach (var gasCompatrmentsCountAndCapacityDto in results3_1) { Console.WriteLine($"Capacity: {gasCompatrmentsCountAndCapacityDto.Capacity}, Count: {gasCompatrmentsCountAndCapacityDto.Count}"); } Console.WriteLine("\nreturns the number of blades that have cooling channels and the number that don't"); //SQLQuery3 //returns the number of blades that have cooling channels and the number that don't List <TurbineBladeCountDifferentiateOnCoolingChannelsDto> results3_2 = turbineBladeRepository.GetNumberOfBladesWithOrWitjoutCooling(); foreach (var turbineBladeCountDifferentiateOnCoolingChannelsDto in results3_2) { Console.WriteLine($"Count: {turbineBladeCountDifferentiateOnCoolingChannelsDto.Count}, HasCoolingChannels: {turbineBladeCountDifferentiateOnCoolingChannelsDto.HasCoolingChannels}"); } Console.WriteLine("\ngets all the aircraft info and the number of times it was registered in the registry"); //SQLQuery4 //gets all the aircraft info and the number of times it was registered in the registry List <AicraftInfoAndNumberOfTimesRegisteredDto> results4_1 = aircraftRegistryRepository.GetAicraftInfoAndNumberOfTimesRegistered(); foreach (var aicraftInfoAndNumberOfTimesRegisteredDto in results4_1) { Console.WriteLine($"Serial number: {aicraftInfoAndNumberOfTimesRegisteredDto.SerialNumber}, NumberOfTimesRegistered: {aicraftInfoAndNumberOfTimesRegisteredDto.Count}"); } Console.WriteLine("\ngets all aircraft,that have been reregistered more than a year ago"); //SQLQuery4 //gets all aircraft,that have been reregistered more than a year ago List <AicraftInfoAndDateOfRegistrationDto> results4_2 = aircraftRegistryRepository.GetAicraftInfoAndDateOfPenultimateRegistrationDtos(1); foreach (var aicraftInfoAndDateOfRegistrationDto in results4_2) { Console.WriteLine($"Serial number: {aicraftInfoAndDateOfRegistrationDto.SerialNumber}, penultimate registration date: {aicraftInfoAndDateOfRegistrationDto.RegistryDate.Date}"); } Console.WriteLine("\nreturns gas compartments' IDs whose volume is greater than the average volume"); //SQLQuery4 //returns gas compartments' IDs whose volume is greater than the average volume List <long> result4_3 = gasCompartmentRepository.GetCompartmentsWithLessThanDoubleTheAverageVolume(); foreach (var l in result4_3) { Console.WriteLine($"CompartmentID: {l}"); } Console.WriteLine("\ngets turbine blades IDs whose max temp is either the overall maximum or the overall average"); //SQLQuery4 //gets turbine blade IDs whose max temp is either the overall maximum or the overall average List <long> results4_4 = turbineBladeRepository.GetTubineBladesWithMaxTempInAVGorMAX(); foreach (var l in results4_4) { Console.WriteLine($"Turbine blade ID: {l}"); } Console.WriteLine("\nreturns all aircraft whose latest regsitration is more that 5 years old"); //SQLQuery4 //returns all aircraft whose latest regsitration is more that 5 years old List <AicraftInfoAndDateOfRegistrationDto> results4_5 = aircraftRegistryRepository.GetAicraftInfoAndLastDateOfRegistrationDtos(5); foreach (var aicraftInfoAndDateOfRegistrationDto in results4_5) { Console.WriteLine($"Serial number: {aicraftInfoAndDateOfRegistrationDto.SerialNumber}, Registration date: {aicraftInfoAndDateOfRegistrationDto.RegistryDate.Date}"); } Console.WriteLine("\nGets info about aircraft and whether it was registered"); //SQLQuery4 //Gets info about aircraft and whether it was registered List <AicraftInfoAndIfRegisteredBoolDto> results4_6 = aircraftRegistryRepository.GetAicraftInfoAndIfRegisteredBoolDto(); foreach (var aicraftInfoAndIfRegisteredBoolDto in results4_6) { Console.WriteLine($"SerialNumber: {aicraftInfoAndIfRegisteredBoolDto.SerialNumber}, is registered: {aicraftInfoAndIfRegisteredBoolDto.IsRegistered}"); } Console.WriteLine("\nreturns aircraft, that have been registred in two scpecified years"); //SQLQuery4 //returns aircraft, that have been registred in two scpecified years List <string> results4_7 = aircraftRegistryRepository.GetAircraftRegisteredInTwoSpecificYears(2003, 1996); foreach (var VARIABLE in results4_7) { Console.WriteLine($"Serial number: {VARIABLE}"); } log.Dispose(); }
//protected void FinishButton_Click_Client(object sender, WizardNavigationEventArgs e) //{ // switch (Wizard1.ActiveStepIndex) // { // case 2: // Page.Validate("Receptor"); // if (!Page.IsValid) // { // e.Cancel = true; // } // break; // default: // break; // } //} protected void FinishButton_Click(object sender, EventArgs e) { codigoControl = ""; lMsjDocumento.Text = ""; string obligadocontabilidad = ""; string guiaRemision; string datos = ""; string respuesta = ""; string ptoEmi = ""; string claveSucursal = ""; ClaveAcceso = ""; NoAutorizacion = ""; FechaAutorizacion = ""; Estado = ""; Ambiente = ""; Emision = ""; MensajeT = ""; Numero = ""; Codigo = ""; Mensaje = ""; IA = ""; XmlDocument xmlRespuesta = new XmlDocument(); codigoControl = ""; if (String.IsNullOrEmpty(ddlSucursal.SelectedValue)) { ddlSucursal.Items.Clear(); ddlSucursal.DataBind(); } if (String.IsNullOrEmpty(ddlEmision.SelectedValue)) { ddlEmision.Items.Clear(); ddlEmision.DataBind(); } if (String.IsNullOrEmpty(ddlAmbiente.SelectedValue)) { ddlAmbiente.Items.Clear(); ddlAmbiente.DataBind(); } if (String.IsNullOrEmpty(ddlComprobante.SelectedValue)) { ddlComprobante.Items.Clear(); ddlComprobante.DataBind(); } if (String.IsNullOrEmpty(ddlPtoEmi.SelectedValue)) { ddlPtoEmi.Items.Clear(); ddlPtoEmi.DataBind(); ptoEmi = ddlPtoEmi.SelectedValue; } if (Session["estab"] != null) { claveSucursal = Session["estab"].ToString(); } if (Session["ptoemi"] != null) { ptoEmi = Session["ptoemi"].ToString(); } if (cbObligado.Checked) { obligadocontabilidad = "SI"; } else { obligadocontabilidad = "NO"; } try { tbSecuencial.Text = obtenerSecuencial(claveSucursal, ptoEmi, ddlComprobante.SelectedValue); spoolComprobante = new Spool(); spoolComprobante.xmlComprobante(); spoolComprobante.InformacionTributaria(ddlAmbiente.SelectedValue, ddlEmision.SelectedValue, tbRazonSocial.Text, tbNombreComercial.Text, tbRuc.Text, "", ddlComprobante.SelectedValue, claveSucursal, ptoEmi, tbSecuencial.Text, tbDirMatriz.Text, tbEmail.Text); spoolComprobante.infromacionDocumento(tbFechaEmision.Text, tbDirEstablecimiento.Text, tbContribuyenteEspecial.Text, obligadocontabilidad, ddlTipoIdentificacion.SelectedValue, "", tbRazonSocialComprador.Text, tbIdentificacionComprador.Text, tbMoneda.Text, "", "", "", "", "", "", "", "", "", "", "", formatCero, ""); spoolComprobante.cantidades(tbSubtotal12.Text, tbSubtotal0.Text, tbSubtotalNoSujeto.Text, tbTotalSinImpuestos.Text, tbTotalDescuento.Text, tbICE.Text, tbIVA12.Text, tbImporteTotal.Text, tbPropinas.Text, tbImporteaPagar.Text); spoolComprobante.datosHerbalife(System.DateTime.Now.ToString("yyyyMMddHHmmss"), "1900-01-01T00:00:00", "0.0", "", "", "", "", "0.0", "", "", "", "", "", "", "", "E3", "", "", "", ""); spoolComprobante.totalImpuestos(idUser); spoolComprobante.detalles(idUser); spoolComprobante.impuestos(idUser); spoolComprobante.detallesAdicionales(idUser); spoolComprobante.informacionAdicional(idUser); //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // wsGenerarDoc.wsGenerarDocSoapClient crearDocManual = new wsGenerarDoc.wsGenerarDocSoapClient(); XdService.XdServicePruebasSoapClient crearDocManual = new XdService.XdServicePruebasSoapClient(); //wsGenerarDocSSL.wsGenerarDocSoapClient crearDocManual = new wsGenerarDocSSL.wsGenerarDocSoapClient(); txt = spoolComprobante.generarDocumento(); codigoControl = spoolComprobante.codigoControl; DB.Conectar(); DB.CrearComando(@"insert into Log_Trama (Trama,fecha) values (@Trama,@fecha)"); DB.AsignarParametroCadena("@Trama", "FM ---" + txt.Replace("'", "")); DB.AsignarParametroCadena("@fecha", System.DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss")); DB.EjecutarConsulta1(); DB.Desconectar(); //crearDocManual = new wsGenerarDoc.wsGenerarDocSoapClient(); crearDocManual = new XdService.XdServicePruebasSoapClient(); //encData_byte = new byte[txt.Length]; //encData_byte = System.Text.Encoding.UTF8.GetBytes(txt); xmlRespuesta.LoadXml(crearDocManual.recibeInfoTXT(txt, tbRuc.Text).ToString()); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ClaveAcceso = xmlRespuesta.GetElementsByTagName("claveAcceso")[0].InnerText; NoAutorizacion = xmlRespuesta.GetElementsByTagName("numeroAutorizacion")[0].InnerText; FechaAutorizacion = xmlRespuesta.GetElementsByTagName("fechaAutorizacion")[0].InnerText; Estado = xmlRespuesta.GetElementsByTagName("estado")[0].InnerText; Mensaje = xmlRespuesta.GetElementsByTagName("msj")[0].InnerText; MensajeT = xmlRespuesta.GetElementsByTagName("msjT")[0].InnerText; Codigo = xmlRespuesta.GetElementsByTagName("codigo")[0].InnerText; if (!Estado.Equals("N0") && !String.IsNullOrEmpty(Estado)) { DB.Conectar(); DB.CrearComando(@"delete from Dat_detallesTemp where id_Empleado=@id_Empleado"); DB.AsignarParametroCadena("@id_Empleado", idUser); DB.EjecutarConsulta1(); DB.Desconectar(); DB.Conectar(); DB.CrearComando(@"delete from Dat_ImpuestosDetallesTemp where id_Empleado=@id_Empleado"); DB.AsignarParametroCadena("@id_Empleado", idUser); DB.EjecutarConsulta1(); DB.Desconectar(); Response.Redirect("~/Documentos.aspx", false); //Response.Redirect("~/Procesando.aspx", false); } else { lMsjDocumento.Text = "No se pudo crear el Comprobante." + "<br>"; lMsjDocumento.Text += "ClaveAcceso:" + ClaveAcceso + "<br>"; lMsjDocumento.Text += "Número: " + Numero + "<br>"; lMsjDocumento.Text += "Mensaje: " + Mensaje + "<br>"; lMsjDocumento.Text += "IA: " + MensajeT + "<br>"; } } catch (Exception ex) { msj = log.PA_mensajes("EM011")[0]; lMsjDocumento.Text = msj; lMsjDocumento.Text = ex.ToString(); log.mensajesLog("EM011", "", ex.Message, "0", "01"); } }
private void InitializeSpools() { try { FileLogger.Info(Logger, "Spool configurati: " + Cfg.Spools.Count); foreach (var spool in Cfg.Spools) { var mySpool = new Spool(spool.Id); FileLogger.Info(Logger, "Configurazione Spool: " + mySpool.Id); // Inizializzo i timers dello spool FileLogger.Info(Logger, "Timers configurati: " + spool.Timers.Count); foreach (var timer in spool.Timers) { FileLogger.Debug(Logger, String.Format("Configurazione timer: {0} - {1}", timer.Id, timer.Type)); //Timer di riferimento var tw = new TimerWork(timer.Type) { Id = timer.Id, Duetime = timer.DueTime, Period = timer.Period, BeginTime = timer.BeginTime, EndTime = timer.EndTime }; var configuredModules = Cfg.Modules.Where(module => module.Spool == spool.Id && module.Timer == timer.Id && module.Enabled).ToList(); if (configuredModules.Count <= 0) { continue; } var timerModules = configuredModules.Select(configuredModule => Modules[configuredModule.Id]).ToList(); // Inizializzo tutti i moduli del timer foreach (var jeepThreadedModule in timerModules) { jeepThreadedModule.Timer = tw; JeepModules[jeepThreadedModule].Start(); } } FileLogger.Debug(Logger, "Spool configurato correttamente: " + mySpool.Id); Spools.Add(mySpool.Id, mySpool); } foreach (var s in Spools.Values) { FileLogger.Debug(Logger, "Spool configurato: " + s.Id); foreach (var timer in s.Timers.Values) { FileLogger.Debug(Logger, "TimerWork configurato: " + timer); } } if (Spools.Count != 0) { return; } // Nessun modulo caricato FileLogger.Error(Logger, "Nessun modulo caricato"); // Fermo il servizio Stop(); } catch (Exception exc) { FileLogger.Error(Logger, "Errore in configurazione Spools", exc); Stop(); } }
private PartData ImportPartData(PartDataObject partDataObj, Data data, string tempDir, Joint joint) { if (partDataObj == null) { return(null); } PartType type = partDataObj.PartType; Guid partId = partDataObj.Id; switch (type) { case PartType.Pipe: Pipe pipe = importRepo.PipeRepo.Get(partId); bool newPipe = false; if (pipe == null) { PipeObject pipeObj = FindPipeById(data, partId); if (pipeObj != null) { pipe = new Pipe(); MapSerializableEntityToPipe(tempDir, pipeObj, pipe); newPipe = true; } } if (pipe != null) { if (newPipe) { importRepo.PipeRepo.Save(pipe); } else { importRepo.PipeRepo.SaveOrUpdate(pipe); } } break; case PartType.Spool: Spool spool = importRepo.SpoolRepo.Get(partId); bool isNewSpool = false; if (spool == null) { SpoolObject spoolObj = FindSpoolById(data, partId); if (spoolObj != null) { spool = new Spool(); MapSerializableEntityToSpool(tempDir, spoolObj, spool); isNewSpool = true; } } if (spool != null) { if (isNewSpool) { importRepo.SpoolRepo.Save(spool); } else { importRepo.SpoolRepo.SaveOrUpdate(spool); } } break; case PartType.Component: Component component = importRepo.ComponentRepo.Get(partId); bool isNewComponent = false; if (component == null) { ComponentObject compObj = FindComponentById(data, partId); if (compObj != null) { component = new Component(); MapSerializableEntityToComponent(tempDir, compObj, component, joint); isNewComponent = true; } } if (component != null) { if (isNewComponent) { importRepo.ComponentRepo.Save(component); } else { importRepo.ComponentRepo.SaveOrUpdate(component); } } break; } PartData pd = new PartData(); pd.Id = partId; pd.PartType = type; return(pd); }
public void ImportarSpools(DataTable dtSpoolsImport, IProgress <ImportProgressReport> progress) { UnitOfWork uow = new UnitOfWork(((XPObjectSpace)objectSpace).Session.ObjectLayer); if (uow.FindObject <TabDiametro>(CriteriaOperator.Parse("")) is null) { throw new ArgumentNullException("TabDiametro vazia!"); } if (uow.FindObject <TabEAPPipe>(CriteriaOperator.Parse("")) is null) { throw new ArgumentNullException("TabEAPPPipe vazia!"); } if (uow.FindObject <TabPercInspecao>(CriteriaOperator.Parse("")) is null) { throw new ArgumentNullException("TabPercInspecao vazia!"); } if (uow.FindObject <TabProcessoSoldagem>(CriteriaOperator.Parse("")) is null) { throw new ArgumentNullException("TabProcessoSoldagem vazia!"); } if (uow.FindObject <TabSchedule>(CriteriaOperator.Parse("")) is null) { throw new ArgumentNullException("TabSchedule vazia!"); } var TotalDeJuntas = dtSpoolsImport.Rows.Count; var oldSpools = Utils.GetOldDatasForCheck <Spool>(uow); progress.Report(new ImportProgressReport { TotalRows = TotalDeJuntas, CurrentRow = 0, MessageImport = "Inicializando importação" }); uow.BeginTransaction(); for (int i = 0; i < TotalDeJuntas; i++) { if (i >= 7) { var linha = dtSpoolsImport.Rows[i]; var contrato = uow.FindObject <Contrato>(new BinaryOperator("NomeDoContrato", linha[0].ToString())); var documento = linha[2].ToString(); var isometrico = linha[9].ToString(); var tagSpool = $"{Convert.ToString(linha[9])}-{Convert.ToString(linha[10])}"; var criteriaOperator = CriteriaOperator.Parse("Contrato.Oid = ? And Documento = ? And Isometrico = ? And TagSpool = ?", contrato.Oid, documento, isometrico, tagSpool); var spool = uow.FindObject <Spool>(criteriaOperator); if (spool == null) { spool = new Spool(uow); } else { oldSpools.FirstOrDefault(x => x.Oid == spool.Oid).DataExist = true; } //var spool = objectSpace.CreateObject<Spool>(); spool.Contrato = contrato; spool.SiteFabricante = linha[8].ToString(); spool.ArranjoFisico = linha[1].ToString(); spool.Documento = documento; spool.CampoAuxiliar = linha[3].ToString(); spool.SubSop = linha[4].ToString(); spool.AreaFisica = Convert.ToString(linha[5]); spool.Sth = Convert.ToString(linha[6]); spool.Linha = Convert.ToString(linha[7]); spool.Isometrico = isometrico; spool.TagSpool = tagSpool; spool.RevSpool = Convert.ToString(linha[11]); spool.RevIso = Convert.ToString(linha[12]); spool.Material = Convert.ToString(linha[13]); spool.Norma = Convert.ToString(linha[14]); spool.Diametro = Utils.ConvertINT(linha[15]); spool.DiametroPolegada = Convert.ToString(linha[16]); spool.Espessura = Utils.ConvertINT(linha[17]); spool.Espec = Convert.ToString(linha[18]); spool.PNumber = Convert.ToString(linha[19]); spool.Fluido = Convert.ToString(linha[20]); spool.TipoIsolamento = Convert.ToString(linha[21]); spool.CondicaoPintura = Convert.ToString(linha[22]); spool.Comprimento = Convert.ToDouble(linha[23]); spool.PesoFabricacao = Convert.ToDouble(linha[24]); spool.Area = Convert.ToString(linha[25]); spool.EspIsolamento = Convert.ToString(linha[26]); spool.QuantidadeIsolamento = Utils.ConvertINT(linha[27]); spool.TotaldeJuntas = Utils.ConvertINT(linha[28]); spool.TotaldeJuntasPipe = Utils.ConvertINT(linha[29]); spool.DataCadastro = Utils.ConvertDateTime(linha[30]); spool.NrProgFab = linha[31].ToString(); spool.DataProgFab = Utils.ConvertDateTime(linha[32]); spool.DataCorte = Utils.ConvertDateTime(linha[33]); spool.DataVaFab = Utils.ConvertDateTime(linha[34]); spool.DataSoldaFab = Utils.ConvertDateTime(linha[35]); spool.DataVsFab = Utils.ConvertDateTime(linha[36]); spool.DataDfFab = Utils.ConvertDateTime(linha[37]); spool.RelatorioDf = Convert.ToString(linha[38]); spool.InspetorDf = Convert.ToString(linha[39]); spool.DataEndFab = Utils.ConvertDateTime(linha[40]); spool.DataPiFundo = Utils.ConvertDateTime(linha[41]); spool.InspPinturaFundo = Convert.ToString(linha[42]); spool.RelatorioPinFundo = Convert.ToString(linha[43]); spool.RelIndFundo = Convert.ToString(linha[44]); spool.DataPiIntermediaria = Utils.ConvertDateTime(linha[45]); spool.InspPiIntermediaria = Convert.ToString(linha[46]); spool.RelPiIntermediaria = Convert.ToString(linha[47]); spool.RelIndIntermediaria = Convert.ToString(linha[48]); spool.DataPiAcabamento = Utils.ConvertDateTime(linha[49]); spool.InspPintAcabamento = Convert.ToString(linha[50]); spool.RelPintAcabamento = Convert.ToString(linha[51]); spool.RelIndPintAcabamento = Convert.ToString(linha[52]); spool.DataPiRevUnico = Utils.ConvertDateTime(linha[53]); spool.InspPiRevUnico = Convert.ToString(linha[54]); spool.RelPiRevUnico = Convert.ToString(linha[55]); spool.DataPintFab = Utils.ConvertDateTime(linha[56]); spool.ProgMontagem = Convert.ToString(linha[57]); spool.Elevacao = Convert.ToString(linha[58]); spool.ProgPintura = Convert.ToString(linha[59]); spool.EscopoMontagem = Convert.ToString(linha[60]); spool.DataPreMontagem = Utils.ConvertDateTime(linha[61]); spool.DataVaMontagem = Utils.ConvertDateTime(linha[62]); spool.DataSoldaMontagem = Utils.ConvertDateTime(linha[63]); spool.DataVsMontagem = Utils.ConvertDateTime(linha[64]); spool.InspDiMontagem = Convert.ToString(linha[65]); spool.DataDiMontagem = Utils.ConvertDateTime(linha[66]); spool.DataEndMontagem = Utils.ConvertDateTime(linha[67]); spool.DataPintMontagem = Utils.ConvertDateTime(linha[68]); spool.TagComponente = Convert.ToString(linha[69]); spool.IdComponente = Convert.ToString(linha[70]); spool.Romaneio = Convert.ToString(linha[71]); spool.DataRomaneio = Utils.ConvertDateTime(linha[72]); spool.DataLiberacao = Utils.ConvertDateTime(linha[73]); spool.PesoMontagem = Utils.ConvertDouble(linha[74]); spool.SituacaoFabricacao = Convert.ToString(linha[75]); spool.SituacaoMontagem = Convert.ToString(linha[76]); //spool.DataLineCheck = Utils.ConvertDateTime(linha[75]); } if (i % 1000 == 0) { try { uow.CommitTransaction(); } catch { uow.RollbackTransaction(); throw new Exception("Process aborted by system"); } } progress.Report(new ImportProgressReport { TotalRows = TotalDeJuntas, CurrentRow = i + 1, MessageImport = $"Importando linha {i}/{TotalDeJuntas}" }); } uow.CommitTransaction(); uow.PurgeDeletedObjects(); uow.CommitChanges(); uow.Dispose(); progress.Report(new ImportProgressReport { TotalRows = TotalDeJuntas, CurrentRow = TotalDeJuntas, MessageImport = $"Gravando Alterações no Banco" }); // Implatar funcionalidade //var excluirSpoolsNaoImportado = oldSpools.Where(x => x.DataExist = false); }