public List <AlumnoCE> ObtenerAlumno()
{
List <AlumnoCE> lista = new List <AlumnoCE>();
try
{
con.Open();
string sql = "select * from alumno";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
AlumnoCE Alum = new AlumnoCE();
Alum = new AlumnoCE();
Alum.AluId = reader.GetInt32(0);
Alum.ALuNom = reader.GetString(1);
Alum.AluApe = reader.GetString(2);
Alum.AluDni = reader.GetString(3);
Alum.AluEdad = reader.GetInt32(4);
lista.Add(Alum);
}
reader.Close();
}
catch (Exception e)
{
lista = null;
}
return(lista);
}
public bool InsertarAlumno(AlumnoCE Alumno)
{
con.Open();
string sql = "insert into alumno values (@aluNom,@aluApe,@AluDni,@AluEdad)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@aluNom", System.Data.SqlDbType.VarChar).Value = Alumno.ALuNom;
cmd.Parameters.Add("@aluApe", System.Data.SqlDbType.VarChar).Value = Alumno.AluApe;
cmd.Parameters.Add("@AluDni", System.Data.SqlDbType.VarChar).Value = Alumno.AluDni;
cmd.Parameters.Add("@AluEdad", System.Data.SqlDbType.Int).Value = Alumno.AluEdad;
int res = cmd.ExecuteNonQuery();
con.Close();
return(res == 1);
}
public bool ActualizarAlumno(AlumnoCE cli)
{
con.Open();
string sql = "update alumno set AluNom=@AluNom, AluApe=@AluApe, AluDni=@AluDni,AluEdad=@AluEdad where Aluid=@Aluid";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@AluNom", System.Data.SqlDbType.VarChar).Value = cli.ALuNom;
cmd.Parameters.Add("@AluApe", System.Data.SqlDbType.VarChar).Value = cli.AluApe;
cmd.Parameters.Add("@AluDni", System.Data.SqlDbType.VarChar).Value = cli.AluDni;
cmd.Parameters.Add("@AluEdad", System.Data.SqlDbType.VarChar).Value = cli.AluEdad;
cmd.Parameters.Add("@Aluid", System.Data.SqlDbType.Int).Value = cli.AluId;
int res = cmd.ExecuteNonQuery();
con.Close();
return(res == 1);
}
public JsonResult Alumno(int?id, AlumnoCE item)
{
switch (Request.HttpMethod)
{
case "POST":
// true o false
return(Json(ObjAlum.InsertarAlumno(item)));
case "PUT":
//retorna tru o false
return(Json(ObjAlum.ActualizarAlumno(item)));
case "GET":
//http: //localhost:2088/Api/Clientes/Cliente/1 ACTION GET
return(Json(ObjAlum.ObtenerAlumnoId(id.GetValueOrDefault()), JsonRequestBehavior.AllowGet));
case "DELETE":
return(Json(ObjAlum.EliminarAlumno(id.GetValueOrDefault())));
}
return(Json(new { Error = true, Message = "Operacion Http desconocida" }));
}
public AlumnoCE ObtenerCAlumnoId(int id)
{
AlumnoCE Alum = null;
//SqlConnection con = new SqlConnection(cadenaConexion);
con.Open();
string sql = "select * from alumno where aluId=@aluId";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@aluId", System.Data.SqlDbType.NVarChar).Value = id;
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
if (reader.Read())
{
Alum = new AlumnoCE();
Alum.AluId = id;
Alum.ALuNom = reader.GetString(1);
Alum.AluApe = reader.GetString(2);
Alum.AluDni = reader.GetString(3);
Alum.AluEdad = reader.GetInt32(4);
}
reader.Close();
return(Alum);
}
public bool ActualizarAlumno(AlumnoCE cli)
{
return(ObjaLUM.ActualizarAlumno(cli));
}
public bool InsertarAlumno(AlumnoCE objAlumn)
{
return(ObjaLUM.InsertarAlumno(objAlumn));
}
