private void btn_create_type_Click(object sender, EventArgs e) { using (ExamManagementSystemEntities db = new ExamManagementSystemEntities()) { if (db.QuestionTypes.Any(item => item.QuestionTypeName == tbx_newtype.Text)) { MessageBox.Show("You can not add it to Database", "Same Question Type", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { db.QuestionTypes.Add(new QuestionType() { QuestionTypeName = tbx_newtype.Text }); var popupNotifier = new PopupNotifier(); popupNotifier.TitleText = "Exam Management System"; popupNotifier.ContentText = $"Question Type is added at {DateTime.Now} : Question Type is {tbx_newtype.Text}"; popupNotifier.IsRightToLeft = false; popupNotifier.Popup(); db.SaveChanges(); var bindingsource = new BindingSource(); bindingsource.DataSource = db.QuestionTypes.ToList(); dgw_question_types.DataSource = bindingsource; dgw_question_types.Columns["Questions"].Visible = false; } } }
private void btnlogin_Click(object sender, EventArgs e) { var username = tbxusername.Text; var password = tbxpassword.Text; if (db.Users.Any(user => user.Username == username && user.UserPassword == password)) { var userName = db.Users.Where(user => user.Username == username).First(); if (CheckUserType()) { this.Hide(); UsersLog log = new UsersLog() { UserId = userName.UserId, BeginDate = DateTime.Now }; db.UsersLogs.Add(log); db.SaveChanges(); ExamCreateStudio createexamstudio = new ExamCreateStudio(); createexamstudio.ActiveUserFullName = userName.UserFullName; createexamstudio.Show(); } else { this.Hide(); StudentExamCenter testcenter = new StudentExamCenter(); testcenter.ActiveUserFullName = userName.UserFullName; testcenter.Show(); } } this.Hide(); }
private void btn_createquestions_create_Click(object sender, EventArgs e) { using (ExamManagementSystemEntities db = new ExamManagementSystemEntities()) { var questionbody = tbx_createquestions_question1.Text; var correctanswer = tbx_createquestions_correctanswer.Text; var answer1 = tbx_createquestions_answer2.Text; var answer2 = tbx_createquestions_answer3.Text; var answer3 = tbx_createquestions_answer4.Text; var questiontype = (from item in db.QuestionTypes where item.QuestionTypeName == cmbx_createquestions_questiontype.Text select item.QuestionTypeId).First(); db.Questions.Add(new Question() { QuestionTitle = questionbody, CorrectAnswer = correctanswer, Answer1 = answer1, Answer2 = answer2, Answer3 = answer3, QuestionTypeId = questiontype }); db.SaveChanges(); var result = (from t in db.Questions orderby t.QuestionId descending select t.QuestionId).First(); var examid = (from item in db.Exams where item.ExamName == cmbx_createquestions.Text select item.ExamId).First(); db.ExamsToQuestions.Add(new ExamsToQuestion() { ExamId = examid, QuestionId = result }); //qaldigim yer exame suallar add olunur many to many db.SaveChanges(); var popupNotifier = new PopupNotifier(); popupNotifier.TitleText = "Exam Management System"; popupNotifier.ContentText = $"Question is added at {DateTime.Now}"; popupNotifier.IsRightToLeft = false; popupNotifier.Popup(); } }
private void btn_create_newuser_Click(object sender, EventArgs e) { using (ExamManagementSystemEntities db = new ExamManagementSystemEntities()) { var username = tbx_newuser_username.Text; var password = tbx_newuser_password.Text; var email = tbx_newuser_email.Text; var userfullname = tbx_newuser_fullname.Text; var usertype = (from item in db.UserTypes where item.UserTypeName == cmbx_newuser_usertype.Text select item.UserTypeId).First(); if (db.Users.Any(item => item.Username == username)) { MessageBox.Show("You can not add it to Database", "Same Exam Name", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { db.Users.Add(new User() { Username = username, UserFullName = userfullname, UserEmail = email, UserTypeId = usertype, UserPassword = password, }); db.SaveChanges(); var bindingsource = new BindingSource(); bindingsource.DataSource = db.Users.ToList(); dgw_users.DataSource = bindingsource; var popupNotifier = new PopupNotifier(); popupNotifier.TitleText = "Exam Management System"; popupNotifier.ContentText = $"User is added at {DateTime.Now} : User is {username}"; popupNotifier.IsRightToLeft = false; popupNotifier.Popup(); var bindingsource2 = new BindingSource(); bindingsource2.DataSource = db.Users.Where(item => item.UserTypeId == 3).ToList(); dgw_students.DataSource = bindingsource2; } } }
private void exitlabel_Click(object sender, EventArgs e) { using (ExamManagementSystemEntities db = new ExamManagementSystemEntities()) { this.Close(); int index = (from item in db.Users where item.UserFullName == userFullName select item.UserId).First(); var lastlog = db.UsersLogs.OrderByDescending(p => p.LogId).Take(1); if (lastlog.First().EndDate == null) { lastlog.First().EndDate = DateTime.Now; db.SaveChanges(); } Login frmMainMenu = new Login(); frmMainMenu.Show(); } }
private void btn_createexam_Click(object sender, EventArgs e) { using (ExamManagementSystemEntities db = new ExamManagementSystemEntities()) { if (db.Exams.Any(item => item.ExamName == tbxnewexam.Text)) { MessageBox.Show("You can not add it to Database", "Same Exam Name", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { db.Exams.Add(new Exam() { ExamName = tbxnewexam.Text }); var popupNotifier = new PopupNotifier(); popupNotifier.TitleText = "Exam Management System"; popupNotifier.ContentText = $"Exam is added at {DateTime.Now} : Exam Name is {tbxnewexam.Text}"; popupNotifier.IsRightToLeft = false; popupNotifier.Popup(); db.SaveChanges(); var bindingsource3 = new BindingSource(); bindingsource3.DataSource = db.Exams.ToList(); dgw_exams2.DataSource = bindingsource3; dgw_exams2.Columns["ExamsToQuestions"].Visible = false; dgw_exams2.Columns["UsersExams"].Visible = false; var bindingsource2 = new BindingSource(); bindingsource2.DataSource = db.Exams.ToList(); dgw_exams.DataSource = bindingsource2; dgw_exams.Columns["ExamsToQuestions"].Visible = false; dgw_exams.Columns["UsersExams"].Visible = false; } cmbx_createquestions.Items.Clear(); foreach (var item in db.Exams) { cmbx_createquestions.Items.Add(item.ExamName); } } }