private void Delete_Click(object sender, EventArgs e) { using (AcademyEntities academyDb = new AcademyEntities()) { if (academyDb.Users.Any()) { var id = Convert.ToInt32(AllUsersView.CurrentRow.Cells["Id"].Value); var userToDelete = academyDb.Users.Find(id); if (id != user.Id) { if (userToDelete.Id != 1) { if (userToDelete.RoleId == 2) { if (!academyDb.Subjects.Where(s => s.TeacherId == userToDelete.Id).Any()) { academyDb.Users.Remove(userToDelete); academyDb.SaveChanges(); MessageBox.Show("User info about " + userToDelete.FName + " " + userToDelete.LName + " was deleted"); } else { MessageBox.Show("You cannot delete this user as he/she has subjects. Revoke the subjects first"); } } if (userToDelete.RoleId == 3) { if (!academyDb.Marks.Where(m => m.StudentId == userToDelete.Id).Any()) { academyDb.Users.Remove(userToDelete); academyDb.SaveChanges(); MessageBox.Show("User info about " + userToDelete.FName + " " + userToDelete.LName + " was deleted"); } else { MessageBox.Show("You cannot delete this user as he/she has marks"); } } } else { MessageBox.Show("You cannot destroy your Creator!!!!!"); } } else { MessageBox.Show("You cannot delete yourself!"); } } else { MessageBox.Show("No users existed!"); } } }
private void Ok_Click(object sender, EventArgs e) { using (AcademyEntities academyDb = new AcademyEntities()) { //AcademyEntities academyDb = new AcademyEntities(); try { if (Login.Text != "" && Password.Text != "" && LName.Text != "" && FName.Text != "" && RolesChoice.Text != "" && Phone.Text != "") { var loginTest = academyDb.Users.FirstOrDefault(l => l.Login == Login.Text); if (loginTest == null) { var newUser = new User { Login = Login.Text, Password = Password.Text, LName = LName.Text, FName = FName.Text, RoleId = RolesChoice.SelectedIndex + 1, Phone = Phone.Text, Date = DateTime.Now }; academyDb.Users.Add(newUser); academyDb.SaveChanges(); this.Owner.Show(); this.Close(); } else { MessageBox.Show("A user with the same Login already exists!"); } } else { MessageBox.Show("Fill in all fields!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void ExamMarks_Click(object sender, EventArgs e) { using (var db = new AcademyEntities()) { if (db.Marks.Where(m => m.Subject.TeacherId == user.Id).Any()) { this.Hide(); ExamMarks examMarks = new ExamMarks(user); examMarks.Show(); this.AddOwnedForm(examMarks); } else { MessageBox.Show("No marks yet to show"); } } }
private void Edit_Click(object sender, EventArgs e) { using (AcademyEntities academyDb = new AcademyEntities()) { if (academyDb.Users.Any()) { this.Hide(); var id = Convert.ToInt32(AllUsersView.CurrentRow.Cells["Id"].Value); EditUserDialog editUserDialog = new EditUserDialog(id); editUserDialog.Show(); this.AddOwnedForm(editUserDialog); } else { MessageBox.Show("No users existed!"); } } }
private void UpdateView_Click(object sender, EventArgs e) { using (AcademyEntities academyDb = new AcademyEntities()) { var UsersView = from u in academyDb.Users select new { Id = u.Id, Login = u.Login, Password = u.Password, RoleId = u.RoleId, LName = u.LName, FName = u.FName, Date = u.Date, Phone = u.Phone }; AllUsersView.DataSource = UsersView.ToList(); AllUsersView.BackgroundColor = Color.White; AllUsersView.ReadOnly = true; AllUsersView.AllowUserToResizeColumns = true; } }
private void SeeMarks_Click(object sender, EventArgs e) { using (var db = new AcademyEntities()) { if (user.GroupId != null) { if (db.Marks.Where(m => m.StudentId == user.Id).Any()) { this.Hide(); SeeMarks seeMarks = new SeeMarks(user); seeMarks.Show(); this.AddOwnedForm(seeMarks); } else { MessageBox.Show("No marks yet to show"); } } else { MessageBox.Show("You were not added to any group!"); } } }
private void PassExams_Click(object sender, EventArgs e) { using (var db = new AcademyEntities()) { if (user.GroupId != null) { if (db.Exams.Any() && db.RSGs.Where(rs => rs.GroupId == user.GroupId).Any()) { this.Hide(); PassExams passExams = new PassExams(user); passExams.Show(); this.AddOwnedForm(passExams); } else { MessageBox.Show("No exams, groups or subjects exist"); } } else { MessageBox.Show("You were not added to any group!"); } } }
private void Enter_Click(object sender, EventArgs e) { using (AcademyEntities academyDb = new AcademyEntities()) { var login = LoginText.Text; var password = PasswordText.Text; var loginSearch = from user in academyDb.Users where user.Login == login select user; var userResult = loginSearch.FirstOrDefault(); var role = from roles in academyDb.Roles where roles.Id == userResult.RoleId select roles; //var roleName = role.FirstOrDefault(); try { if (LoginText.Text != "" && PasswordText.Text != "") { if (userResult != null) { if (password == userResult.Password) { MessageBox.Show("You have successfully logged in!"); this.Hide(); if (userResult.RoleId == 1) { AdminMenu adminMenu = new AdminMenu(userResult); adminMenu.Show(); this.AddOwnedForm(adminMenu); } if (userResult.RoleId == 2) { Teachermenu teacherMenu = new Teachermenu(userResult); teacherMenu.Show(); this.AddOwnedForm(teacherMenu); } if (userResult.RoleId == 3) { StudentMenu studentMenu = new StudentMenu(userResult); studentMenu.Show(); this.AddOwnedForm(studentMenu); } } else { MessageBox.Show("Wrong password!"); } } else { MessageBox.Show("Login not found!"); } } else { MessageBox.Show("Fill in all fields!"); } } catch (Exception exception) { MessageBox.Show(exception.Message); } } }