//public IStudentEntity GetStudentById(int studentId)
public async Task <IStudentEntity> GetStudentById(int studentId)
{
if (studentId <= 0)
{
return(null);
}
using (var dataTransfer = StudentDbService.FetchStudentByStudentId(studentId))
{
if (dataTransfer.Table.Rows.Count > 0)
{
foreach (DataRow row in dataTransfer.Table.Rows)
{
var temp = new StudentEntity
{
StudentId = int.Parse(row["StudentId"].ToString(), CultureInfo.InvariantCulture),
StudentName = row["StudentName"].ToString(),
StudentRollNumber = row["StudentRollNumber"].ToString(),
StudentFatherName = row["StudentFatherName"].ToString(),
StudentMotherName = row["StudentMotherName"].ToString()
};
return(temp);
}
}
}
return(null);
}
/// <summary>
/// Get All students
/// </summary>
/// <returns>Student List</returns>
//public async Task<IList<IStudentEntity>> GetAllStudentList()
public async Task <List <IStudentEntity> > GetAllStudentList()
{
List <IStudentEntity> studentEntities = new List <IStudentEntity>();
using (var dataTransfer = StudentDbService.FetchAllStudents())
{
if (dataTransfer.Table.Rows.Count > 0)
{
foreach (DataRow row in dataTransfer.Table.Rows)
{
var temp = new StudentEntity
{
StudentId = int.Parse(row["StudentId"].ToString(), CultureInfo.InvariantCulture),
StudentName = row["StudentName"].ToString(),
StudentRollNumber = row["StudentRollNumber"].ToString(),
StudentFatherName = row["StudentFatherName"].ToString(),
StudentMotherName = row["StudentMotherName"].ToString()
};
studentEntities.Add(temp);
}
}
}
return(studentEntities);
}
/// <summary>
/// Get AllStudentList With Paging Sorting
/// </summary>
/// <param name="searchValue">searchValue</param>
/// <param name="pageNo">page No</param>
/// <param name="pageSize">page Size</param>
/// <param name="sortColumn">sort Column</param>
/// <param name="sortOrder">sort Order</param>
/// <returns>Student data table</returns>
public List <IStudentEntity> GetAllStudentListWithPaging_Sorting(string searchValue, int pageNo, int pageSize, string sortColumn, string sortOrder)
{
List <IStudentEntity> studentEntities = new List <IStudentEntity>();
using (var dataTransfer = StudentDbService.FetchAllStudents())
{
if (dataTransfer.Table.Rows.Count > 0)
{
foreach (DataRow row in dataTransfer.Table.Rows)
{
var temp = new StudentEntity
{
StudentId = int.Parse(row["StudentId"].ToString(), CultureInfo.InvariantCulture),
StudentName = row["StudentName"].ToString(),
StudentRollNumber = row["StudentRollNumber"].ToString(),
StudentFatherName = row["StudentFatherName"].ToString(),
StudentMotherName = row["StudentMotherName"].ToString()
};
studentEntities.Add(temp);
}
}
}
return(studentEntities);
}
public IActionResult RefreshToken(string token)
{
Student student = StudentDbService.CheckRefToken(token);
if (student == null)
{
return(BadRequest());
}
return(Login(new LoginRequest(student.IndexNumber, student.password)));
}
private void RemoveButton_Click(object sender, RoutedEventArgs e)
{
//Check user decision
if (StudentsDataGrid.SelectedItems.Count > 0)
{
var messageBoxResult = MessageBox.Show("Czy na pewno chcesz usunąć dane studentów?", "Deleting Students", MessageBoxButton.OKCancel, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.OK)
{
//Prepare list to remove
var listOfStudentsToRemove = StudentsDataGrid.SelectedItems;
var listOfIdToRemove = new List <int>();
foreach (Student s in listOfStudentsToRemove)
{
listOfIdToRemove.Add(s.Id);
}
//Remove from DB
var areStudentsRemoved = StudentDbService.RemoveFromDb(listOfIdToRemove);
//If succeeded, remove from DataGrid
if (areStudentsRemoved)
{
Student student;
for (int ii = Student._ListaStudentow.Count - 1; ii >= 0; ii--)
{
student = Student._ListaStudentow.ElementAt(ii);
if (listOfIdToRemove.Contains(student.Id))
{
Student._ListaStudentow.Remove(student);
}
}
if (listOfIdToRemove.Count == 1)
{
MessageBox.Show("Usunięto studenta", "DeansOffice", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Usunięto studentów", "DeansOffice", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
}
else
{
MessageBox.Show("Nie wybrano studentów", "DeansOffice", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMiddleware <LoggingMiddleware>();
/* app.UseSwagger();
* app.UseSwaggerUI(
* config => {
* config.SwaggerEndpoint("/swagger/v1/swagger.json", "My API");
* });*/
app.Use(async(context, next) => {
if (!context.Request.Headers.ContainsKey("Index"))
{
context.Response.StatusCode = StatusCodes.Status401Unauthorized;
await context.Response.WriteAsync("ERROR [Middleware]: Nie podano numeru indexu");
return;
}
var index = context.Request.Headers["Index"].ToString();
StudentDbService trueStudent = new StudentDbService();
if (!trueStudent.trueStudent(index))
{
context.Response.StatusCode = StatusCodes.Status404NotFound;
await context.Response.WriteAsync("Brak indexu w bazie");
return;
}
await next();
});
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
var wnd = new DeansOffice();
wnd.ShowDialog();
ResetSubjects();
if (wnd.NewStudent != null)
{
var newStudent = wnd.NewStudent;
var isStudentAdded = StudentDbService.AddRecordToDb(newStudent);
if (isStudentAdded)
{
Student._ListaStudentow.Add(newStudent);
MessageBox.Show("Dodano studenta", "DeansOffice", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
public IActionResult Login(LoginRequest request)
{
Student student = StudentDbService.GetStudent(request.Login);
//Console.WriteLine(PasswordHelper.CreateSecretValue(student.password, student.salt));
if (!PasswordHelper.Validate(request.Haslo, student.salt, student.password))
{
return(BadRequest("Błędne hasło"));
}
var claims = new[]
{
new Claim(ClaimTypes.NameIdentifier, student.IndexNumber),
new Claim(ClaimTypes.Name, student.FirstName),
new Claim(ClaimTypes.Surname, student.LastName),
new Claim(ClaimTypes.DateOfBirth, student.BirthDate.ToString()),
new Claim(ClaimTypes.Role, "employee")
};
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(Configuration["SecretKey"]));
var creeds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var token = new JwtSecurityToken
(
issuer: "Gakko",
audience: "Students",
claims: claims,
expires: DateTime.Now.AddMinutes(5),
signingCredentials: creeds
);
var refreshToken = Guid.NewGuid();
DateTime dateTime = DateTime.Now;
StudentDbService.AddRefreshToken(student, refreshToken.ToString(), dateTime.AddDays(1));
return(Ok(new
{
token = new JwtSecurityTokenHandler().WriteToken(token),
refreshToken
}));
}
private void DataGridRow_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
var student = (Student)StudentsDataGrid.SelectedItem;
var wnd = new DeansOffice(student);
wnd.ShowDialog();
if (wnd.NewStudent != null)
{
var editedStudent = wnd.NewStudent;
var isStudentUpdated = StudentDbService.EditRecordInDb(student, editedStudent);
if (isStudentUpdated)
{
var orginalStudent = Student._ListaStudentow.First(s => s.Id == student.Id);
UpdateStudentDataInListaStudentow(orginalStudent, editedStudent);
MessageBox.Show("Uaktualniono dane studenta", "DeansOffice", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
ResetSubjects();
//Student._ListaStudentow = StudentDbService.PullStudentsFromDbToList();
}
public StudentsController(StudentDbService dbService, IConfiguration configuration)
{
_dbService = dbService;
Configuration = configuration;
}
/// <summary>
/// Create Student
/// </summary>
/// <param name="studentEntity">Student Entity</param>
/// <returns>Entity Id</returns>
//public int CreateStudent(IStudentEntity studentEntity)
public async Task <IStudentEntity> CreateStudent(IStudentEntity studentEntity)
{
var result = StudentDbService.InsertUpdate(studentEntity);
return(result);
}
private void GetDataFromDb()
{
Studies._StudiesList = StudentDbService.PullStudiesFromDB();
Subject._SubjectList = StudentDbService.PullSubjectsFromDB();
Student._ListaStudentow = StudentDbService.PullStudentsFromDbToList();
}