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