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