protected override void Mostrar(int id)
{
z_companias comp = new z_companias().getObjectz_companias(id);
textNumero.Text = comp.id_compania.ToString();
textEmail.Text = comp.email;
}
private void AdminCompania_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new z_companias().Getz_companias();
listActuales.DisplayMember = "id_compania";
listActuales.ValueMember = "id_compania";
Source = ds.Tables[0];
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
protected override void Actualizar()
{
try
{
z_companias comp = new z_companias().getObjectz_companias((int)listActuales.SelectedValue);
comp.id_compania = int.Parse(textNumero.Text);
comp.email = textEmail.Text;
comp.modifyz_companias(comp);
MessageBox.Show("Operación realizada correctamente.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
Source = comp.Getz_companias().Tables[0];
}
catch (Exception e)
{
Log.ShowAndLog(e);
}
}
protected override void Insertar()
{
try
{
var comp = new z_companias {
id_compania = int.Parse(textNumero.Text), email = textEmail.Text
};
comp.addz_companias(comp);
MessageBox.Show("Operación realizada correctamente.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
Source = comp.Getz_companias().Tables[0];
}
catch (Exception e)
{
Log.ShowAndLog(e);
}
}
private void EnviarMailForm_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new z_companias().Getz_companias();
foreach (DataRow dr in ds.Tables[0].Rows)
{
var li = new ListViewItem(Convert.ToString(dr["id_compania"]));
li.SubItems.Add(Convert.ToString(dr["email"]));
li.Checked = dr["email"] != DBNull.Value;
listCompanias.Items.Add(li);
}
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
private void CargarDatos()
{
var carro = new z_carros();
var comp = new z_companias();
listCarros.DisplayMember = "nombre";
listCarros.ValueMember = "id_carro";
//listCarros.DataSource = carro.Getz_carrosDisponibles().Tables[0];
//# Solo para Clave 0-11
listCarros.DataSource = carro.Getz_carrosDisponibles011().Tables[0];
comboCompania.DisplayMember = "id_compania";
comboCompania.ValueMember = "id_compania";
comboCompania.DataSource = comp.Getz_companias011().Tables[0];
dataGridActuales.DataSource = carro.GetCarrosCubriendo().Tables[0];
comboCompania_m.DisplayMember = "id_compania";
comboCompania_m.ValueMember = "id_compania";
comboCompania_m.DataSource = comp.Getz_companias011().Tables[0];
}
