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); } } }