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