private void UpdateMember() { using (var context = new KucsaManagementDatabaseEntities()) { var memberToUpdate = context.TblMembers.SingleOrDefault(member => member.MemberId == memId); if (memberToUpdate != null) { memberToUpdate.MemberName = memberName; //did not want to make it possible to change the registration number memberToUpdate.MemberRegistration = memberToUpdate.MemberRegistration; memberToUpdate.Password = memberPass; memberToUpdate.MemberThumbnail = bigPicture; memberToUpdate.MemberBigPicture = bigPicture; memberToUpdate.RoleId = Convert.ToInt32(MetroComboBoxRole.SelectedValue); memberToUpdate.CourseId = Convert.ToInt32(MetroComboBoxMemberCourse.SelectedValue); memberToUpdate.ModuleId = Convert.ToInt32(MetroComboBoxMemberModule.SelectedValue); } try { context.SaveChanges(); } catch (Exception) { MetroMessageBox.Show(this, "Could not update the user", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, memberName + " Updated Successfully but registration number remained!", "Successful Update", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void Login_Load(object sender, EventArgs e) { //Cursor.Current = Cursors.WaitCursor; try { Application.UseWaitCursor = true; using (var context = new KucsaManagementDatabaseEntities()) { MetroComboBoxUser.DataSource = context.TblMembers.ToList(); MetroComboBoxUser.DisplayMember = "MemberName"; MetroComboBoxUser.ValueMember = "MemberId"; } MetroButtonLogin.Enabled = true; //Cursor.Current = Cursors.WaitCursor; } catch (Exception) { Application.UseWaitCursor = false; MetroMessageBox.Show(this, "Either the database has been moved, we cannot find it.", "Database Errors", MessageBoxButtons.OK, MessageBoxIcon.Error); MetroButtonLogin.Enabled = false; } finally { Application.UseWaitCursor = false; //Cursor.Current = Cursors.WaitCursor; } }
public void LoadMembers() { using (var context = new KucsaManagementDatabaseEntities()) { var members = from mem in context.TblMembers select new { mem.MemberId, mem.MemberName, mem.MemberRegistration, mem.Password, //mem.MemberThumbnail, //mem.MemberBigPicture, TblCourse = mem.TblCourse.CourseName, TblModule = mem.TblModule.Title, TblRole = mem.TblRole.RoleName, //mem.TimeJoined }; try { MetroGridMembers.DataSource = members.ToList(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void MetroButtonSaveModule_Click(object sender, EventArgs e) { int modId = Convert.ToInt32(metroLabelModuleId.Text); string moduleName = metroTextBoxModuleTitle.Text; string moduleLeader = metroTextBoxModuleLeader.Text; //validate not to duplicate modules if (!IsValidModule(moduleName)) { MetroMessageBox.Show(this, "Module with the name " + moduleName + " already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (moduleName != "") { using (var context = new KucsaManagementDatabaseEntities()) { if (modId == 0) { TblModule module = new TblModule { Title = moduleName, ModuleLeader = moduleLeader }; context.TblModules.Add(module); try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, moduleName + " Module Added Successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { var moduleToUpdate = context.TblModules.SingleOrDefault(module => module.ModuleId == modId); if (moduleToUpdate != null) { moduleToUpdate.Title = moduleName; moduleToUpdate.ModuleLeader = moduleLeader; } try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, moduleName + " Updated Successfully!", "Successful Update", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } InitializeModuleList(); } }
private void MetroButtonSaveCourse_Click(object sender, EventArgs e) { int cosId = Convert.ToInt32(metroLabelCourseId.Text); string courseName = metroTextBoxCourseName.Text; string facultyName = metroTextBoxFaculty.Text; //validate not to duplicate modules if (!IsValidCourse(courseName)) { MetroMessageBox.Show(this, "Course with the name " + metroTextBoxCourseName.Text + " already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (courseName != "") { using (var context = new KucsaManagementDatabaseEntities()) { if (cosId == 0) { TblCourse course = new TblCourse { CourseName = courseName, CourseFaculty = facultyName }; context.TblCourses.Add(course); try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, courseName + " Course Added Successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { var courseToUpdate = context.TblCourses.SingleOrDefault(course => course.CourseId == cosId); if (courseToUpdate != null) { courseToUpdate.CourseName = courseName; courseToUpdate.CourseFaculty = facultyName; } try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, courseName + " Updated Successfully!", "Successful Update", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } InitializeCourseList(); } }
private void MetroButtonSaveRole_Click(object sender, EventArgs e) { int rolId = Convert.ToInt32(metroLabelRoleId.Text); string roleName = MetroTextBoxRoleName.Text; //validate not to duplicate Roles if (!IsValidRole(roleName)) { MetroMessageBox.Show(this, "Role with the name " + roleName + " already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (roleName != "") { using (var context = new KucsaManagementDatabaseEntities()) { if (rolId == 0) { TblRole role = new TblRole { RoleName = roleName }; context.TblRoles.Add(role); try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Entity Framework Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, roleName + " Role Added Successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { var roleToUpdate = context.TblRoles.SingleOrDefault(role => role.RoleId == rolId); if (roleToUpdate != null) { roleToUpdate.RoleName = roleName; } try { context.SaveChanges(); } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } MetroMessageBox.Show(this, roleName + " Updated Successfully!", "Successful Update", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } InitializeRoleList(); } }
private void InitializeCourseList() { using (var context = new KucsaManagementDatabaseEntities()) { MetroComboBoxMemberCourse.DataSource = context.TblCourses.ToList(); MetroComboBoxMemberCourse.DisplayMember = "CourseName"; MetroComboBoxMemberCourse.ValueMember = "CourseId"; } }
private void InitializeModuleList() { using (var context = new KucsaManagementDatabaseEntities()) { MetroComboBoxMemberModule.DataSource = context.TblModules.ToList(); MetroComboBoxMemberModule.DisplayMember = "Title"; MetroComboBoxMemberModule.ValueMember = "ModuleId"; } }
private bool IsValidRole(string title) { using (var context = new KucsaManagementDatabaseEntities()) { if (context.TblRoles.Any(role => role.RoleName == title)) { return(false); } } return(true); }
private bool IsValidModule(string title) { using (var context = new KucsaManagementDatabaseEntities()) { if (context.TblModules.Any(module => module.Title == title)) { return(false); } } return(true); }
private bool IsValidCourse(string title) { using (var context = new KucsaManagementDatabaseEntities()) { if (context.TblCourses.Any(course => course.CourseName == title)) { return(false); } } return(true); }
private bool isValidDelete(int deleteID) { //Method to check if an entry is used as a foreign key, it should return false using (var context = new KucsaManagementDatabaseEntities()) { var roleToDelete = context.TblMembers.SingleOrDefault(role => role.RoleId == deleteID); if (roleToDelete != null) { return(false); } } return(true); }
private void InitializeRoleList() { using (var context = new KucsaManagementDatabaseEntities()) { var roles = from rol in context.TblRoles select new { rol.RoleId, rol.RoleName, }; MetroGridRoles.DataSource = roles.ToList(); } }
private void InitializeModuleList() { using (var context = new KucsaManagementDatabaseEntities()) { var modules = from mod in context.TblModules select new { mod.ModuleId, mod.Title, mod.ModuleLeader }; metroGridModules.DataSource = modules.ToList(); } }
private void InitializeCourseList() { using (var context = new KucsaManagementDatabaseEntities()) { var courses = from cos in context.TblCourses select new { cos.CourseId, cos.CourseName, cos.CourseFaculty }; MetroGridCourses.DataSource = courses.ToList(); } }
private bool isValidRegistrationNo(string RegNo) { try { using (var context = new KucsaManagementDatabaseEntities()) { var regExists = context.TblMembers.SingleOrDefault(member => member.MemberRegistration == RegNo); if (regExists != null) { return(false); } } } catch (Exception) { } return(true); }
private bool isValidDelete(int deleteID) { //Method to check if an entry is used as a foreign key, it should return false using (var context = new KucsaManagementDatabaseEntities()) { var memberToDelete = context.TblProjects.SingleOrDefault(member => member.MemberId == deleteID); if (memberToDelete != null) { return(false); } else { return(true); } } //return true; }
private void MetroButtonDelete_Click(object sender, EventArgs e) { int deleteID = Convert.ToInt32(metroLabelMemberId.Text); if (metroLabelMemberId.Text != "0" && metroLabelMemberId.Text != null && isValidDelete(deleteID)) { using (var context = new KucsaManagementDatabaseEntities()) { var delUser = new TblMember { MemberId = deleteID }; context.TblMembers.Attach(delUser); context.TblMembers.Remove(delUser); context.SaveChanges(); MetroMessageBox.Show(this, delUser.MemberName + " Removed Successfully from the system!", "Successful Removal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); LoadMembers(); } } }
private void MetroButtonLogin_Click(object sender, EventArgs e) { //nothing much has been done here, login implementation deserves more than this int userName = Convert.ToInt32(MetroComboBoxUser.SelectedValue); string password = MetroTextBoxPassword.Text; try { this.Enabled = false; //optional, better target a panel or specific controls this.UseWaitCursor = true; //from the Form/Window instance using (var context = new KucsaManagementDatabaseEntities()) { var user = context.TblMembers.SingleOrDefault(member => member.MemberId == userName); if (user != null) { string useLoggedIn = user.MemberName; MetroMessageBox.Show(this, useLoggedIn, "User's name", MessageBoxButtons.OK, MessageBoxIcon.Information); FormMain fm = new FormMain() { }; fm.Show(); this.Hide(); } else { MetroMessageBox.Show(this, "Not logged in", "User's name", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } catch (Exception es) { MetroMessageBox.Show(this, es.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Enabled = true;//optional this.UseWaitCursor = false; } }
private void AddNewMember() { using (var context = new KucsaManagementDatabaseEntities()) { TblMember member = new TblMember { MemberName = memberName, MemberRegistration = memberReg, Password = memberPass, MemberThumbnail = bigPicture, MemberBigPicture = bigPicture, RoleId = Convert.ToInt32(MetroComboBoxRole.SelectedValue), CourseId = Convert.ToInt32(MetroComboBoxMemberCourse.SelectedValue), ModuleId = Convert.ToInt32(MetroComboBoxMemberModule.SelectedValue) }; if (!isValidRegistrationNo(memberReg)) { MetroMessageBox.Show(this, "The registration number entered already exists!", "Unsuccessful Operation!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { context.TblMembers.Add(member); try { context.SaveChanges(); MetroMessageBox.Show(this, memberName + " Added Successfully as a member!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch (Exception) { MetroMessageBox.Show(this, "Could not save a new user", "Unsuccessful Operation!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }