//Fill data public AssignModule fillDataProf(string id) { try { //sql query string sql = "SELECT * FROM AssignModule WHERE MId ='" + id + "'AND pId='" + ProfessorHome.profid + "'"; SqlCommand cmd = new SqlCommand(sql, con); // sql command con.Open(); // open connection SqlDataReader reader = cmd.ExecuteReader(); //read table if (reader.Read()) //loop until data found { amod = new AssignModule(); amod.setmid(reader[0].ToString()); amod.setprogramme(reader[1].ToString()); amod.setfaculty(reader[2].ToString()); amod.setmodfee(reader[3].ToString()); amod.setduration(reader[4].ToString()); amod.setstarddate(reader[5].ToString()); amod.setenddate(reader[6].ToString()); } else { MessageBox.Show("The Module has not yet been assigned"); //errror message } } finally { con.Close(); //close connection } return(amod); //return object }
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); } } } }