private void metrobuttonAssignMod_Click(object sender, EventArgs e)
{
if (metroComboBoxMod.Text == "" && metroTextBoxFac.Text == "" && metroTextBoxDur.Text == "" && metroTextBoxMFee.Text == "" && metroTextBoxModule.Text == "" && metroTextBoxStDate.Text == "" && metroTextBoxEDate.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM AssignModule WHERE mid ='" + metroComboBoxMod.Text + "'";
DataTable d = c.searchData(sql);
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
if (metroGridProf.Rows.Count < 2)
{
MetroMessageBox.Show(this, "Insuffcient Students for the module requirement!");
}
else if (metroGridProf.Rows.Count > 9)
{
MetroMessageBox.Show(this, "The number of students for this module has been equiped with!");
}
else
{
AssignModule am = new AssignModule();
am.setmid(metroComboBoxMod.Text);
am.setprogramme(metroTextBoxModule.Text);
am.setfaculty(metroTextBoxFac.Text);
am.setmodfee(metroTextBoxMFee.Text);
am.setduration(metroTextBoxDur.Text);
am.setstarddate(metroTextBoxStDate.Text);
am.setenddate(metroTextBoxEDate.Text);
StringBuilder sb = new StringBuilder();
string seperator = "";
for (int i = 0; i < metroGridStd.Rows.Count; i++)
{
sb.AppendFormat("{0}{1}", seperator, metroGridStd.Rows[i].Cells[0].Value.ToString());
seperator = ",";
}
string lid = sb.ToString();
am.setlid(lid);
StringBuilder sb1 = new StringBuilder();
string seperator1 = "";
for (int i = 0; i < metroGridProf.Rows.Count; i++)
{
sb1.AppendFormat("{0}{1}", seperator1, metroGridProf.Rows[i].Cells[0].Value.ToString());
seperator1 = ",";
}
string sid = sb1.ToString();
am.setsid(sid);
AssignModuleTransaction amt = new AssignModuleTransaction();
amt.addModule(am);
}
}
}
}
