public bool InsertarAlumno(Add_Alumno a)
{
IDbCommand dbTransation;
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@NumeroIdentificacion", a.NumeroIdentificacion);
parameters.Add("@Nombres", a.Nombres);
parameters.Add("@Apellidos", a.Apellidos);
parameters.Add("@direccion", a.direccion);
parameters.Add("@Telefono", Convert.ToInt32(a.Telefono));
using (IDbConnection db = GetConnection())
{
db.Open();
try
{
db.ExecuteScalar("colegio.Add_Alumno",
commandType: CommandType.StoredProcedure,
param: parameters);
db.Close();
return(true);
}
catch (Exception e)
{
db.Close();
return(false);
throw e;
}
}
}
public bool UpdAlumno(int IdAlumno, Add_Alumno a)
{
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@IdAlumno", IdAlumno);
parameters.Add("@Nombres", a.Nombres);
parameters.Add("@Apellidos", a.Apellidos);
parameters.Add("@direccion", a.direccion);
parameters.Add("@Telefono", a.Telefono);
using (IDbConnection db = GetConnection())
{
db.Open();
try
{
db.ExecuteScalar("colegio.upd_Alumno", commandType: CommandType.StoredProcedure, param: parameters);
db.Close();
return(true);
}
catch (Exception e)
{
db.Close();
return(false);
throw e;
}
}
}
catch (Exception e)
{
throw e;
}
}
public IActionResult InsertAlumno([FromBody] Add_Alumno a)
{
try
{
return(Ok(al.InsertarAlumno(a)));
}
catch (Exception e)
{
throw e;
}
}
//[Route("UpdAlumno")]
public IActionResult Put(int Id, [FromBody] Add_Alumno p)
{
try
{
return(Ok(al.UpdAlumno(Id, p)));
}
catch (Exception e)
{
throw e;
}
}
