public bool Agregar(E_Shipment_Guide guide1)
{
D_Shipment_Guide guide2 = new D_Shipment_Guide();
if (guide2.Agregar(guide1))
{
return(true);
}
else
{
Mensaje = guide2.Mensaje;
return(false);
}
}
public bool Agregar(E_Shipment_Guide guide)
{
string query;
MySqlCommand cmd;
query = "insert into tbl_shipment_guide" +
"(" +
"aerial_guide,id_shipper,id_consignee,id_carrier_agent,id_accounting_info,id_departure_airport,requested_routing,optional_shipping_number,optional_shipping_info," +
"code_first_carrier,code_second_carrier,id_airport_destination_second_carrier,code_third_carrier,id_airport_destination_third_carrier,id_currency,payment_methods," +
"declared_value_carriage,declared_value_customs,id_destination_airport,requested_flight_num,requested_flight_date,amount_insurance,handling_info,id_ULD," +
"nature_quantity_goods,number_pieces,gross_weight,weight_charge,valuation_charge,tax,other_charges_due_agent,other_charges_due_carrier,total_prepaid,total_collect," +
"currency_conversion_rate,collect_charges_dest_currency,charges_at_destination,total_collect_charges,signature_shipper,executed_date,at_place,signature_issuing_carrier" +
") " +
"values " +
"(" +
"@aerial_guide,@id_shipper,@id_consignee,@id_carrier_agent,@id_accounting_info,@id_departure_airport,@requested_routing,@optional_shipping_number,@optional_shipping_info," +
"@code_first_carrier,@code_second_carrier,@id_airport_destination_second_carrier,@code_third_carrier,@id_airport_destination_third_carrier,@id_currency,@payment_methods," +
"@declared_value_carriage,@declared_value_customs,@id_destination_airport,@requested_flight_num,@requested_flight_date,@amount_insurance,@handling_info,@id_ULD," +
"@nature_quantity_goods,@number_pieces,@gross_weight,@weight_charge,@valuation_charge,@tax,@other_charges_due_agent,@other_charges_due_carrier,@total_prepaid,@total_collect," +
"@currency_conversion_rate,@collect_charges_dest_currency,@charges_at_destination,@total_collect_charges,@signature_shipper,@executed_date,@at_place,@signature_issuing_carrier" +
")";
try
{
if (Conectar() == true)
{
cmd = new MySqlCommand(query, MySQLConexion);
//Primera Linea
cmd.Parameters.AddWithValue("@aerial_guide", guide.Aerial_guide);
cmd.Parameters.AddWithValue("@id_shipper", guide.Shipper);
cmd.Parameters.AddWithValue("@id_consignee", guide.Consignee);
cmd.Parameters.AddWithValue("@id_carrier_agent", guide.Carrier_Agent);
cmd.Parameters.AddWithValue("@id_accounting_info", guide.Accounting_info);
cmd.Parameters.AddWithValue("@id_departure_airport", guide.Departure_airport);
cmd.Parameters.AddWithValue("@requested_routing", guide.Requested_routing);
cmd.Parameters.AddWithValue("@optional_shipping_number", guide.Optional_shipping_number);
cmd.Parameters.AddWithValue("@optional_shipping_info", guide.Optional_shipping_info);
//Segunda Linea
cmd.Parameters.AddWithValue("@code_first_carrier", guide.Code_first_carrier);
cmd.Parameters.AddWithValue("@code_second_carrier", guide.Code_second_carrier);
cmd.Parameters.AddWithValue("@id_airport_destination_second_carrier", guide.Airport_Destination_second_carrier);
cmd.Parameters.AddWithValue("@code_third_carrier", guide.Code_third_carrier);
cmd.Parameters.AddWithValue("@id_airport_destination_third_carrier", guide.Airport_Destination_third_carrier);
cmd.Parameters.AddWithValue("@id_currency", guide.Currency);
cmd.Parameters.AddWithValue("@payment_methods", guide.Payment_methods);
//Tercera Linea
cmd.Parameters.AddWithValue("@declared_value_carriage", guide.Declared_value_carriage);
cmd.Parameters.AddWithValue("@declared_value_customs", guide.Declared_value_customs);
cmd.Parameters.AddWithValue("@id_destination_airport", guide.Destination_airport);
cmd.Parameters.AddWithValue("@requested_flight_num", guide.Requested_flight_num);
cmd.Parameters.AddWithValue("@requested_flight_date", guide.Requested_flight_date);
cmd.Parameters.AddWithValue("@amount_insurance", guide.Amount_insurance);
cmd.Parameters.AddWithValue("@handling_info", guide.Handling_information);
cmd.Parameters.AddWithValue("@id_ULD", guide.Elemento_ULD);
// Cuarta Linea
cmd.Parameters.AddWithValue("@nature_quantity_goods", guide.Nature_Quantity_Goods);
cmd.Parameters.AddWithValue("@number_pieces", guide.Num_Pieces);
cmd.Parameters.AddWithValue("@gross_weight", guide.Gross_weight.Replace(",", "."));
cmd.Parameters.AddWithValue("@weight_charge", guide.Weight_charge.Replace(",", "."));
cmd.Parameters.AddWithValue("@valuation_charge", guide.Valuation_charge.Replace(",", "."));
cmd.Parameters.AddWithValue("@tax", guide.Tax.Replace(",", "."));
cmd.Parameters.AddWithValue("@other_charges_due_agent", guide.Other_charges_due_agent.Replace(",", "."));
cmd.Parameters.AddWithValue("@other_charges_due_carrier", guide.Other_charges_due_carrier.Replace(",", "."));
cmd.Parameters.AddWithValue("@total_prepaid", guide.Total_prepaid.Replace(",", "."));
cmd.Parameters.AddWithValue("@total_collect", guide.Total_collect.Replace(",", "."));
//QuintaLinea
cmd.Parameters.AddWithValue("@currency_conversion_rate", guide.Currency_conversion_rate.Replace(",", "."));
cmd.Parameters.AddWithValue("@collect_charges_dest_currency", guide.Collect_Charges_Dest_Currency.Replace(",", "."));
cmd.Parameters.AddWithValue("@charges_at_destination", guide.Charges_at_destination.Replace(",", "."));
cmd.Parameters.AddWithValue("@total_collect_charges", guide.Total_collect_charges.Replace(",", "."));
cmd.Parameters.AddWithValue("@signature_shipper", guide.Signature_shipper);
cmd.Parameters.AddWithValue("@executed_date", guide.Executed_date);
cmd.Parameters.AddWithValue("@at_place", guide.At_Place);
cmd.Parameters.AddWithValue("@signature_issuing_carrier", guide.Signature_issuing_carrier);
cmd.ExecuteNonQuery();
Desconectar();
return(true);
}
else
{
Mensaje = "Error en Conexion";
return(false);
}
}
catch (Exception ex)
{
Mensaje = ex.Message;
Desconectar();
return(false);
}
}
private void btnGuardar_Click(object sender, EventArgs e)
{
N_PDF pdf = new N_PDF();
N_Guide guide1 = new N_Guide();
E_Guide guide2 = guide1.ObtenerGuide(txtGuide.Text);
if (guide2 == null)
{
MessageBox.Show("Guia no encontrada");
txtGuide.SelectAll();
txtGuide.Focus();
return;
}
N_Shipper shipper1 = new N_Shipper();
E_Shipper shipper2 = shipper1.ObtenerShipper(cbShipper.SelectedValue.ToString());
if (shipper2 == null)
{
MessageBox.Show("Exportador no encontrado");
cbShipper.Focus();
return;
}
N_Consignee consignee1 = new N_Consignee();
E_Consignee consignee2 = consignee1.ObtenerConsignee(cbConsignee.SelectedValue.ToString());
if (consignee2 == null)
{
MessageBox.Show("Consignatario no encontrada");
cbConsignee.Focus();
return;
}
N_Accounting_Info accounting1 = new N_Accounting_Info();
E_Accounting_Info accounting2 = accounting1.ObtenerAccountingInfo(cbAccountingInfo.SelectedValue.ToString());
if (accounting2 == null)
{
MessageBox.Show("Notify no encontrado");
cbAccountingInfo.Focus();
return;
}
N_Carrier_Agent agent1 = new N_Carrier_Agent();
E_Carrier_Agent agent2 = agent1.ObtenerCarrierAgent(cbCarrierAgent.SelectedValue.ToString());
if (agent2 == null)
{
MessageBox.Show("Agente no encontrado");
cbCarrierAgent.Focus();
return;
}
N_Airport salida1 = new N_Airport();
E_Airport salida2 = salida1.ObtenerAirport(cbAirportDeparture.SelectedValue.ToString());
if (salida2 == null)
{
MessageBox.Show("Aereopuerto de Salida no encontrado");
cbAirportDeparture.Focus();
return;
}
N_Airport destino1 = new N_Airport();
E_Airport destino2 = destino1.ObtenerAirport(cbAirportDestination.SelectedValue.ToString());
if (destino2 == null)
{
MessageBox.Show("Aereopuerto de Destino no encontrado");
cbAirportDestination.Focus();
return;
}
string ruta_solicitada = IsStringNullorEmpty(txtRutaSolicitada.Text);
N_Airline first1 = new N_Airline();
E_Airline first2 = first1.ObtenerAirline(cbAerolinea.SelectedValue.ToString());
N_Airport segundocarrierdestino1 = new N_Airport();
E_Airport segundocarrierdestino2 = new E_Airport();
N_Airline second1 = new N_Airline();
E_Airline second2 = new E_Airline();
if (cbSegundoCarrier.SelectedIndex > -1)
{
second2 = second1.ObtenerAirline(cbSegundoCarrier.SelectedValue.ToString());
segundocarrierdestino2 = segundocarrierdestino1.ObtenerAirport(cbSegundoCarrierDestino.SelectedValue.ToString());
}
else
{
second2.Address = "";
second2.Code = "";
second2.Fax = "";
second2.Name = "";
second2.Prefix_airline = "";
second2.Rut = "";
second2.Telephone = "";
//segundocarrierdestino2.ID = 0;
segundocarrierdestino2.City = "";
segundocarrierdestino2.Country = "";
segundocarrierdestino2.Name = "";
segundocarrierdestino2.Prefix = "";
}
N_Airport tercercarrierdestino1 = new N_Airport();
E_Airport tercercarrierdestino2 = new E_Airport();
N_Airline third1 = new N_Airline();
E_Airline third2 = new E_Airline();
if (cbTercerCarrier.SelectedIndex > -1)
{
third2 = third1.ObtenerAirline(cbTercerCarrier.SelectedValue.ToString());
tercercarrierdestino2 = tercercarrierdestino1.ObtenerAirport(cbTercerCarrierDestino.SelectedValue.ToString());
}
else
{
third2.Address = "";
third2.Code = "";
third2.Fax = "";
third2.Name = "";
third2.Prefix_airline = "";
third2.Rut = "";
third2.Telephone = "";
tercercarrierdestino2.City = "";
tercercarrierdestino2.Country = "";
tercercarrierdestino2.Name = "";
tercercarrierdestino2.Prefix = "";
}
string optional_number = IsStringNullorEmpty(txtInformacionOpcionalNumeroReferencia.Text);
string optional_info = IsStringNullorEmpty(txtInformacionOpcional.Text);
string flight_number = IsStringNullorEmpty(txtNumeroVuelo.Text);
string flight_date = dtpFechaVuelo.Value.ToString("yyyy-MM-dd");
string insurance = IsStringNullorEmpty(txtInsurance.Text);
N_Currency currency1 = new N_Currency();
E_Currency currency2 = currency1.ObtenerCurrency(cbCurrency.SelectedValue.ToString());
string CHGS_code = IsStringNullorEmpty(cbCHGS.Text);
string WT_VAL = IsStringNullorEmpty(cbWRT_VAL.Text);
string Otros = IsStringNullorEmpty(cbOtros.Text);
string declared_value_carriage = IsStringNullorEmpty(txtValorDeclaradoTransporte.Text);
string declared_value_custom = IsStringNullorEmpty(txtValorDeclaradoCustom.Text);
string handling_info = IsStringNullorEmpty(txtInformacionManejo.Text);
N_ULD uld1 = new N_ULD();
E_ULD uld2 = uld1.ObtenerULD(IsStringNullorEmpty(txtULD.Text));
if (uld2 == null)
{
MessageBox.Show("Numero ULD no encontrado");
txtULD.SelectAll();
txtULD.Focus();
return;
}
E_Product producto1 = new E_Product();
producto1 = Producto();
string nature = IsStringNullorEmpty(txtNature.Text);
string InvoicePo = IsStringNullorEmpty(txtInvoice.Text) + "|" + IsStringNullorEmpty(txtPO.Text);
string exportacion = IsStringNullorEmpty(txtExportation.Text);
producto1.Weight_Charge = TryParse(txtWeightCharge.Text);
producto1.Valuation_Charge = TryParse(txtValuationCharge.Text);
producto1.Tax = TryParse(txtTax.Text);
producto1.Total_Other_Charges_Agent = TryParse(txtTotalTOtherChargesAgent.Text);
producto1.Total_Other_Charges_Carrier = TryParse(txtTotalTOtherChargesCarrier.Text);
producto1.Total_Prepaid = TryParse(txtTotalPrepaid.Text);
producto1.Total_Collect = TryParse(txtTotalCollect.Text);
producto1.Currency_Conversion_Rate = TryParse(txtCurrencyConversionRates.Text);
producto1.CC_Charges_Dest_Currency = TryParse(txtCCChargesDestCurrency.Text);
producto1.Charges_At_Destination = TryParse(txtChargesDestination.Text);
producto1.Total_Collect_Charges = TryParse(txtTotalCollectCharges.Text);
string shipper_signature = IsStringNullorEmpty(shipper2.Name);
string executed_date = dtpExecutedDate.Value.ToString("yyyy-MM-dd");
string at_place = IsStringNullorEmpty(txtAtPlace.Text);
string signature_issuing_carrier_agent = agent2.Firma_Representante;
E_Shipment_Guide shipment1 = new E_Shipment_Guide()
{
Accounting_info = accounting2.ID.ToString(),
Aerial_guide = guide2.Aerial_guide,
Amount_insurance = insurance,
At_Place = at_place,
Carrier_Agent = agent2.ID.ToString(),
Charges_at_destination = producto1.Charges_At_Destination.ToString(),
Code_first_carrier = first2.Code,
Code_second_carrier = second2.Code,
Airport_Destination_second_carrier = segundocarrierdestino2.ID.ToString(),
Code_third_carrier = third2.Code,
Airport_Destination_third_carrier = tercercarrierdestino2.ID.ToString(),
Collect_Charges_Dest_Currency = producto1.CC_Charges_Dest_Currency.ToString(),
Consignee = consignee2.ID,
Currency = currency2.ID,
Currency_conversion_rate = producto1.Currency_Conversion_Rate.ToString(),
Declared_value_carriage = declared_value_carriage,
Declared_value_customs = declared_value_custom,
Departure_airport = salida2.ID.ToString(),
Destination_airport = destino2.ID.ToString(),
Elemento_ULD = uld2.ID.ToString(),
Executed_date = executed_date,
Gross_weight = producto1.Gross_Weight.ToString(),
Handling_information = handling_info,
Nature_Quantity_Goods = nature + "|" + InvoicePo + "|" + exportacion,
Num_Pieces = producto1.Num_Pieces.ToString(),
Optional_shipping_number = optional_number,
Optional_shipping_info = optional_info,
Other_charges_due_agent = producto1.Total_Other_Charges_Agent.ToString(),
Other_charges_due_carrier = producto1.Total_Other_Charges_Carrier.ToString(),
Payment_methods = CHGS_code,
Requested_flight_date = flight_date,
Requested_flight_num = flight_number,
Requested_routing = ruta_solicitada,
Shipper = shipper2.ID.ToString(),
Signature_issuing_carrier = signature_issuing_carrier_agent,
Signature_shipper = shipper_signature,
Tax = producto1.Tax.ToString(),
Total = producto1.Total.ToString(),
Total_collect = producto1.Total_Collect.ToString(),
Total_collect_charges = producto1.Total_Collect_Charges.ToString(),
Total_prepaid = producto1.Total_Prepaid.ToString(),
Valuation_charge = producto1.Valuation_Charge.ToString(),
Weight_charge = producto1.Weight_Charge.ToString()
};
try
{
N_Shipment_Guide shipment2 = new N_Shipment_Guide();
if (shipment2.Agregar(shipment1))
{
pdf.GenerarPDF(guide2, shipper2, consignee2, accounting2, agent2, salida2, destino2, ruta_solicitada, first2, second2, segundocarrierdestino2, third2, tercercarrierdestino2, optional_number, optional_info,
flight_number, flight_date, insurance, currency2, CHGS_code, WT_VAL, Otros, declared_value_carriage, declared_value_custom, handling_info, uld2, producto1, nature, InvoicePo, exportacion,
shipper_signature, executed_date, at_place, signature_issuing_carrier_agent);
MessageBox.Show("El archivo ha sido generado en: " + pdf.dir_final);
}
else
{
MessageBox.Show(shipment2.Mensaje);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
