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