public IActionResult PromoteStudent(PromoteStudentRequest request)
{
PromoteStudentResponse response;
using (var con = new SqlConnection(ConString))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var tran = con.BeginTransaction();
com.Transaction = tran;
try
{
com.CommandText = "exec PromoteStudents @studies, @semester ";
com.Parameters.AddWithValue("studies", request.Studies);
com.Parameters.AddWithValue("semester", request.Semester);
var dr = com.ExecuteReader();
response = new PromoteStudentResponse()
{
Name = request.Studies,
Semester = request.Semester + 1
};
return(Ok(response));
}catch (SqlException exc)
{
return(BadRequest("nie dziala"));
}
}
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
var study = _context.Studies.FirstOrDefault(s => s.Name == request.Name);
if (study == null)
{
throw new Exception("There is no such study");
}
var idStudy = _context.Studies.FirstOrDefault(s => s.Name == request.Name).IdStudy;
var enrollment = _context.Enrollment.FirstOrDefault(en => en.Semester == request.Semester && en.IdStudy == idStudy);
if (enrollment == null)
{
throw new Exception("there are no students to promote");
}
var res = _context.Enrollment.Where(enr => enr.Semester == request.Semester).ToList();
res.ForEach(e =>
{
e.Semester = request.Semester + 1;
});
var response = new PromoteStudentResponse()
{
Semester = request.Semester + 1,
Name = request.Name
};
_context.SaveChanges();
return(response);
}
public IActionResult PromoteStudent(PromoteStudentResponse response)
{
PromoteStudentResponse result = new PromoteStudentResponse();
using (var con = new SqlConnection("[Data Source=db-mssql;Initial Catalog=s19183;Integrated Security=True]"))
{
using (var com = new SqlCommand())
{
com.Connection = con;
com.Parameters.AddWithValue("Semester", response.Semester);
com.Parameters.AddWithValue("Studies", response.Studies);
com.CommandText = "SELECT * FROM Enrollment e JOIN Studies s ON e.IdStudy=s.IdStudy WHERE e.Semester = @Semester AND s.Name=@Studies; ";
con.Open();
var transaction = con.BeginTransaction();
com.Transaction = transaction;
var dr = com.ExecuteReader();
if (dr.Read())
{
dr.Close();
com.CommandText = "MyProcedure";
com.CommandType = System.Data.CommandType.StoredProcedure;
com.ExecuteNonQuery();
result.Studies = response.Studies;
result.Semester = response.Semester + 1;
return(Ok(result));
}
else
{
return(BadRequest("Error"));
}
}
}
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = null;
using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s18963;Integrated Security=True"))
{
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
con.Open();
com.CommandText = "PromoteStudent";
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("Name", request.Name);
com.Parameters.AddWithValue("Semester", request.Semester);
var dr = com.ExecuteReader();
if (dr.Read())
{
dr.Close();
request.Name = dr["Name"].ToString();
request.Semester = (int)dr["Semester"];
dr = com.ExecuteReader();
dr.Read();
response = new PromoteStudentResponse();
response.Name = dr["Name"].ToString();
response.Semester = (int)dr["Semester"];
dr.Close();
}
}
return(response);
}
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
_service.PromoteStudents(request);
var response = new PromoteStudentResponse();
return(Ok(response));
}
public IActionResult PromoteStudents(PromoteStudentRequest preq)
{
PromoteStudentResponse pres = new PromoteStudentResponse();
pres = _dbService.PromoteStudent(preq);
return(Created("promote", pres));
}
public PromoteStudentResponse PromoteStudent(PromoteStudentRequest request)
{
var enroll = db.Studies.Join(db.Enrollment,
s => s.IdStudy,
en => en.IdStudy,
(s, e) => new { e, s.Name, s.IdStudy })
.Where(t => t.Name == request.Studies && t.e.Semester == request.Semester).First();
if (enroll != null)
{
var tmp = db.Enrollment.Where(e => e.IdStudy == enroll.IdStudy && e.Semester == enroll.e.Semester);
foreach (var t in tmp)
{
t.Semester = t.Semester + 1;
}
db.SaveChanges();
PromoteStudentResponse response = new PromoteStudentResponse
{
IdEnrollment = enroll.e.IdEnrollment,
Semester = enroll.e.Semester,
Study = enroll.Name,
StartDate = enroll.e.StartDate
};
return(response);
}
else
{
return(null);
}
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = new PromoteStudentResponse();
List <Student> stud = new List <Student>();
var studies = _dbContext.Studies
.Where(s => s.Name.Equals(request.Studies))
.Single();
var OldEnrollment = _dbContext.Enrollment
.Where(e => e.IdStudy == studies.IdStudy && e.Semester == request.Semester)
.Single();
var enrollment = _dbContext.Enrollment
.Where(e => e.IdStudy == studies.IdStudy && e.Semester == request.Semester + 1)
.SingleOrDefault();
int idEnrollment;
if (enrollment == null)
{
idEnrollment = _dbContext.Enrollment.Count() + 1;
var e = new Enrollment
{
IdEnrollment = idEnrollment,
Semester = request.Semester + 1,
IdStudy = studies.IdStudy,
StartDate = DateTime.Now
};
_dbContext.Enrollment.Add(e);
_dbContext.SaveChanges();
}
else
{
idEnrollment = enrollment.IdEnrollment;
}
var students = _dbContext.Student
.Where(s => s.IdEnrollment == OldEnrollment.IdEnrollment)
.ToList();
foreach (Student s in students)
{
s.IdEnrollment = idEnrollment;
_dbContext.SaveChanges();
var s1 = new Student
{
IndexNumber = s.IndexNumber,
FirstName = s.FirstName,
LastName = s.LastName,
BirthDate = s.BirthDate,
IdEnrollment = idEnrollment,
};
stud.Add(s1);
}
response.students = stud;
return(response);
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = new PromoteStudentResponse();
using (SqlConnection connectionSql = new SqlConnection(ConString))
using (var sqlCommand = new SqlCommand("PromoteStudents", connectionSql))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Studies", request.Studies);
sqlCommand.Parameters.AddWithValue("@semester", request.Semester);
connectionSql.Open();
sqlCommand.ExecuteNonQuery();
connectionSql.Close();
response.dtoResponse = "Done";
SqlCommand command = new SqlCommand();
command.Connection = connectionSql;
connectionSql.Open();
int newSemester = request.Semester + 1;
command.CommandText = "SELECT IdStudy FROM Studies where Name=@name";
command.Parameters.AddWithValue("name", request.Studies);
var idStudies = command.ExecuteReader();
if (!idStudies.Read())
{
response.dtoResponse = "Podanych studia nie istnieją";
return(response);
}
int idstudies = (int)idStudies["IdStudy"];
idStudies.Close();
Enrollment enrollment = new Enrollment();
command.CommandText = "SELECT idEnrollment,idStudy,Semester,StartDate FROM Enrollment WHERE idStudy=@idStudy AND Semester=@Semester";
command.Parameters.AddWithValue("idStudy", idstudies);
command.Parameters.AddWithValue("Semester", newSemester);
var newEnrollSemester = command.ExecuteReader();
if (newEnrollSemester.Read())
{
enrollment.IdEnrollment = (int)newEnrollSemester["IdEnrollment"];
enrollment.IdStudy = (int)newEnrollSemester["IdStudy"];
enrollment.Semester = (int)newEnrollSemester["Semester"];
enrollment.StartDate = (String)newEnrollSemester["StartDate"];
}
newEnrollSemester.Close();
response.enrollment = enrollment;
return(response);
}
}
public PromoteStudentResponse PromoteStudent(PromoteStudentRequest promotion)
{
using (var connection = new SqlConnection("Data Source=db-mssql;Initial Catalog=s18589;Integrated Security=true"))
using (var command = new SqlCommand())
{
connection.Open();
command.Connection = connection;
var transaction = connection.BeginTransaction();
command.Transaction = transaction;
Console.WriteLine(promotion.Studies);
command.Parameters.AddWithValue("name", promotion.Studies);
command.Parameters.AddWithValue("semester", promotion.Semester);
command.CommandText = "select * from enrollment inner join studies on enrollment.idstudy = studies.idstudy where studies.name = @name and enrollment.semester = @semester";
var dr = command.ExecuteReader();
command.Parameters.Clear();
if (!dr.HasRows)
{
dr.Close();
transaction.Rollback();
throw new Exception("query failed");
}
dr.Close();
command.Parameters.AddWithValue("name", promotion.Studies);
command.Parameters.AddWithValue("semester", promotion.Semester);
command.CommandText = "exec promotion @name,@semester";
command.ExecuteNonQuery();
command.CommandText = "select * from enrollment inner join studies on enrollment.idstudy = studies.idstudy where studies.name = @name and enrollment.semester = @semester+1";
dr = command.ExecuteReader();
if (!dr.HasRows)
{
dr.Close();
transaction.Rollback();
throw new Exception("no promoted students");
}
dr.Read();
PromoteStudentResponse response = new PromoteStudentResponse
{
IdEnrollment = int.Parse(dr["IdEnrollment"].ToString()),
Semester = int.Parse(dr["Semester"].ToString()),
IdStudy = int.Parse(dr["IdStudy"].ToString()),
StartDate = DateTime.Parse(dr["StartDate"].ToString())
};
dr.Close();
transaction.Commit();
return(response);
}
}
public IActionResult AddRecept(ReceptRequest request)
{
PromoteStudentResponse result = _service.AddRecept(request);
if (result != null)
{
return(Ok(result));
}
return(BadRequest(400));
}
public IActionResult PromoteStudents(PromoteStudentRequest promoteStudentRequest)
{
PromoteStudentResponse promoteStudentResponse = _db.PromoteStudents(promoteStudentRequest);
if (promoteStudentResponse == null)
{
return(NotFound());
}
return(this.StatusCode(201, promoteStudentResponse));
}
public async Task <IActionResult> PromoteStudents(PromoteStudentRequest promoteStudentRequest)
{
PromoteStudentResponse promoteStudentResponse = await _db.PromoteStudentsAsync(promoteStudentRequest);
if (promoteStudentResponse == null)
{
return(NotFound());
}
return(this.StatusCode(201, promoteStudentResponse));
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse promoteResp = dbService.PromoteStudents(request);
if (promoteResp == null)
{
return(BadRequest());
}
return(this.StatusCode(201, promoteResp));
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = null;
try
{
response = studentDbService.PromoteStudents(request);
}
catch (SqlException ex)
{}
return(Created("PromoteStudent", response));
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
var response = new PromoteStudentResponse();
DateTime date = DateTime.Today;
int success;
const string ConString = "Data Source=db-mssql;Initial Catalog=s18985;Integrated Security=True";
using (var con = new SqlConnection(ConString))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var tran = con.BeginTransaction();
com.CommandText = "execute PromoteStudent @study, @semester";
com.Parameters.AddWithValue("study", request.Studies);
com.Parameters.AddWithValue("semester", request.Semester);
com.Transaction = tran;
success = com.ExecuteNonQuery();
var nextSemestr = request.Semester + 1;
com.CommandText = "select IdEnrollment from enrollment where semester = @nextSemester and idstudy = (select idstudy from studies where name = @study)";
com.Parameters.AddWithValue("nextSemester", nextSemestr);
com.Transaction = tran;
var dr = com.ExecuteScalar();
response.IdEnrollment = (int)dr;
com.CommandText = "select StartDate from enrollment where semester = @nextSemester and idstudy = (select idstudy from studies where name = @study)";
com.Transaction = tran;
dr = com.ExecuteScalar();
response.StartDate = (DateTime)dr;
tran.Commit();
response.Studies = request.Studies;
response.Semester = request.Semester + 1;
if (success > 0)
{
return(response);
return(response);
}
else
{
return(null);
}
}
}
public async Task <IActionResult> PromoteStudents(PromoteStudentRequest request)
{
await _dbService.PromoteStudents(request);
var response = new PromoteStudentResponse()
{
Semester = Convert.ToInt32(request.Semester) + 1,
StudiesName = request.StudiesName
};
return(Ok(response));
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest promoteStudentRequest)
{
using (var conn = new SqlConnection(connString))
{
conn.Open();
var transaction = conn.BeginTransaction();
using (var comm = new SqlCommand())
{
comm.CommandText = @"select * from
Enrollment a inner join Studies b
On a.IdStudy=b.IdStudy
And b.Name=@Name
AND a.Semester=@Semester";
comm.Parameters.AddWithValue("@Name", promoteStudentRequest.Studies);
comm.Parameters.AddWithValue("@Semester", promoteStudentRequest.Semester);
comm.Connection = conn;
comm.Transaction = transaction;
using (var reader = comm.ExecuteReader())
{
if (!reader.Read())
{
reader.Close();
transaction.Rollback();
return(null);
}
}
}
using (var comm1 = new SqlCommand("promoteStudent", conn))
{
comm1.CommandType = System.Data.CommandType.StoredProcedure;
comm1.CommandText = "PromoteStudent";
comm1.Parameters.AddWithValue("@studiesGiven", promoteStudentRequest.Studies);
comm1.Parameters.AddWithValue("@semesterGiven", promoteStudentRequest.Semester);
comm1.Connection = conn;
comm1.Transaction = transaction;
using (var reader = comm1.ExecuteReader())
{
reader.Read();
PromoteStudentResponse promoteStudentResponse = new PromoteStudentResponse
{
IdEnrollment = int.Parse(reader["IdEnrollment"].ToString()),
Semester = int.Parse(reader["Semester"].ToString()),
IdStudy = int.Parse(reader["IdStudy"].ToString()),
StartDate = DateTime.Parse(reader["StartDate"].ToString())
};
reader.Close();
transaction.Commit();
return(promoteStudentResponse);
}
}
}
}
public PromoteStudentResponse PromoteStudents(int semester, string studies)
{
PromoteStudentResponse promote = new PromoteStudentResponse();
promote.Studies = studies;
promote.Semester = semester;
using (var con = new SqlConnection(sqlConnection))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var tran = con.BeginTransaction();
com.Transaction = tran;
//Czy wpisy sa poprawne
com.CommandText = "select * from Enrollment INNER JOIN Studies ON Enrollment.IdStudy=Studies.IdStudy where Enrollment.Semester=@semester OR Studies.Name=@name";
com.Parameters.AddWithValue("semester", semester);
com.Parameters.AddWithValue("name", studies);
var dr = com.ExecuteReader();
if (!dr.Read())
{
promote.Info = "400 Wpisz prawidlowa nazwe studiow";
dr.Close();
tran.Rollback();
}
int idStudy = (int)dr["IdStudy"];
int nrSemester = (int)dr["semester"];
int newSemester = nrSemester + 1;
dr.Close();
//Jezeli wpisy poprawne, aktualizuj semestr studentow
try
{
com.CommandText = "update Enrollment set Semester=@newSemester where IdStudy=@idStudy and Semester=@nrSemester";
com.Parameters.AddWithValue("newSemester", newSemester);
com.Parameters.AddWithValue("nrSemester", nrSemester);
com.Parameters.AddWithValue("idStudy", idStudy);
com.ExecuteNonQuery();
tran.Commit();
promote.Info = "201 Semestr zmieniony";
}
catch (SqlException e)
{
promote.Info = "400 Blad podczad aktualizacji semestru" + e;
tran.Rollback();
}
}
return(promote);
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = _service.PromoteStudent(request);
if (response == null)
{
return(StatusCode(401, BadRequest("blad 401")));
}
else
{
return(StatusCode(201, response));
}
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = dbService.PromoteStudent(request);
if (response == null)
{
return(NotFound("Wrong data was passed"));
}
else
{
return(StatusCode(201, response));
}
}
public async Task <IActionResult> PromoteStudents(PromoteStudentRequest req)
{
PromoteStudentResponse resp = await _service.PromoteStudents(req);
if (resp == null)
{
return(BadRequest());
}
else
{
return(this.StatusCode(201, resp));
}
}
public IActionResult PromoteStudents(PromoteStudentRequest request)
{
PromoteStudentResponse response = null;
try
{
response = _studentDbService.PromoteStudents(request);
}
catch (SqlException sqlex)
{
WriteLine(sqlex.Message);
}
return(Created("PromoteStudent", response));
}
public PromoteStudentResponse PromoteStudents(int semester, string studies)
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
int idStudy = _dbContext.Studies
.Where(st => st.Name == studies)
.Select(st => st.IdStudy).SingleOrDefault();
PartialModels.Enrollment enrollment = _dbContext.Enrollment.FirstOrDefault(e => e.IdStudy == idStudy && e.Semester == semester);
if (enrollment == null)
{
return(null);
}
int oldIdEnrollment = enrollment.IdEnrollment;
enrollment = _dbContext.Enrollment.FirstOrDefault(e => e.IdStudy == idStudy && e.Semester == semester + 1);
if (enrollment == null)
{
int maxId = _dbContext.Enrollment.Max(e => e.IdEnrollment);
enrollment = new PartialModels.Enrollment();
enrollment.IdEnrollment = maxId + 1;
enrollment.Semester = semester + 1;
enrollment.IdStudy = idStudy;
enrollment.StartDate = DateTime.Now;
_dbContext.Enrollment.Add(enrollment);
_dbContext.SaveChanges();
}
var students = _dbContext.Student.Where(s => s.IdEnrollment == oldIdEnrollment).ToList();
foreach (Student student in students)
{
student.IdEnrollment = enrollment.IdEnrollment;
}
_dbContext.SaveChanges();
transaction.Commit();
var response = new PromoteStudentResponse()
{
Study = studies,
NewIdStudy = enrollment.IdStudy,
NewSemester = enrollment.Semester
};
return(response);
}
}
public PromoteStudentResponse PromoteStudents(PromoteStudentRequest request)
{
var response = new PromoteStudentResponse();
using var con = new SqlConnection(SetConnection.GetConnection());
using var com = new SqlCommand();
con.Open();
com.Connection = con;
var transaction = con.BeginTransaction();
com.Transaction = transaction;
com.CommandText = "SELECT enr.IdEnrollment from Enrollment enr INNER JOIN Studies st on enr.IdStudy = st.IdStudy WHERE st.Name = @Name and enr.Semester = @Semester";
com.Parameters.AddWithValue("Name", request.Name);
com.Parameters.AddWithValue("Semester", request.Semester);
var dr = com.ExecuteReader();
if (!dr.Read())
{
dr.Close();
throw new Exception("Nie znalezono semestru i/lub studiów");
}
else
{
dr.Close();
using (SqlConnection conn = new SqlConnection(SetConnection.GetConnection()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("PromoteStudents", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Name", request.Name));
cmd.Parameters.Add(new SqlParameter("@Semester", request.Semester));
cmd.ExecuteReader();
conn.Close();
}
response.Semester = request.Semester + 1;
response.StartDate = DateTime.Now.ToString("dd.MM.yyyy");
response.StudiesName = request.Name;
transaction.Commit();
}
return(response);
}
public IEnumerable <PromoteStudentResponse> PromoteStudent(PromoteStudentRequest promoteStudentRequest)
{
var responsesList = new List <PromoteStudentResponse>();
//SELECTY
//Kierunek o podanym skrócie
var study = _context.Studies.Single(s => s.Name == promoteStudentRequest.Name);
//Wpis dla podanego kierunku na konkretny semstr
var enrollment = _context.Enrollment.Single(e => e.Semester == promoteStudentRequest.Semester && e.IdStudy == study.IdStudy);
//Wpis dla podanego kierunku na następny semestr
var newEnrollment = _context.Enrollment.Single(e => e.Semester == promoteStudentRequest.Semester + 1 && e.IdStudy == study.IdStudy);
//Ostatnie ID + 1
var newIdEnrollment = _context.Enrollment.Max(e => e.IdEnrollment) + 1;
if (newEnrollment == null)
{
_context.Enrollment.Add(new Enrollment
{
IdEnrollment = newIdEnrollment,
Semester = promoteStudentRequest.Semester + 1,
IdStudy = study.IdStudy,
StartDate = DateTime.Now
});
newEnrollment = _context.Enrollment.Single(e => e.Semester == promoteStudentRequest.Semester + 1 && e.IdStudy == study.IdStudy);
}
var students = _context.Student.Where(student => student.IdEnrollment == enrollment.IdEnrollment).ToList();
foreach (var student in students)
{
student.IdEnrollment = newEnrollment.IdEnrollment;
}
var promoteStudentResponse = new PromoteStudentResponse
{
IdEnrollment = newEnrollment.IdEnrollment,
Semester = promoteStudentRequest.Semester + 1,
IdStudy = study.IdStudy,
StartDate = DateTime.Now
};
responsesList.Add(promoteStudentResponse);
return(responsesList);
}
public PromoteStudentResponse PromoteStudent(PromoteStudentRequest request)
{
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
try
{
com.Connection = con;
com.CommandText = "select * from Enrollment inner join Studies on Enrollment.IdStudy=Study.IdStudy where Name=@StudyName and Semester=@Semester";
com.Parameters.AddWithValue("@StudiesName", request.Studies);
com.Parameters.AddWithValue("@Semester", request.Semester);
con.Open();
var dr = com.ExecuteReader();
if (!dr.Read())
{
return(null);
}
dr.Close();
com.Parameters.Clear();
com.CommandText = "PromoteStudents";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Studies", request.Studies);
com.Parameters.AddWithValue("@Semester", request.Semester);
dr = com.ExecuteReader();
if (dr.Read())
{
PromoteStudentResponse response = new PromoteStudentResponse();
response.IdEnrollment = int.Parse(dr["IdEnrollment"].ToString());
response.Semester = int.Parse(dr["Semester"].ToString());
response.Studies = dr["Name"].ToString();
response.StartDate = DateTime.Parse(dr["StartDate"].ToString());
dr.Close();
return(response);
}
else
{
return(null);
}
}
catch (SqlException ex)
{
return(null);
}
}
}
public PromoteStudentResponse PromoteStudent(PromoteStudentRequest psrequest)
{
using (SqlConnection con = new SqlConnection("Data Source = db - mssql; Initial Catalog = s18793; Integrated Security = True"))
using (SqlCommand com = new SqlCommand())
using (var tran = con.BeginTransaction())
{
PromoteStudentResponse response = new PromoteStudentResponse();
con.Open();
com.Connection = con;
com.Transaction = tran;
try
{
com.CommandText = "exec PromoteStudents @name, @semester";
com.Parameters.AddWithValue("semester", psrequest.Semester);
com.Parameters.AddWithValue("name", psrequest.Name);
com.ExecuteNonQuery();
com.CommandText = "SELECT * FROM Enrollment e INNER JOIN Studies stud ON stud.idstudy = e.idstudy WHERE e.semester = Semest AND stud.name = stName";
com.Parameters.AddWithValue("stName", psrequest.Name);
com.Parameters.AddWithValue("Semest", psrequest.Semester);
var dr = com.ExecuteReader();
if (!dr.Read())
{
dr.Close();
tran.Rollback();
}
else
{
response.IdEnrollment = (int)dr["IdEnrollment"];
response.IdStudy = dr["IdStudy"].ToString();
response.Semester = dr["Semester"].ToString();
response.StartDate = (DateTime)dr["StartDate"];
}
}
catch (SqlException e)
{
tran.Rollback();
}
return(response);
}
}
public void PromoteStudents(PromoteStudentRequest request)
{
string connstring =
"Data Source=10.1.1.36,1433;Initial Catalog=s18588;User ID=apbds18588;Password=admin";
var response = new PromoteStudentResponse();
var cl = new HttpClient();
cl.BaseAddress = new Uri("http://*****:*****@Studies and Semester = @Semester";
com.Parameters.AddWithValue("Studies", IdStudies);
com.Parameters.AddWithValue("Semester", request.Semester);
var dr = com.ExecuteReader();
com.Parameters.Clear();
if (dr.Read())
{
dr.Close();
com.CommandText = "update Enrollment set Semester = @SemesterNo where IdStudy = @Studies and Semester = @Semester";
com.Parameters.AddWithValue("Studies", IdStudies);
com.Parameters.AddWithValue("Semester", (int)request.Semester);
com.Parameters.AddWithValue("SemesterNo", request.Semester + 1);
com.ExecuteNonQuery();
response.Studies = request.Studies;
response.Semester = request.Semester + 1;
Console.WriteLine("Ok");
}
}
}
public IActionResult PromoteStudents(PromoteStudentsRequest request)
{
int changedEnrollment = 0;
var promoteStudnetResponse = new PromoteStudentResponse();
using (var connection = new SqlConnection(
"Data Source=db-mssql.pjwstk.edu.pl;Initial Catalog=s18711;Integrated Security=True"))
using (var command = new SqlCommand("dbo.Promote", connection))
using (var command2 = new SqlCommand())
{
command2.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@StudiesName", SqlDbType.VarChar, 100);
command.Parameters.Add("@Semester", SqlDbType.Int);
command.Parameters.Add("@myOut", SqlDbType.Int).Direction = ParameterDirection.Output;
command.Parameters["@StudiesName"].Value = request.Studies;
command.Parameters["@Semester"].Value = request.Semester;
connection.Open();
command.ExecuteNonQuery();
changedEnrollment = Convert.ToInt32(command.Parameters["@myOut"].Value);
command2.CommandText = "SELECT * FROM Enrollment WHERE IdEnrollment = @IdE";
command2.Parameters.AddWithValue("IdE", changedEnrollment);
var dataReader = command2.ExecuteReader();
if (dataReader.Read())
{
promoteStudnetResponse.IdEnrollment = int.Parse(dataReader["IdEnrollment"].ToString());
promoteStudnetResponse.IdStudies = int.Parse(dataReader["IdStudy"].ToString());
promoteStudnetResponse.Semester = int.Parse(dataReader["Semester"].ToString());
}
}
return(CreatedAtAction("PromoteStudents", promoteStudnetResponse));
}