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 MetroButtonDelete_Click(object sender, EventArgs e)
{
int deleteID = Convert.ToInt32(metroLabelModuleId.Text);
if (metroLabelModuleId.Text != "0" && metroLabelModuleId.Text != null && isValidDelete(deleteID))
{
using (var context = new KucsaManagementDatabaseEntities())
{
var delModule = new TblModule {
ModuleId = deleteID
};
context.TblModules.Attach(delModule);
context.TblModules.Remove(delModule);
context.SaveChanges();
MetroMessageBox.Show(this, delModule.Title + " Removed Successfully from the system!", "Successful Removal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
InitializeModuleList();
}
}
}
