public string createExam(insertModel exam)
{
TeacherRepository spec = new TeacherRepository();
string mesaj = spec.createExam(exam);
return(mesaj);
}
public IHttpActionResult createExam([FromBody] insertModel exam)
{
TeacherServicies spec = new TeacherServicies();
spec.createExam(exam);
return(Ok());
}
public string createExam(insertModel exam)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string mesaj = " ";
try
{
cmd = new SqlCommand(Query.insertExam, conn);
//cmd.Parameters.Add(new SqlParameter("idSpecializare", specializare.idSpecializare));
cmd.Parameters.Add(new SqlParameter("@idSpecializare", exam.idSpecializare));
cmd.Parameters.Add(new SqlParameter("@idMaterie", exam.idMaterie));
cmd.Parameters.Add(new SqlParameter("@idUtilizator", exam.idUtilizator));
cmd.Parameters.Add(new SqlParameter("@data", exam.data));
cmd.Parameters.Add(new SqlParameter("@timp", exam.timp));
cmd.Parameters.Add(new SqlParameter("@oraExamen", exam.oraExamen));
cmd.Parameters.Add(new SqlParameter("@anStudiu", exam.anStudiu));
if (cmd.ExecuteNonQuery() == 1)
{
mesaj = "Examen creat cu succes";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(mesaj);
}
