public IActionResult PutStudent(int id, Student student)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if (id != student.Id)
//{
// return BadRequest();
//}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != student.Id)
{
return(BadRequest());
}
if (id == student.Id)
{
_context.Student.Update(student);
_context.SaveChanges();
return(Ok(student));
}
return(BadRequest());
}
public IActionResult ForRegister(Student student)
{
StudentAppContext Dbcontext = new StudentAppContext();
Student sdt = new Student();
sdt.FirstName = student.FirstName;
sdt.LastName = student.LastName;
sdt.Age = student.Age;
sdt.Department = student.Department;
sdt.Address = student.Address;
sdt.City = student.City;
sdt.Mail = student.Mail;
sdt.Phone = student.Phone;
SendMail mail = new SendMail();
string pass = mail.SendEmail(student.Mail);
sdt.Password = pass;
Dbcontext.Add(sdt);
Dbcontext.SaveChanges();
return(View());
}
public void EditTask(object sender)
{
var listBoxItem = sender as System.Windows.Controls.ListBoxItem; //Get sender
itemIndex = int.Parse(listBoxItem.Tag.ToString()); //Convert listBoxItem.Tag to int (TaskID)
int itemindex = itemIndex;
TaskModel task = Tasks.Where(n => n.TaskID == itemIndex).First();
itemIndex = Tasks.IndexOf(task);
IsDialogOpen = true;
isEditing = true;
TaskName = Tasks[itemIndex].TaskName;
TaskExplanation = Tasks[itemIndex].TaskExplanation;
//Modyfikacja w bazie
using (var context = new StudentAppContext())
{
DBTask DBTask = context.DBTasks.Where(x => x.DBTaskId == itemindex).FirstOrDefault(); //Do poprawy idIndex
DBTask.TaskHeadline = TaskName;
DBTask.TaskText = TaskExplanation;
context.SaveChanges();
}
}
public async Task DeleteTaskAsync(object sender)
{
var listBoxItem = sender as System.Windows.Controls.ListBoxItem; //Get sender
itemIndex = int.Parse(listBoxItem.Tag.ToString()); //Convert listBoxItem.Tag to int (TaskID)
TaskModel task = Tasks.Where(n => n.TaskID == itemIndex).First();
await Task.Delay(300); //A short delay to make more smooth animation of removing
Tasks.Remove(task); //Get and remove selected task
/*if (Tasks.Count == 0)
* {
* itemCount = 0;
* }*/
//Usuniecie z bazy
using (var context = new StudentAppContext())
{
DBTask DBTask = context.DBTasks.Where(x => x.DBTaskId == itemIndex).FirstOrDefault();
context.DBTasks.Remove(DBTask);
context.SaveChanges();
}
}
public async Task DeleteGradeAscync(object sender)
{
var listBoxItem = sender as System.Windows.Controls.ListBoxItem; //get sender
gradeIndex = int.Parse(listBoxItem.Tag.ToString());
var listaPrzedmiotow = Subjects.ToList();
foreach (SubjectModel przedmiot in listaPrzedmiotow)
{
var oceny = przedmiot.Grades.ToList();
foreach (GradeModel ocena in oceny)
{
if (gradeIndex == ocena.GradeId)
{
await Task.Delay(200);
przedmiot.Grades.Remove(ocena);
}
}
}
//Usunięcie oceny z bazy
using (var context = new StudentAppContext())
{
DBMark dbm = context.DBMarks.FirstOrDefault(x => x.DBMarkId == gradeIndex);
context.DBMarks.Remove(dbm);
context.SaveChanges();
}
}
public void AddNewGrade(string grade, string wage)
{
if (!isEditing)
{
//Dodanie oceny do bazy danych
int itemId;
using (var context = new StudentAppContext())
{
DBSubject dbs = context.DBSubjects.FirstOrDefault(x => x.SubjectName == chosenSubject.SubjectName);
DBMark dbmark = new DBMark(); //{ Mark = int.Parse(Grade), Date = DateTime.Now, DBSubject = dbs};
dbmark.Mark = double.Parse(Grade);
dbmark.Date = DateTime.Now;
dbmark.DBSubject = dbs;
dbmark.Subject = chosenSubject.SubjectName;
dbs.Marks.Add(dbmark);
//context.Entry(dbs).State = EntityState.Modified;
context.SaveChanges();
var ostatniObiekt = context.DBMarks.OrderByDescending(x => x.DBMarkId).FirstOrDefault();
itemId = ostatniObiekt.DBMarkId;
}
chosenSubject.Grades.Add(new GradeModel {
GradeId = itemId, Date = DateTime.Now, GradeValue = Convert.ToDouble(Grade), Wage = Convert.ToDouble(Wage), Type = SelectedType
});
}
else
{
var listaPrzedmiotow = Subjects.ToList();
foreach (SubjectModel przedmiot in listaPrzedmiotow)
{
var oceny = przedmiot.Grades.ToList();
foreach (GradeModel ocena in oceny)
{
if (gradeIndex == ocena.GradeId)
{
ocena.GradeValue = double.Parse(grade);
ocena.Wage = double.Parse(wage);
Subjects.Refresh();
}
}
}
//Edycja oceny w bazie danych
using (var context = new StudentAppContext())
{
DBMark dbm = context.DBMarks.FirstOrDefault(x => x.DBMarkId == gradeIndex);
dbm.Mark = double.Parse(grade);
context.SaveChanges();
}
isEditing = false;
}
Grade = "";
Wage = "";
selectedType = "inne";
IsDialogOpen = false;
HelperTextGrade = "";
}
public void AddAccount()
{
//if(SecureStringToString())
//byte[] salt;
//new RNGCryptoServiceProvider().GetBytes(salt = new byte[16]);
//var pbkdf2 = new Rfc2898DeriveBytes(SecureStringToString(SecurePassword), salt, 10000);
//byte[] hash = pbkdf2.GetBytes(20);
//byte[] hashBytes = new byte[36];
//Array.Copy(salt, 0, hashBytes, 0, 16);
//Array.Copy(hash, 0, hashBytes, 16, 20);
if (!String.IsNullOrEmpty(NewUser))
{
bool flaga = false;
using (var context = new StudentAppContext())
{
var users = context.DBUsers.ToList();
for (int i = 0; i < users.Count; i++)
{
if (NewUser.Equals(users[i].Login))
{
flaga = true;
break;
}
}
}
if (NewPassword1.Equals(NewPassword2) && flaga == false)
{
//test_haslo = CreatePasswordHash(NewPassword1);
var dbuser = new DBUser {
Login = newUser, Password = CreatePasswordHash(NewPassword1)
};
int userId;
using (var context = new StudentAppContext())
{
context.DBUsers.Add(dbuser);
context.SaveChanges();
var obiektChwilowy = context.DBUsers.OrderByDescending(x => x.DBUserId).FirstOrDefault();
userId = obiektChwilowy.DBUserId;
}
IsDialogOpen = false;
}
}
//trzeba zapisać savedPasswordHash do bazy
}
public void RemoveSubject()
{
if (SelectedItemToRemove != -1)
{
var subject = Subjects.ElementAt(SelectedItemToRemove); // pobieram przedmiot do usunięcia
Subjects.Remove(subject);
//Usunięcie przedmiotu i jego ocen z bazy
using (var context = new StudentAppContext())
{
DBSubject dbsubject = context.DBSubjects.FirstOrDefault(x => x.SubjectName == subject.SubjectName);
var dbmarks = context.DBMarks.ToList().Where(x => x.DBSubject == dbsubject);
context.RemoveRange(dbmarks);
context.SaveChanges();
context.DBSubjects.Remove(dbsubject);
context.SaveChanges();
}
}
}
public void AddNewTask()
{
if (isEditing)
{
Tasks[itemIndex].TaskName = TaskName;
Tasks[itemIndex].TaskExplanation = TaskExplanation;
Tasks.Refresh(); //Raises a change notification indicating that all bindings should be refreshed.
//Modyfikacja w bazie
/*
* using (var context = new StudentAppContext())
* {
* DBTask DBTask = context.DBTasks.Where(x => x.DBTaskId == 4).FirstOrDefault(); //Do poprawy idIndex
* DBTask.TaskHeadline = TaskName;
* DBTask.TaskText = TaskExplanation;
*
* context.SaveChanges();
* }*/
}
else
{
//Dodawanie do bazy
var dbtask = new DBTask {
TaskHeadline = taskName, TaskText = taskExplanation
};
int itemId;
using (var context = new StudentAppContext())
{
context.DBTasks.Add(dbtask);
context.SaveChanges();
var obiektChwilowy = context.DBTasks.OrderByDescending(x => x.DBTaskId).FirstOrDefault();
itemId = obiektChwilowy.DBTaskId;
}
tasks.Add(new TaskModel {
TaskName = taskName, TaskExplanation = taskExplanation, TaskID = itemId
});
}
TaskExplanation = "";
TaskName = "";
IsDialogOpen = false;
isEditing = false;
}
public void AddSubject()
{
if (NewSubject.Length > 0 && !Subjects.Any(n => n.SubjectName == NewSubject))
{
//Zapisanie przedmiotu do bazy danych
var dbsubject = new DBSubject {
SubjectName = newSubject
};
using (var context = new StudentAppContext())
{
context.DBSubjects.Add(dbsubject);
context.SaveChanges();
}
Subjects.Add(new SubjectModel {
SubjectName = NewSubject, Grades = new BindableCollection <GradeModel>()
});
NewSubject = "";
}
}
public int SaveChanges()
{
return(_context.SaveChanges());
}