public string updateContorTrecuti(FailedStudentsModel failed)
{
TeacherRepository up = new TeacherRepository();
string testing1 = up.updateContorTrecuti(failed);
return(testing1);
}
public string updateContorTrecuti(FailedStudentsModel failed)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string testing1 = " ";
try
{
cmd = new SqlCommand(Query.updatenr1, conn);
cmd.Parameters.Add(new SqlParameter("idMaterie", failed.idMaterie));
cmd.Parameters.Add(new SqlParameter("numar_trecuti", failed.numar));
if (cmd.ExecuteNonQuery() == 1)
{
testing1 = "Contor updated successfully";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(testing1);
}
public IHttpActionResult updateContorTrecuti([FromBody] FailedStudentsModel usr)
{
TeacherServicies us = new TeacherServicies();
us.updateContorTrecuti(usr);
return(Ok());
}
public List <FailedStudentsModel> countPassOrFailStudent(int idMaterie)
{
List <FailedStudentsModel> failedStudentsToChart = new List <FailedStudentsModel>();
//
SqlConnection conn = db.initializare();
SqlCommand cmd;
FailedStudentsModel noote = null;
try
{
cmd = new SqlCommand(Query.contorel1, conn);
cmd.Parameters.Add(new SqlParameter("idMaterie", idMaterie));
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
string numeMaterie = reader["nume_materie"].ToString();
int id_materie = Int32.Parse(reader["id_materie"].ToString());
int numar = Int32.Parse(reader["numar_picati"].ToString());
int nrTrecuti = Int32.Parse(reader["numar_trecuti"].ToString());
noote = new FailedStudentsModel(numeMaterie, numar, id_materie, nrTrecuti);
failedStudentsToChart.Add(noote);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(failedStudentsToChart);
}
