public IActionResult Set(Models.CarreraMaterias model) { int result = 0; string response = ""; try { using (var db = new MySqlConnection(_connection)) { var sql = "INSERT INTO CarreraMaterias (IdCarrera, IdMateria, Peso) VALUES(@IdCarrera,@IdMateria,@Peso)"; result = db.Execute(sql, model); } if (result == 1) { response = "Se inserto correctamente la carrera"; } else { response = "No se inserto la carrera"; } } catch (Exception e) { response = e.Message; } return(Ok(response)); }
public IActionResult GetTotal(Models.CarreraMaterias model) { IEnumerable <Models.CarreraMateriasTotal> lst = null; using (var db = new MySqlConnection(_connection)) { var sql = "SELECT c.Nombre,SUM(Peso) as PesoTotal FROM CarreraMaterias cm JOIN Carreras c ON cm.IdCarrera = c.IdCarrera WHERE cm.IdCarrera = @IdCarrera;"; lst = db.Query <Models.CarreraMateriasTotal>(sql, model); } return(Ok(lst)); }
public IActionResult GetFinal(Models.CarreraMaterias model) { IEnumerable <Models.CarreraMaterias> lst = null; using (var db = new MySqlConnection(_connection)) { var sql = "SELECT IdMateria,Peso FROM CarreraMaterias WHERE IdMateria=@IdMateria AND IdCarrera=@IdCarrera;"; lst = db.Query <Models.CarreraMaterias>(sql, model); } return(Ok(lst)); }