public static List <MotorBD> comboMotores()
{
SqlConnection cn = null;
List <MotorBD> lista = new List <MotorBD>();
try
{
cn = new SqlConnection(cadenaConexion);
cn.Open();
string sqlText = "SELECT idMotor, nombre FROM MotoresBD";
SqlCommand cmd = new SqlCommand(sqlText, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MotorBD motor = new MotorBD();
int idMotor = dr.GetInt32(dr.GetOrdinal("idMotor"));
motor.idMotor = idMotor;
String nombre = dr.GetString(dr.GetOrdinal("nombre"));
motor.nombre = nombre;
lista.Add(motor);
}
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
finally
{
if (cn != null && cn.State == ConnectionState.Open)
{
cn.Close();
}
}
return(lista);
}
protected void gvMotores_SelectedIndexChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(gvMotores.SelectedDataKey["idMotor"].ToString());
List <MotorBD> lista = (List <MotorBD>)Session["listaBD"];
MotorBD eliminar = new MotorBD();
foreach (MotorBD motor in lista)
{
if (motor.idMotor == id)
{
eliminar = motor;
}
}
lista.Remove(eliminar);
Session["listaBD"] = lista;
gvMotores.DataSource = lista;
gvMotores.DataBind();
}
protected void btnAgregarMotores_Click(object sender, EventArgs e)
{
MotorBD motor = new MotorBD();
int idMotor = Convert.ToInt32(cbMotor.SelectedValue);
motor.idMotor = idMotor;
String nombre = cbMotor.SelectedItem.ToString();
motor.nombre = nombre;
int idNivelMotor = Convert.ToInt32(cbNivelMotor.SelectedValue);
motor.idNivel = idNivelMotor;
String nivel = cbNivelMotor.SelectedItem.ToString();
motor.nivel = nivel;
cargarGrillaMotores(motor);
}
public void cargarGrillaMotores(MotorBD motor)
{
if (Session["listaBD"] == null)
{
List <MotorBD> listaBD = new List <MotorBD>();
listaBD.Add(motor);
gvMotores.DataSource = listaBD;
gvMotores.DataBind();
Session["listaBD"] = listaBD;
}
else
{
List <MotorBD> listaBD = (List <MotorBD>)Session["listaBD"];
listaBD.Add(motor);
gvMotores.DataSource = listaBD;
gvMotores.DataBind();
Session["listaBD"] = listaBD;
}
}
public static List <MotorBD> recuperarMotores(Curriculum cv)
{
SqlConnection cn = null;
List <MotorBD> motorBD = new List <MotorBD>();
if (cv != null)
{
try
{
cn = new SqlConnection(cadenaConexion);
cn.Open();
String sql = "SELECT MC.idMotorBD, MC.idNivel, M.nombre, N.nombre nombre2 ";
sql = sql + "FROM MotoresBDXCurriculum MC, MotoresBD M, Nivel N ";
sql = sql + "WHERE M.idMotor=MC.idMotorBD AND N.idNivel=MC.idNivel AND MC.idCurriculum=" + cv.idCurriculum;
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MotorBD mb = new MotorBD();
mb.idMotor = dr.GetInt32(dr.GetOrdinal("idMotorBD"));
mb.idNivel = dr.GetInt32(dr.GetOrdinal("idNivel"));
mb.nombre = dr.GetString(dr.GetOrdinal("nombre"));
mb.nivel = dr.GetString(dr.GetOrdinal("nombre2"));
motorBD.Add(mb);
}
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
finally
{
if (cn != null && ConnectionState.Open == cn.State)
{
cn.Close();
}
}
}
return(motorBD);
}
