public AllFlights() { InitializeComponent(); loadARCodes(); FlightBox.Items.Clear(); FlightBox.Items.Add("FLIGHTS"); try { SQL = "select f.FTRTID, r.rtardepart,r.rtararrivl from flight2019.flight f inner join flight2019.route r on FTRTID = RTID"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { String departcity = "ERROR IF UNCHANGED"; String arrivalcity = "ERROR IF UNCHANGED"; arcodes.TryGetValue(dataReader.GetString(1), out departcity); arcodes.TryGetValue(dataReader.GetString(2), out arrivalcity); FlightBox.Items.Add("Flight ID: " + dataReader.GetString(0) + " Departing: " + departcity.Trim() + " Arriving at: " + arrivalcity.Trim()); } connection.Close(); } catch (Exception ex) { FlightBox.Items.Add(ex.Message); } }
public List <PendientesLlenos> ListaStockLlenos() { List <PendientesLlenos> dtResult = new List <PendientesLlenos>(); iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); iDB2Command cmd; cmd = new iDB2Command("SP_CONSULTA_DSREPSTOCKCONTLLENOS_V2", cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PendientesLlenos a = new PendientesLlenos(); a.YardCode = dr.IsDBNull(dr.GetOrdinal("NUMIDE")) ? "" : dr.GetString(dr.GetOrdinal("NUMIDE")); a.EquipmentNumber = dr.IsDBNull(dr.GetOrdinal("NROCON")) ? "" : dr.GetString(dr.GetOrdinal("NROCON")); dtResult.Add(a); } } catch (Exception ex) { dtResult = null; } finally { cn.Close(); } return(dtResult); }
public AllAirports() { InitializeComponent(); AirportBox.Items.Clear(); AirportBox.Items.Add("AIRPORTS"); AirportBox.Items.Add("AIRPORT CODE, AIRPORT NAME"); try { SQL = "select ARCD,arnm from flight2019.airport"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { AirportBox.Items.Add(dataReader.GetString(0) + ", " + dataReader.GetString(1)); } connection.Close(); } catch (Exception ex) { AirportBox.Items.Add(ex.Message); } }
public List <User> findAll() { string sql = "SELECT USER_NO,USERNAME,PASSWORD FROM \"USER\" ORDER BY USERNAME"; using (iDB2DataReader rdr = DB2Helper.ExecuteReader(DB2Helper.ConnectionString, CommandType.Text, sql, null)) { if (rdr.Read()) { List <User> list = new List <User>(); do { User user = new User(); user.userNo = rdr.GetInt32(0); user.username = rdr.GetString(1); user.password = rdr.GetString(2); list.Add(user); } while (rdr.Read()); return(list); } else { return(null); } } }
private void SubmitBtn_Click(object sender, EventArgs e) { if (AnDText.Text.Length > 0 && AnDText.Text != null) { AnDBox.Items.Clear(); AnDBox.Items.Add("FLIGHTS"); try { SQL = "select f.FTRTID, r.rtardepart,r.rtararrivl,f.flightno from flight2019.flight f inner join flight2019.route r on f.FTRTID = r.RTID where f.FLIGHTNO='"; SQL += AnDText.Text + "'"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { String departcity = "ERROR IF UNCHANGED"; String arrivalcity = "ERROR IF UNCHANGED"; arcodes.TryGetValue(dataReader.GetString(1), out departcity); arcodes.TryGetValue(dataReader.GetString(2), out arrivalcity); AnDBox.Items.Add("Flight ID: " + dataReader.GetString(0) + " Departing: " + departcity.Trim() + " Arriving at: " + arrivalcity.Trim()); } connection.Close(); } catch (Exception ex) { AnDBox.Items.Add(ex.Message); } } }
private void DspPlane_Click(object sender, EventArgs e) { try { //Select everything within the AIRPLANE table SQL = "Select * FROM AIRPLANE"; comm = new iDB2Command(SQL, conn); conn.Open(); reader = comm.ExecuteReader(); while (reader.Read()) { //Use reader and the listbox to display all non null values in the table DisplayPlane.Items.Add("Plane#: " + reader.GetString(0) + " Max Flight Dist: " + reader.GetString(1) + " FClass: " + reader.GetString(2) + " CClass: " + reader.GetString(3) + " PAvail: " + reader.GetString(4) + " MaintMiles: " + reader.GetString(5) + " PlaneModel: " + reader.GetString(6) + " PlaneMake: " + reader.GetString(7) + " APARCD: " + reader.GetString(8) + " Date Maintenence: " + reader.GetString(12)); } conn.Close(); } //Any DB error catches catch (iDB2Exception ie) { DisplayPlane.Items.Add(ie.Message); } catch (Exception ex) { DisplayPlane.Items.Add(ex.Message); } }
/// <summary> /// Returns downloaded Dictioanry with UPC codes matching items. /// </summary> public Dictionary <string, string> DownloadUpcForItemsAsync(BindableCollection <IpgModel> _ipgsCollection) { Console.WriteLine("Trying to connect to Reflex for downloading UPC codes..."); // Dictionary for holding Ean to Upc map. Dictionary <string, string> Ean_Upc = new Dictionary <string, string>(); // Preparing a formatted list of items. string _items = ConcatenateItemsIntoList(_ipgsCollection); try { conn.Open(); if (conn != null) { Console.WriteLine("Successfully connected to Reflex for downloading UPC codes"); // Below are DB2 functions needed for executing query string _queryString = $"SELECT VICART, VICIVL FROM {Environment}.HLVLIDP WHERE VICART IN {_items} and VICTYI = 'EAN_1' Order by VICIVL "; iDB2Command comm = conn.CreateCommand(); comm.CommandText = _queryString; iDB2DataReader reader = comm.ExecuteReader(); // Reader in while goes through all rows of results from Reflex. while (reader.Read()) { // Adds new key-value to a Dictionary. Ean_Upc.Add(reader.GetString(0).ToString().Trim(), reader.GetString(1).ToString().Trim()); } Console.WriteLine("Dictionary EAN_UPC created"); // Some cleaning needed. reader.Close(); comm.Dispose(); // Return Dictionary return(Ean_Upc); } } catch (Exception ex) { Console.WriteLine("Error : " + ex); Console.WriteLine(ex.StackTrace); return(null); } finally { conn.Close(); } // This will never reach by needs to be here because of error "Not all is returning value". return(Ean_Upc); }
public string EjecutarSelectResult(string consulta) { try { AS400ConnectionString.Open(); string datoDevuelto = string.Empty; iDB2Command command = new iDB2Command(); command.Connection = AS400ConnectionString; command.CommandType = System.Data.CommandType.Text; command.CommandText = consulta; command.CommandTimeout = 600000; iDB2DataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { datoDevuelto = dr.GetString(0); break; } } return(datoDevuelto); } catch (Exception ex) { return("0"); //throw new Exception("Se produjo un problema al reaizar un select en AS400: ", ex); } }
public string ObtenerRazonSocialAS400(string ruc) { string dResultado = ""; iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); try { iDB2Command cmd = new iDB2Command("SELECT * FROM RZZM01 WHERE NRUC = @Ruc FETCH FIRST 1 ROWS ONLY", cn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@Ruc", SqlDbType.VarChar).Value = ruc; cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { dResultado = dr.IsDBNull(dr.GetOrdinal("TCMPCL")) ? "" : dr.GetString(dr.GetOrdinal("TCMPCL")); } } catch (Exception ex) { dResultado = ""; } finally { cn.Close(); } return(dResultado); }
public string ObtenerNaveViaje(string ordenServicio) { string NaveViaje = ""; iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); iDB2Command cmd; cmd = new iDB2Command("SP_OBTENERNAVE_VIAJE", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("XNORSRN", iDB2DbType.iDB2VarChar).Value = ordenServicio; try { cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { NaveViaje = (dr.IsDBNull(dr.GetOrdinal("TCMPVP")) ? "" : dr.GetString(dr.GetOrdinal("TCMPVP")).Trim()) + " - " + (dr.IsDBNull(dr.GetOrdinal("NVJES")) ? "" : dr.GetString(dr.GetOrdinal("NVJES"))); } } catch (Exception ex) { NaveViaje = ""; } finally { cn.Close(); } return(NaveViaje); }
private void btnGetTask_Click(object sender, EventArgs e) { try { connection = new iDB2Connection("DataSource=deathstar.gtc.edu"); command = connection.CreateCommand(); command.CommandText = "SELECT taskDesc " + "FROM Tasks T JOIN WorkOrder WO ON T.taskId = WO.taskId " + "WHERE WO.orderId = '" + txtWorkOrder.Text.ToUpper() + "'"; connection.Open(); reader = command.ExecuteReader(); if (reader.Read()) { txtTask.Text = reader.GetString(0); } else { txtTask.Text = "No results found for specified work order id."; } reader.Close(); } catch (Exception ex) { txtTask.Text = ex.Message; } }
private void btnGetLog_Click(object sender, EventArgs e) { //ceonnect to the database try { connection = new iDB2Connection("DataSource=deathstar.gtc.edu;DefaultCollection=FLIGHT2019"); command = connection.CreateCommand(); //grab the data command.CommandText = "SELECT * FROM MAINTLOG " + "WHERE PLANENO = '" + txtPlaneNum.Text.ToUpper() + "'"; connection.Open(); dataReader = command.ExecuteReader(); //Display to listbox if (dataReader.Read()) { listBox1.Items.Add("Log Number: " + dataReader.GetString(1)); listBox1.Items.Add("Task ID: " + dataReader.GetString(2)); listBox1.Items.Add("Maintence Start Date: " + dataReader.GetString(3)); listBox1.Items.Add("Maintence End Date: " + dataReader.GetString(4)); listBox1.Items.Add("Status: " + dataReader.GetString(5)); listBox1.Items.Add("Maintence Cost: " + dataReader.GetString(6)); } else { txtPlaneNum.Text = "No results found for specified Plane Number id."; } dataReader.Close(); } catch (Exception ex) { txtPlaneNum.Text = ex.Message; } }
public MaintenanceLogs() { InitializeComponent(); LogBox.Items.Clear(); LogBox.Items.Add("Maint Logs"); try { SQL = "select * from flight2019.MaintLog"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { LogBox.Items.Add("Log#: " + dataReader.GetString(1)); LogBox.Items.Add("Plane#: " + dataReader.GetString(2)); LogBox.Items.Add("TaskID: " + dataReader.GetString(3)); LogBox.Items.Add("Maint Start Date: " + dataReader.GetString(4)); LogBox.Items.Add("Maint End Date: " + dataReader.GetString(5)); LogBox.Items.Add("Status: " + dataReader.GetString(6)); } connection.Close(); } catch (Exception ex) { LogBox.Items.Add(ex.Message); } }
private void SubmitBtn2_Click(object sender, EventArgs e) { if (CrewText.Text != null && CrewText.Text.Length > 0) { CrewBox.Items.Clear(); CrewBox.Items.Add("CREW FOR FLIGHT: " + CrewText.Text); try { SQL = "select f.flightno, c.pilots,c.attendants,c.resclerk,c.maint,c.janitor,c.refueling from flight2019.flight f inner join flight2019.crew c on f.flightno = c.flightno where f.FLIGHTNO='"; SQL += CrewText.Text + "'"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { CrewBox.Items.Add("Pilots: " + dataReader.GetString(1)); CrewBox.Items.Add("Attendants: " + dataReader.GetString(2)); CrewBox.Items.Add("ResClerks: " + dataReader.GetString(3)); CrewBox.Items.Add("Maint: " + dataReader.GetString(4)); CrewBox.Items.Add("Janitor: " + dataReader.GetString(5)); CrewBox.Items.Add("Refueling: " + dataReader.GetString(6)); } connection.Close(); } catch (Exception ex) { CrewBox.Items.Add(ex.Message); } } }
public void loadARCodes() { try { SQL = "select ARCD,arcitynm from flight2019.airport"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); arcodes = new SortedDictionary <string, string>(); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { arcodes.Add(dataReader.GetString(0), dataReader.GetString(1)); } connection.Close(); } catch (Exception ex) { AnDBox.Items.Add(ex.Message); } }
public User get(string username) { string sql = "SELECT USER_NO,USERNAME,PASSWORD FROM \"USER\" WHERE USERNAME=@USERNAME"; iDB2Parameter[] parms = new iDB2Parameter[] { new iDB2Parameter("@USERNAME", username) }; using (iDB2DataReader rdr = DB2Helper.ExecuteReader(DB2Helper.ConnectionString, CommandType.Text, sql, parms)) { if (rdr.Read()) { User user = new User(); user.userNo = rdr.GetInt32(0); user.username = rdr.GetString(1); user.password = rdr.GetString(2); return(user); } else { return(null); } } }
public IDictionary <string, string> FindAllDic(string sql) { IDictionary <string, string> list = new Dictionary <string, string>(); using (iDB2DataReader rdr = DB2Helper.ExecuteReader(DB2Helper.ConnectionString, CommandType.Text, sql)) { if (rdr.Read()) { do { try { list.Add(rdr.GetString(0), rdr.GetString(1)); } catch (Exception ex) { log.Error("字段类型错误," + rdr.GetValue(0).ToString() + ":" + rdr.GetValue(1).ToString() + ":" + ex.Message); } } while (rdr.Read()); } } return(list); }
public AllPlanes() { InitializeComponent(); PlaneBox.Items.Clear(); PlaneBox.Items.Add("AIRPLANES"); try { SQL = "select planeno,planemodel,pmake from flight2019.airplane"; connection = new iDB2Connection("datasource=deathstar.gtc.edu"); command = new iDB2Command(SQL, connection); connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { PlaneBox.Items.Add(dataReader.GetString(0).Trim() + ", " + dataReader.GetString(1).Trim() + ", " + dataReader.GetString(2).Trim()); } connection.Close(); } catch (Exception ex) { PlaneBox.Items.Add(ex.Message); } }
public string nativeQuerySqlReturnString(string sql, IDictionary <string, object> parms) { string result = string.Empty; iDB2Parameter[] db2Parms = null; if (parms != null) { List <iDB2Parameter> parmsList = new List <iDB2Parameter>(); foreach (var item in parms) { Debug.Assert(item.Value != null); parmsList.Add(new iDB2Parameter('@' + item.Key, item.Value)); } db2Parms = parmsList.ToArray(); } using (iDB2DataReader rdr = DB2Helper.ExecuteReader(DB2Helper.ConnectionString, CommandType.Text, sql, db2Parms)) { if (rdr.Read()) { result = rdr.GetString(0); } } return(result); }
//WCSACCDB /// <summary> /// Returns true if HD exist, and saves this hd in OriginalHdModel instance created in this class. /// If hd is Unknown returns false. /// </summary> public bool DownloadHdFromReflex(string _hd) { Console.WriteLine("Trying to connect to Reflex for downloading HD informations."); try { conn.Open(); if (conn != null) { Console.WriteLine("Successfully connected to Reflex for downloading HD informations."); // Below are DB2 functions needed for executing query // Query join table where we can see lines by items. A2CFAN is telling to DB2 to show only lines value. // You can change it to show CAPO or something else. Result will be in field A2CFAR. // This also needs to be ordered by Item. string _queryString = $"SELECT GECART, GECQAL, A.A2CFAR, GEQGEI, B.A2CFAR FROM {Environment}.HLGEINP " + $"inner join {Environment}.HLCDFAP A on GECART = A.A2CART " + $"inner join {Environment}.HLCDFAP B on GECART = B.A2CART " + $"WHERE GENSUP = '{_hd}' and A.A2CFAN = 'LINE' AND B.A2CFAN = 'STAGIONE'" + "Order by GECART"; iDB2Command comm = conn.CreateCommand(); comm.CommandText = _queryString; iDB2DataReader reader = comm.ExecuteReader(); // Below if checks if there is some data in result. If no then it return false. // That means that HD is Unknown. if (reader.HasRows) { // Reader in while goes through all rows of results from Reflex. while (reader.Read()) { // Here we are adding new IPG to HD object. OriginalHdModel.ListOfIpgs.Add(new IpgModel() { Item = reader.GetString(0).ToString().Trim(), Grade = reader.GetString(1).ToString().Trim(), // Lines is an enum so we need parse string to enum here. Line = (Lines)Enum.Parse(typeof(Lines), reader.GetString(2)), Quantity = reader.GetInt32(3), Season = reader.GetString(4).ToString().Trim() }); } // some cleaning. reader.Close(); comm.Dispose(); // Returns true so we have our data in "OriginalHdModel" instance. return(true); } else { // When there is no data from Reflex return(false); } } } catch (Exception ex) { Console.WriteLine("Error : " + ex); Console.WriteLine(ex.StackTrace); return(false); } finally { conn.Close(); } // This will never reach but needs to be here because of error "Not all is returning value". return(false); }
public List <DetalleNave> ListarDetallesdeEnvio(string ordenServicio) { iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); iDB2Command cmd; string tipoOperacion = obtenerTipoOperacion(ordenServicio); if (tipoOperacion.Equals("I")) { cmd = new iDB2Command("SP_INTEGRACION_CARCOOL_IMPO", cn); } else { cmd = new iDB2Command("SP_INTEGRACION_CARCOOL_EXPO", cn); } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("XNORSRN", iDB2DbType.iDB2VarChar).Value = ordenServicio; List <DetalleNave> detalleNave = new List <DetalleNave>(); try { cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //refrescar datos DetalleNave e = new DetalleNave(); e.Recalada = dr.GetString(dr.GetOrdinal("OrdenServicio")); e.Manifiesto = dr.GetString(dr.GetOrdinal("Manifiesto")); e.Nave = dr.GetString(dr.GetOrdinal("Nave")).Trim(); e.Viaje = dr.GetString(dr.GetOrdinal("Viaje")).Trim(); e.Operador = dr.GetString(dr.GetOrdinal("Operador")); e.FechaArribo = dr.GetDateTime(dr.GetOrdinal("FechaArribo")); //e.FechaTerminoDescarga = dr.IsDBNull(dr.GetOrdinal("FechaterminoDescarga")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("FechaterminoDescarga")); e.FechaTerminoDescarga = dr.GetString(dr.GetOrdinal("FechaterminoDescarga")) == "" ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("FechaterminoDescarga")); //e.FechaCutOffdry = dr.IsDBNull(dr.GetOrdinal("FechaCutOffdry")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("FechaCutOffdry")); e.FechaCutOffdry = dr.GetString(dr.GetOrdinal("FechaCutOffdry")) == "" ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("FechaCutOffdry")); //e.FechaCutOffReefer = dr.IsDBNull(dr.GetOrdinal("FechaCutOffReefer")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("FechaCutOffReefer")); e.FechaCutOffReefer = dr.GetString(dr.GetOrdinal("FechaCutOffReefer")) == "" ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("FechaCutOffReefer")); e.FechaZarpe = dr.IsDBNull(dr.GetOrdinal("FechaZarpe")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("FechaZarpe")); e.TipoOperacion = dr.GetString(dr.GetOrdinal("TipoOperacion")); e.Contenedor = dr.GetString(dr.GetOrdinal("Contenedor")).Trim(); e.Tipo = dr.GetString(dr.GetOrdinal("TipodeDocumento")); e.BlBooking = dr.GetString(dr.GetOrdinal("BlBooking")).Trim(); e.Consignatario = dr.GetString(dr.GetOrdinal("Consignatario")).Trim(); e.TipoContenedor = dr.GetString(dr.GetOrdinal("TipoContenedor")); e.Dimension = dr.GetString(dr.GetOrdinal("Dimension")); e.Condicion = dr.GetString(dr.GetOrdinal("Condicion")); e.Peso = dr.GetDecimal(dr.GetOrdinal("Peso")); e.Temperatura = dr.GetString(dr.GetOrdinal("Temperatura")); e.Imo = dr.GetBoolean(dr.GetOrdinal("IMO")); e.Iqbf = dr.GetBoolean(dr.GetOrdinal("IQBF")); e.SINI = dr.GetBoolean(dr.GetOrdinal("SINI")); e.Conexion = dr.GetBoolean(dr.GetOrdinal("Conexion")); detalleNave.Add(e); } } catch (Exception ex) { List <string> listaDestinatarios = new List <string>(); List <string> listaCopia = new List <string>(); List <string> listaCopiaOculta = new List <string>(); string destinatarios = ConfigurationManager.AppSettings["Destinatarios"].ToString(); if (destinatarios != "" && destinatarios.Contains(";")) { var correosDestino = destinatarios.Split(';'); foreach (string item in correosDestino) { listaDestinatarios.Add(item); } } else { listaDestinatarios.Add(destinatarios); } string copia = ConfigurationManager.AppSettings["ConCopia"].ToString(); if (copia != "" && copia.Contains(";")) { var correosCopia = copia.Split(';'); foreach (string item in correosCopia) { listaCopia.Add(item); } } else { listaCopia.Add(copia); } string copiaOculta = ConfigurationManager.AppSettings["CopiaOculta"].ToString(); if (copiaOculta != "" && copiaOculta.Contains(";")) { var correosCopiaOculta = copiaOculta.Split(';'); foreach (string item in correosCopiaOculta) { listaCopiaOculta.Add(item); } } else { listaCopiaOculta.Add(copiaOculta); } new ManejadorCorreos().EnviarCorreo(ConfigurationManager.AppSettings["AsuntoCorreoError"].ToString(), ex.Message.ToString(), listaDestinatarios, listaCopia, listaCopiaOculta); detalleNave = null; } finally { cn.Close(); } return(detalleNave); }
public List <PendientesLlenos> ListaPendientesLlenos(string tipo) { List <PendientesLlenos> dtResult = new List <PendientesLlenos>(); iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); iDB2Command cmd; cmd = new iDB2Command("SP_INTEGRACIONTDEPOT_JMY", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("XTIPO", iDB2DbType.iDB2VarChar).Value = tipo; try { cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PendientesLlenos a = new PendientesLlenos(); a.NUMID = dr.IsDBNull(dr.GetOrdinal("NUMID")) ? 0 : dr.GetInt32(dr.GetOrdinal("NUMID")); a.VesselIMO = dr.IsDBNull(dr.GetOrdinal("CINDVP")) ? "" : dr.GetString(dr.GetOrdinal("CINDVP")); a.OceanCarrier = dr.IsDBNull(dr.GetOrdinal("CLINE")) ? "" : dr.GetString(dr.GetOrdinal("CLINE")); a.CustomerERPCode = dr.IsDBNull(dr.GetOrdinal("NRUCA")) ? "" : dr.GetString(dr.GetOrdinal("NRUCA")); a.YardCode = dr.IsDBNull(dr.GetOrdinal("CTPDEP")) ? "" : dr.GetString(dr.GetOrdinal("CTPDEP")); a.ActionType = dr.IsDBNull(dr.GetOrdinal("CACTTP")) ? "" : dr.GetString(dr.GetOrdinal("CACTTP")); a.VoyageNumber = dr.IsDBNull(dr.GetOrdinal("VOYNUM")) ? "" : dr.GetString(dr.GetOrdinal("VOYNUM")); a.VoyageStopExternalCode = dr.IsDBNull(dr.GetOrdinal("CRECAL")) ? "" : dr.GetString(dr.GetOrdinal("CRECAL")); a.ReferenceType = dr.IsDBNull(dr.GetOrdinal("CTDCRF")) ? "" : dr.GetString(dr.GetOrdinal("CTDCRF")); a.ReferenceNumber = dr.IsDBNull(dr.GetOrdinal("NDCREF")) ? "" : dr.GetString(dr.GetOrdinal("NDCREF")); a.OperationType = dr.IsDBNull(dr.GetOrdinal("CTIPOP")) ? "" : dr.GetString(dr.GetOrdinal("CTIPOP")); a.PortOfDischarge = dr.IsDBNull(dr.GetOrdinal("CPRLLN")) ? "" : dr.GetString(dr.GetOrdinal("CPRLLN")); a.PlaceOfDelivery = dr.IsDBNull(dr.GetOrdinal("CPRLLN")) ? "" : dr.GetString(dr.GetOrdinal("CPRLLN")); a.PlaceOfReceipt = dr.IsDBNull(dr.GetOrdinal("CPROR1")) ? "" : dr.GetString(dr.GetOrdinal("CPROR1")); a.PortOfLoading = dr.IsDBNull(dr.GetOrdinal("CPROR1")) ? "" : dr.GetString(dr.GetOrdinal("CPROR1")); a.ShipmentType = dr.IsDBNull(dr.GetOrdinal("CTPCNC")) ? "" : dr.GetString(dr.GetOrdinal("CTPCNC")); a.ActivityCode = dr.IsDBNull(dr.GetOrdinal("CACTVC")) ? "" : dr.GetString(dr.GetOrdinal("CACTVC")); a.direction = dr.IsDBNull(dr.GetOrdinal("CDIREC")) ? "" : dr.GetString(dr.GetOrdinal("CDIREC")); a.Status = dr.IsDBNull(dr.GetOrdinal("CSTSMV")) ? "" : dr.GetString(dr.GetOrdinal("CSTSMV")); a.VehiclePlate = dr.IsDBNull(dr.GetOrdinal("NPLCUN")) ? "" : dr.GetString(dr.GetOrdinal("NPLCUN")); a.ExecutionDate = dr.IsDBNull(dr.GetOrdinal("FCHMOV")) ? "" : dr.GetString(dr.GetOrdinal("FCHMOV")); a.EquipmentNumber = dr.IsDBNull(dr.GetOrdinal("NROCON")) ? "" : dr.GetString(dr.GetOrdinal("NROCON")); a.EquipmentTypeSizeISOCode = dr.IsDBNull(dr.GetOrdinal("ISOCODE")) ? "" : dr.GetString(dr.GetOrdinal("ISOCODE")); dtResult.Add(a); } } catch (Exception ex) { dtResult = null; } finally { cn.Close(); } return(dtResult); }
public List <LiquidacionOpe> ListarLiquidacionOperaciones(int norsrn) { iDB2Connection cn = new iDB2Connection(ConfigurationManager.ConnectionStrings["cnnRansa"].ConnectionString); iDB2Command cmd; cmd = new iDB2Command("SP_INTEGRACION_CARCOOL_LIQOPE", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@NORSRN", iDB2DbType.iDB2Numeric).Value = norsrn; List <LiquidacionOpe> LstLiqOpe = new List <LiquidacionOpe>(); try { cn.Open(); iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //refrescar datos LiquidacionOpe e = new LiquidacionOpe(); e.NMRLQO = dr.GetInt32(dr.GetOrdinal("NMRLQO")); e.NORSRN = dr.GetInt32(dr.GetOrdinal("NORSRN")); e.FINDSC = dr.GetString(dr.GetOrdinal("FINDSC")); e.HINDSC = dr.GetString(dr.GetOrdinal("HINDSC")); e.FFNDSC = dr.GetString(dr.GetOrdinal("FFNDSC")); e.HFNDSC = dr.GetString(dr.GetOrdinal("HFNDSC")); e.FINEMB = dr.GetString(dr.GetOrdinal("FINEMB")); e.HINEMB = dr.GetString(dr.GetOrdinal("HINEMB")); e.FFNEMB = dr.GetString(dr.GetOrdinal("FFNEMB")); e.HFNEMB = dr.GetString(dr.GetOrdinal("HFNEMB")); e.FCOFF1 = dr.GetString(dr.GetOrdinal("FCOFF1")); e.HCOFF1 = dr.GetString(dr.GetOrdinal("HCOFF1")); e.FCOFF2 = dr.GetString(dr.GetOrdinal("FCOFF2")); e.HCOFF2 = dr.GetString(dr.GetOrdinal("HCOFF2")); e.FPSTAK = dr.GetString(dr.GetOrdinal("FPSTAK")); e.HPSTAK = dr.GetString(dr.GetOrdinal("HPSTAK")); e.FATQNA = dr.GetString(dr.GetOrdinal("FATQNA")); e.HATQNA = dr.GetString(dr.GetOrdinal("HATQNA")); LstLiqOpe.Add(e); } } catch (Exception ex) { List <string> listaDestinatarios = new List <string>(); List <string> listaCopia = new List <string>(); List <string> listaCopiaOculta = new List <string>(); string destinatarios = ConfigurationManager.AppSettings["Destinatarios"].ToString(); if (destinatarios != "" && destinatarios.Contains(";")) { var correosDestino = destinatarios.Split(';'); foreach (string item in correosDestino) { listaDestinatarios.Add(item); } } else { listaDestinatarios.Add(destinatarios); } string copia = ConfigurationManager.AppSettings["ConCopia"].ToString(); if (copia != "" && copia.Contains(";")) { var correosCopia = copia.Split(';'); foreach (string item in correosCopia) { listaCopia.Add(item); } } else { listaCopia.Add(copia); } string copiaOculta = ConfigurationManager.AppSettings["CopiaOculta"].ToString(); if (copiaOculta != "" && copiaOculta.Contains(";")) { var correosCopiaOculta = copiaOculta.Split(';'); foreach (string item in correosCopiaOculta) { listaCopiaOculta.Add(item); } } else { listaCopiaOculta.Add(copiaOculta); } new ManejadorCorreos().EnviarCorreo(ConfigurationManager.AppSettings["AsuntoCorreoError"].ToString(), ex.Message.ToString(), listaDestinatarios, listaCopia, listaCopiaOculta); LstLiqOpe = null; } finally { cn.Close(); } return(LstLiqOpe); }