public string createAGrade(insertGrade grade)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string mesaj = " ";
try
{
cmd = new SqlCommand("gradeManagement", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("idSpecializare", specializare.idSpecializare));
cmd.Parameters.Add(new SqlParameter("@nota", grade.nota));
cmd.Parameters.Add(new SqlParameter("@id_utilizator", grade.idUtilizator));
cmd.Parameters.Add(new SqlParameter("@id_materie", grade.idMaterie));
cmd.Parameters.Add(new SqlParameter("@semestru", grade.semestru));
cmd.Parameters.Add(new SqlParameter("@an_studiu", grade.anStudiu));
if (cmd.ExecuteNonQuery() == 1)
{
mesaj = "Cont creat cu succes";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(mesaj);
}
public string createAGrade(insertGrade grade)
{
TeacherRepository spec = new TeacherRepository();
string mesaj = spec.createAGrade(grade);
return(mesaj);
}
public IHttpActionResult createAgrade([FromBody] insertGrade grade)
{
TeacherServicies spec = new TeacherServicies();
spec.createAGrade(grade);
return(Ok());
}
