public void SaveClick(object sender, RoutedEventArgs s)
{
if (this.passwordTextBox.Text.Equals(""))
{
MessageBox.Show("Brak hasła", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
var userEdit = db.Users.FirstOrDefault(x => x.Username.Equals(user.Username));
userEdit.Password = ComputeHash(this.passwordTextBox.Text);
db.SaveChanges();
List <int> rolesID = new List <int>();
foreach (Users_Roles u in users_roles)
{
db.Users_Roles.Remove(u);
}
db.SaveChanges();
if ((bool)this.Journal1CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL1"));
rolesID.Add(role.ID_Role);
}
if ((bool)this.Journal2CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL2"));
rolesID.Add(role.ID_Role);
}
if ((bool)this.Journal3CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL3"));
rolesID.Add(role.ID_Role);
}
foreach (int id in rolesID)
{
var user_role = new Users_Roles
{
ID_User = user.ID_User,
ID_Role = id
};
db.Users_Roles.Add(user_role);
}
db.SaveChanges();
MessageBox.Show("Zmieniono dane użytkownika", "Powodzenie", MessageBoxButton.OK, MessageBoxImage.Information);
mw.ReloadComboBox();
this.Close();
}
public ActionResult Create([Bind(Include = "ID,Name,Handle,ProfilePic")] JournalUser journalUser)
{
if (ModelState.IsValid)
{
db.JournalUsers.Add(journalUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(journalUser));
}
public void RemoveUserClick(object sender, RoutedEventArgs s)
{
if (db.Users.FirstOrDefault(x => x.Username.Equals(this.loginTextBox.Text)).IsAdmin == true)
{
MessageBox.Show("Nie można usunąć admina", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (!this.loginTextBox.Text.Equals(""))
{
var user = db.Users.FirstOrDefault(x => x.Username.Equals(this.loginTextBox.Text));
if (user != null)
{
db.Users.Remove(user);
List <Users_Roles> users_Roles = db.Users_Roles.Where(x => x.ID_User == user.ID_User).ToList();
foreach (Users_Roles u in users_Roles)
{
db.Users_Roles.Remove(u);
}
db.SaveChanges();
MessageBox.Show("Usunieto użytkownika " + user.Username, "Usunięto", MessageBoxButton.OK, MessageBoxImage.Information);
//this.Close();
}
else
{
MessageBox.Show("Nie ma takiego użytkownika", "Brak użytkownika", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Wpisz nazwę użytkownika", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ArticleApiTest()
{
DbOptions = new DbContextOptionsBuilder <JournalDbContext>()
.UseInMemoryDatabase(databaseName: "Article_Test_Db")
.Options;
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new Issue
{
Id = 6,
AllTime = 474,
IssueDetails = new IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
},
Articles = new List <Article> ()
{
new Article()
{
Title = "Az 1%"
},
new Article()
{
Title = "Utazd be Európát!"
}
}
});
ctx.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "SubmissionID,Title,Text")] Submission submission, int userID)
{
submission.SubmissionTime = DateTime.Now;
JournalUser currentuser = db.JournalUsers.Find(userID);
submission.JournalUser = currentuser;
if (ModelState.IsValid)
{
db.Submissions.Add(submission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(submission));
}
public void AddEntryClick(object sender, RoutedEventArgs s)
{
if (this.entryTextBox.Text.Equals(""))
{
MessageBox.Show("Brak treści wpisu", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
switch (this.JournalsComboBox.SelectedItem.ToString())
{
case ("JOURNAL1"):
Journal1 entry1 = new Journal1()
{
data = DateTime.Now,
username = currrentUser,
entry = entryTextBox.Text
};
db.Journal1.Add(entry1);
break;
case ("JOURNAL2"):
Journal2 entry2 = new Journal2()
{
data = DateTime.Now,
username = currrentUser,
entry = entryTextBox.Text
};
db.Journal2.Add(entry2);
break;
case ("JOURNAL3"):
Journal3 entry3 = new Journal3()
{
data = DateTime.Now,
username = currrentUser,
entry = entryTextBox.Text
};
db.Journal3.Add(entry3);
break;
default:
MessageBox.Show("Wybierz odpowiedni dziennik", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
break;
}
db.SaveChanges();
mw.ShowJournal();
this.Close();
}
public void Initialize()
{
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new DAL.Entities.Issue
{
AllTime = 474,
IssueDetails = new DAL.Entities.IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
}
});
ctx.SaveChanges();
}
}
public void EditEntryClick(object sender, RoutedEventArgs s)
{
switch (journal)
{
case ("JOURNAL1"):
var entryFromDb1 = db.Journal1.FirstOrDefault(x => x.ID == entry.ID);
entryFromDb1.entry = this.entryTextBox.Text;
break;
case ("JOURNAL2"):
var entryFromDb2 = db.Journal2.FirstOrDefault(x => x.ID == entry.ID);
entryFromDb2.entry = this.entryTextBox.Text;
break;
case ("JOURNAL3"):
var entryFromDb3 = db.Journal3.FirstOrDefault(x => x.ID == entry.ID);
entryFromDb3.entry = this.entryTextBox.Text;
break;
}
db.SaveChanges();
mw.ShowJournal();
this.Close();
}
public IssueApiTest()
{
DbOptions = new DbContextOptionsBuilder <JournalDbContext>()
.UseInMemoryDatabase(databaseName: "Issue_Test_Db")
.Options;
using (var ctx = new JournalDbContext(DbOptions))
{
ctx.Issues.Add(new Issue
{
Id = 6,
AllTime = 474,
IssueDetails = new IssueDetails
{
Volume = 45,
Number = 6,
Name = "Nyári szám",
CopyNumber = 800,
ExpectedPageCount = 36
}
});
ctx.SaveChanges();
}
}
public void DeleteButtonClick(object sender, RoutedEventArgs s)
{
int ID = (int)((Button)sender).CommandParameter;
switch (journal)
{
case ("JOURNAL1"):
var entry1 = db.Journal1.FirstOrDefault(x => x.ID == ID);
db.Journal1.Remove(entry1);
break;
case ("JOURNAL2"):
var entry2 = db.Journal2.FirstOrDefault(x => x.ID == ID);
db.Journal2.Remove(entry2);
break;
case ("JOURNAL3"):
var entry3 = db.Journal3.FirstOrDefault(x => x.ID == ID);
db.Journal3.Remove(entry3);
break;
}
db.SaveChanges();
ShowJournal();
}
public void AddUserClick(object sender, RoutedEventArgs s)
{
if (!this.loginTextBox.Text.Equals(""))
{
if (db.Users.FirstOrDefault(x => x.Username.Equals(this.loginTextBox.Text)) == null)
{
if (this.passwordTextBox.Text.Equals(""))
{
MessageBox.Show("Brak hasła", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
var user = new User
{
Username = this.loginTextBox.Text,
Password = ComputeHash(this.passwordTextBox.Text)
};
List <int> rolesID = new List <int>();
if ((bool)this.Journal1CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL1"));
rolesID.Add(role.ID_Role);
}
if ((bool)this.Journal2CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL2"));
rolesID.Add(role.ID_Role);
}
if ((bool)this.Journal3CheckBox.IsChecked)
{
var role = db.Roles.FirstOrDefault(x => x.Name.Equals("JOURNAL3"));
rolesID.Add(role.ID_Role);
}
if ((bool)this.isAdmin.IsChecked)
{
user.IsAdmin = true;
}
else
{
user.IsAdmin = false;
}
db.Users.Add(user);
db.SaveChanges();
user = db.Users.FirstOrDefault(x => x.Username.Equals(this.loginTextBox.Text));
foreach (int id in rolesID)
{
var user_role = new Users_Roles
{
ID_User = user.ID_User,
ID_Role = id
};
db.Users_Roles.Add(user_role);
}
db.SaveChanges();
MessageBox.Show("Dodano użytkownika " + user.Username, "Powodzenie", MessageBoxButton.OK, MessageBoxImage.Information);
//this.Close();
}
else
{
MessageBox.Show("Taki użytkownik już istnieje", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Brak nazwy użytkownika", "Bląd", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public static void Initialize(JournalDbContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any() && context.Teachers.Any())
{
return; // DB has been seeded
}
var teachers = new Teacher[]
{
new Teacher {
Login = "******", Password = "******"
},
new Teacher {
Login = "******", Password = "******"
}
};
context.Teachers.AddRange(teachers);
context.SaveChanges();
var students = new Student[]
{
new Student {
FirstName = "Carson", LastName = "Alexander"
},
new Student {
FirstName = "Meredith", LastName = "Alonso"
},
new Student {
FirstName = "Arturo", LastName = "Anand"
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas"
},
new Student {
FirstName = "Yan", LastName = "Li"
},
new Student {
FirstName = "Peggy", LastName = "Justice"
},
new Student {
FirstName = "Laura", LastName = "Norman"
},
new Student {
FirstName = "Nino", LastName = "Olivetto"
}
};
context.Students.AddRange(students);
context.SaveChanges();
var subjects = new Subject[]
{
new Subject {
ID = 1050, Name = "Chemistry"
},
new Subject {
ID = 4022, Name = "Microeconomics"
},
new Subject {
ID = 4041, Name = "Macroeconomics"
},
new Subject {
ID = 1045, Name = "Calculus"
},
new Subject {
ID = 3141, Name = "Trigonometry"
},
new Subject {
ID = 2021, Name = "Composition"
},
new Subject {
ID = 2042, Name = "Literature"
}
};
context.Subjects.AddRange(subjects);
context.SaveChanges();
var marks = new Mark[]
{
new Mark {
ID = 1, SubjectID = 1050, Grade = 3
},
new Mark {
ID = 1, SubjectID = 4022, Grade = 4
},
new Mark {
ID = 1, SubjectID = 4041, Grade = 3
},
new Mark {
ID = 2, SubjectID = 1045, Grade = 4
},
new Mark {
ID = 2, SubjectID = 3141, Grade = 4
},
new Mark {
ID = 2, SubjectID = 2021, Grade = 3
},
new Mark {
ID = 3, SubjectID = 1050, Grade = 2
},
new Mark {
ID = 4, SubjectID = 1050, Grade = 5
},
new Mark {
ID = 4, SubjectID = 4022, Grade = 5
},
new Mark {
ID = 5, SubjectID = 4041, Grade = 5
},
new Mark {
ID = 6, SubjectID = 1045, Grade = 6
},
new Mark {
ID = 7, SubjectID = 3141, Grade = 4
},
};
context.Marks.AddRange(marks);
context.SaveChanges();
}