private void txtCo_shipper_Leave(object sender, EventArgs e)
{
try
{
if (txtCo_shipper.Text.Trim().Length > 0)
{
pSeleccionarProv_Result shipper = new pSeleccionarProv_Result();
using (Profit_RGEntities context = new Profit_RGEntities())
{
shipper = context.pSeleccionarProv(txtCo_consig.Text.Trim(), txtCo_shipper.Text.Trim()).FirstOrDefault();
}
if (shipper == null)
{
txtShipper_des.Text = "NO ENCONTRADO";
}
else
{
txtShipper_des.Text = shipper.prov_des.Trim();
}
}
}
catch (DataException ex0)
{
MessageBox.Show(ex0.InnerException.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void txtCo_prov_Leave(object sender, EventArgs e)
{
try
{
pSeleccionarProv_Result shipper = new pSeleccionarProv_Result();
using (Profit_RGEntities context = new Profit_RGEntities())
{
shipper = context.pSeleccionarProv(txtEmpresa.Text.Trim()).Where(s => s.co_prov == txtCo_prov.Text.Trim()).First();
}
if (shipper == null)
{
txtProv_des.Text = "NO ENCONTRADO";
}
else
{
txtProv_des.Text = shipper.prov_des.Trim();
}
}
catch (EntityException ex)
{
MessageBox.Show(ex.InnerException.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}