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; } }