public ABMMicro(Micro microAModificar)
{
micro = new Micro();
micro = microAModificar;
esModificacion = true;
InitializeComponent();
cargarDropDowns();
agregarButacas.Visible = false;
cargarValoresMicro();
}
public ABMMicro()
{
InitializeComponent();
micro = new Micro();
esModificacion = false;
cargarDropDowns();
//if (esModificacion) { cargarValoresMicro(); };
}
/// <summary>
/// Recupera un micro determinado dado su id
/// </summary>
/// <param name="idMicro">Id del Micro Buscado</param>
public static Micro BuscarMicroPorId(int idMicro)
{
Micro micro = new Micro();
String query = "select MIC_numMicro as 'ID', " +
"MIC_patente as 'Matricula', " +
"MIC_idTipoServicio as 'Tipo de Serv.', " +
"MIC_kilosEncomiendas as 'Capacidad', " +
"MIC_habilitado as 'Habilitado', " +
"MIC_idMarca as 'Marca', " +
"MIC_idModelo as 'Modelo', " +
"MIC_fechaAlta as 'Fec. Alta', " +
"MIC_fecBaja as 'Fec. Baja definitiva' " +
"from NOT_NULL.Micro where " +
"MIC_numMicro = " + Convert.ToString(idMicro);
DataTable dt = Conector.Datos.EjecutarComandoADataTable(query);
var row = dt.Rows[0];
micro.Id = Convert.ToInt16(row["ID"].ToString());
micro.Patente = (row["Matricula"].ToString());
micro.IdTipoDeServicio = Convert.ToInt16(row["Tipo de Serv."].ToString());
micro.KilosEncomiendas = Convert.ToDecimal(row["Capacidad"].ToString());
micro.Habilitado = Convert.ToBoolean(row["Habilitado"].ToString());
micro.IdMarca = Convert.ToInt16(row["Marca"].ToString());
micro.IdModelo = Convert.ToInt16(row["Modelo"].ToString());
micro.FechaAlta = Convert.ToDateTime(row["Fec. Alta"].ToString());
micro.Butacas = Orm.Butaca.TraerButacasPorMicro(micro.Id);
return micro;
}
