public IActionResult promoteStudents(StudiesInfo studies)
{
Enrollment enrollment = new Enrollment();
using (SqlConnection con = new SqlConnection(sqlCon))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
con.Open();
com.Parameters.AddWithValue("Studies", studies.Studies);
com.Parameters.AddWithValue("Semester", studies.Semester);
var wynik = UseProcedure("PromoteStudents", com);
if (wynik[0][0].Equals("404"))
{
return(new NotFoundResult());
}
enrollment.IdEnrollment = wynik[0][0];
enrollment.IdStudy = wynik[0][2];
enrollment.Semester = wynik[0][1];
enrollment.StartDate = wynik[0][3];
}
ObjectResult objectResult = new ObjectResult(enrollment);
objectResult.StatusCode = 201;
return(objectResult);
}
public IActionResult promoteStudents(StudiesInfo studies)
{
Enrollement enrollment = new Enrollement();
using (SqlConnection con = new SqlConnection(sqlConGlobal))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
con.Open();
com.Parameters.AddWithValue("Studies", studies.Studies);
com.Parameters.AddWithValue("Semester", studies.Semester);
List <string[]> resultSet3 = new List <string[]>();
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "UPDATE Student SET Password = @password where Student.IndexNumber = @index";
SqlDataReader dr = com.ExecuteReader();
com.Parameters.AddWithValue("index", dr["IndexNumber"]);
com.Parameters.AddWithValue("password", dr["password"]);
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
dr = com.ExecuteReader();
while (dr.Read())
{
string[] tmp = new string[dr.FieldCount];
for (int i = 0; i < dr.FieldCount; i++)
{
tmp[i] = dr.GetValue(i).ToString();
}
resultSet3.Add(tmp);
}
dr.Close();
com.CommandType = CommandType.Text;
com.Parameters.Clear();
if (resultSet3[0][0].Equals("404"))
{
return(new NotFoundResult());
}
enrollment.IdEnrollment = resultSet3[0][0];
enrollment.IdStudy = resultSet3[0][2];
enrollment.Semester = resultSet3[0][1];
enrollment.StartDate = resultSet3[0][3];
}
ObjectResult objectResult = new ObjectResult(enrollment);
objectResult.StatusCode = 201;
return(objectResult);
}
public Student(
string firstName,
string lastName,
string studiesName,
string studiesMode,
string indexNumber,
string birthdate,
string email,
string mothersName,
string fathersName
)
{
IndexNumber = "s" + indexNumber;
FirstName = firstName;
LastName = lastName;
Birthdate = birthdate;
Email = email;
MothersName = mothersName;
FathersName = fathersName;
StudiesData = new StudiesInfo(studiesName, studiesMode);
}
public IActionResult PromoteSemester([FromBody] StudiesInfo studies, [FromServices] IDbService dbService)
{
return(dbService.promoteStudents(studies));
}
