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