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