public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var students = new List <Student>();
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "select firstname, lastname, birthdate, name, semester from student, enrollment, studies where student.idenrollment = enrollment.idenrollment and studies.idstudy = enrollment.idstudy";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new Student();
st.FirstName = dr["FirstName"].ToString();
st.LastName = dr["LastName"].ToString();
st.BirthDate = dr["BirthDate"].ToString();
st.Enrollment = new Enrollment
{
Semester = (int)(dr["Semester"]),
study = new Studies {
Name = dr["Name"].ToString()
}
};
students.Add(st);
}
con.Dispose();
}
return(Ok(students));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var list = new List <StudentInfoDTO>();
using (SqlConnection sqlConnection = new SqlConnection(ConnString))
using (SqlCommand command = new SqlCommand())
{
command.Connection = sqlConnection;
command.CommandText = "select s.FirstName, s.LastName, s.BirthDate, st.Name, e.Semester from Student s join Enrollment e on e.IdEnrollment = s.IdEnrollment join Studies st on st.IdStudy = e.IdStudy";
sqlConnection.Open();
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
var st = new StudentInfoDTO
{
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
BirthDate = dr["BirthDate"].ToString(),
Name = dr["Name"].ToString(),
Semester = dr["Semester"].ToString()
};
list.Add(st);
}
}
return(Ok(list));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var list = new List <Student>();
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "SELECT * FROM Student";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new Student();
st.IndexNumber = dr["IndexNumber"].ToString();
st.FirstName = dr["FirstName"].ToString();
st.LastName = dr["LastName"].ToString();
st.BirthDate = DateTime.Parse(dr["BirthDate"].ToString());
st.IdEnrollment = Int32.Parse(dr["IdEnrollment"].ToString());
list.Add(st);
}
}
return(Ok(list));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var list = new List <Student>();
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "select * from dbo.students";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new Student();
st.IndexNumber = dr["IndexNumber"].ToString();
st.FirstName = dr["FirsName"].ToString();
st.LastName = dr["LastName"].ToString();
list.Add(st);
}
}
return(Ok(list));
}
public IActionResult getStudents([FromServices] IStudentsDal dbService)
{
var list = new List <Student>();
using (SqlConnection con = new SqlConnection("Data Source=db-mssql; Initial Catalog=s18989;Integrated Security=True"))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "select firstname, lastname, birthdate, name, semester from students s inner join enrollment e on s.idenrollment = e.idenrollment inner join studies st on e.idstudy = st.idstudy";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new Student();
st.FirstName = dr["FirstName"].ToString();
st.LastName = dr["LastName"].ToString();
st.BirthDate = DateTime.Parse(dr["BirthDate"].ToString());
st.Name = dr["Name"].ToString();
st.Semester = Int16.Parse(dr["Semester"].ToString());
list.Add(st);
}
}
return(Ok(list));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var list = new List <Student>();
using (SqlConnection con = new SqlConnection(conString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "SELECT s.FirstName, s.LastName, s.BirthDate, st.Name, e.Semester FROM Student s " +
"JOIN Enrollment e ON e.IdEnrollment = s.IdEnrollment JOIN Studies st ON st.IdStudy = e.IdStudy";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new StudentInfoDto()
{
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
Name = dr["Name"].ToString(),
BirthDate = dr["BirthDate"].ToString(),
Semester = dr["Semester"].ToString()
};
list.Add(st);
}
}
return(Ok(list));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
var list = new List <Student>();
using (SqlConnection con = new SqlConnection(ConString)) //przy using bez ";"
//con.Open();
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "select* from student1;";
con.Open();
SqlDataReader dr = com.ExecuteReader(); // wczytuje strumieniem danych
while (dr.Read())
{
var st = new Student();
st.IndexNumber = dr["IndexNumber"].ToString(); /// w nawiasie kwadratowym jest to indekser
st.FirstName = dr["FirstName"].ToString();
st.LastName = dr["LastName"].ToString();
list.Add(st);
}
}
// con.Dispose();
return(Ok());
}
public ReportXlm(IConfig config, ILogger logger, IStudentsDal studentsDal, IStudentsAndLectionsDal studentsAndLectionsDal, ILectionsDal lectionsDal, ILectorsDal lectorsDal)
{
_logger = logger;
_studentsDal = studentsDal;
_studentsAndLectionsDal = studentsAndLectionsDal;
_lectionsDal = lectionsDal;
_lectorsDal = lectorsDal;
_config = config;
}
public LearningBL(IConfig config, ILogger logger, IStudentsDal studentsDal, IStudentsAndLectionsDal studentsAndLectionsDal, ILectionsDal lectionsDal, ILectorsDal lectorsDal)
{
_logger = logger;
_studentsDal = studentsDal;
_studentsAndLectionsDal = studentsAndLectionsDal;
_lectionsDal = lectionsDal;
_lectorsDal = lectorsDal;
_config = config;
}
public IActionResult GetStudents([FromServices] IStudentsDal serv, [FromQuery] string orderBy)
{
if (orderBy == "lastname")
{
return(Ok(_dbService.GetStudents().OrderBy(stu => stu.LastName)));
}
return(Ok(_dbService.GetStudents()));
}
public IActionResult GetStudents([FromServices] IStudentsDal dbService)
{
//Budowanie connection string
/*
* var conBuilder = new SqlConnectionStringBuilder();
* conBuilder.InitialCatalog = "pgago";
* //..
* string conStr = conBuilder.ConnectionString;
*/
//1. Nisko-poziomowa
// 1.1 Sterownikow Oracle/SqlServer
// 1.2 Sterownikow ogolnych
//
var list = new List <Student>();
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = "select * from studentVisual s inner join enrollment e on s.idenrollment = e.idenrollment inner join studiesVisual st on e.idstudy = st.idstudy";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var st = new Student();
st.IndexNumber = dr["IndexNumber"].ToString();
st.FirstName = dr["FirstName"].ToString();
st.LastName = dr["LastName"].ToString();
st.BirthDate = dr["BirthDate"].ToString();
st.Name = dr["Name"].ToString();
st.Semester = int.Parse(dr["Semester"].ToString());
list.Add(st);
}
}
return(Ok(list));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IStudentsDal dbService)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMiddleware <ILogMiddleware>();
app.Use(async(contx, nex) =>
{
if (!contx.Request.Headers.ContainsKey("Index"))
{
contx.Response.StatusCode = StatusCodes.Status401Unauthorized;
await contx.Response.WriteAsync("W naglowkach nie znajduje sie numer indexu studenta.");
return;
}
var idx = contx.Request.Headers["Index"].ToString();
if (!dbService.IsStudentExist(idx))
{
contx.Response.StatusCode = StatusCodes.Status401Unauthorized;
await contx.Response.WriteAsync("Student o podanym numerze indexu nie istnieje");
return;
}
await nex();
});
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public LoginController(IStudentsDal dbService, IConfiguration configuration)
{
_dbService = dbService;
Configuration = configuration;
}
public EnrollmentController(IStudentsDal dalservice)
{
_service = dalservice;
}
public StudentsBll()
{
this.studentsDal = new StudentsDal();
}
public StudentsController(IStudentsDal dbService)
{
}
public StudentsController(IStudentsDal studentsDal)
{
_dbService = studentsDal;
}
public StudentController(IStudentsDal dbService)
{
_dbService = dbService;
}
public IActionResult GetStudentEnrollments([FromServices] IStudentsDal serv, [FromRoute] string IndexNumber)
{
return(Ok(_dbService.GetStudentEnrollments(IndexNumber)));
}
public StudyEnrollmentsController(IStudentsDal dbService)
{
_dbService = dbService;
}
public StudentsController(IStudentsDal studentDB)
{
this.studentDB = studentDB;
}
