private void metroButton1_Click(object sender, EventArgs e)
{
string uname = metroLabeluname.Text;
CommonDBTransaction c = new CommonDBTransaction();
string sqlcheck = "SELECT PId FROM Professor WHERE username= '******'";
DataTable d = c.searchData(sqlcheck);
string profid = d.ToString();
CommonDBTransaction co = new CommonDBTransaction();
modId = metroComboBoxMod.Text;
string sql = "SELECT * FROM ProfessorModule WHERE pId = '" + profid + "'AND mid='" + modId + "'";
DataTable dt = co.searchData(sql);
if (dt.Rows.Count > 0)
{
MetroMessageBox.Show(this, "You have already registered for this module!", "Warning");
metroGridSelectMod.DataSource = dt;
metroGridSelectMod.Refresh();
}
else
{
pt.addProffessorModule();
MetroMessageBox.Show(this, "Registration successful");
}
}
private void metroButtonRegAddU_Click(object sender, EventArgs e)
{
if (metroTextBoxUnames.Text == "" || metroTextBoxPws.Text == "")
{
MessageBox.Show("Fields cannot be empty");
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Registar WHERE Username = '******'";
DataTable d = c.searchData(sql);
metroGridRegs.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Registar obj = new Registar(metroTextBoxUnames.Text, metroTextBoxPws.Text);
RegistarTransactions tr = new RegistarTransactions();
tr.addRegistar(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearReg();
}
}
}
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);
}
}
}
}
//load faculty
void loadModuleFaculty()
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Module WHERE Faculty='" + metroComboBoxFaculty.Text + "'";
DataTable dt = c.searchData(sql);
metroGridModules.DataSource = dt;
}
void DataGridViewMod()
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT MId,Programme,Faculty,Semester,Duration,ModuleFee FROM Module WHERE MId='" + metroComboBoxMod.Text + "'";
DataTable dt = c.searchData(sql);
metroGridSelectMod.DataSource = dt;
}
void loadSessionProfessorModule()
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM ProfessorModule WHERE mid = '" + metroComboBoxMod.Text + "'";
DataTable dt = c.searchData(sql);
if (dt.Rows.Count > 0)
{
metroGridProf.DataSource = dt;
}
}
void ViewModules()
{
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT MId FROM Module";
DataTable dt = c.searchData(sql);
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxMod.ValueMember = "MId";
metroComboBoxMod.DisplayMember = "MId";
metroComboBoxMod.DataSource = dt;
}
Student s = new Student(); //student instance
//load combo box
void loadCombo()
{
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction(); // new insance
string sql = "SELECT * FROM Module";
DataTable dt = c.searchData(sql); // execute query
if (metroTabControlStudent.SelectedTab.Equals(metroTabPageRegister)) // based on page execute code
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Faculty--" }; // load data to array
dt.Rows.InsertAt(dr, 0);
metroComboBoxFaculty.ValueMember = "Faculty"; //displat only faculty
metroComboBoxFaculty.DisplayMember = "Faculty";
metroComboBoxFaculty.DataSource = dt;
}
}
void loadComboShowMods()
{
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT mid FROM ProfessorModule WHERE pId = '" + profid + "'";
DataTable dt = c.searchData(sql);
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxRMods.ValueMember = "mid";
metroComboBoxRMods.DisplayMember = "mid";
metroComboBoxRMods.DataSource = dt;
}
}
void DataGridViewModules()
{
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Module";
DataTable dt = c.searchData(sql);
metroGridModules.DataSource = dt;
if (metroTabControlR.SelectedTab.Equals(AssignModules))
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxMod.ValueMember = "MId";
metroComboBoxMod.DisplayMember = "MId";
metroComboBoxMod.DataSource = dt;
}
}
void loadComboTab()
{
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT mid FROM StudentModule";
DataTable dt = c.searchData(sql);
if (metroTabControlP.SelectedTab.Equals(metroTabPageModuleRoster))
{
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxMr.ValueMember = "mid";
metroComboBoxMr.DisplayMember = "mid";
metroComboBoxMr.DataSource = dt;
}
}
}
void loadComboTab()
{
StudentTransactions std = new StudentTransactions();
std.getStudentId(metroLabelUser.Text);
String stid = s.getid();
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT mid FROM StudentModule WHERE sid = '" + stid + "'";
DataTable dt = c.searchData(sql);
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxModl.ValueMember = "mid";
metroComboBoxModl.DisplayMember = "mid";
metroComboBoxModl.DataSource = dt;
}
}
private void metroButtonRegister_Click(object sender, EventArgs e)
{
//validate data
if (metroTextBoxModId.Text == "" || metroTextBoxMod.Text == "" || metroComboBoxFaculty.Text == "" || metroTextBoxSem.Text == "" || metroTextBoxDuration.Text == "" || metroTextBoxMFee.Text == "" || metroTextBoxMOverview.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
else
{
modId = metroTextBoxModId.Text;
StudentTransactions st = new StudentTransactions();
string uname = metroLabelUser.Text;
CommonDBTransaction c = new CommonDBTransaction();
string sqlcheck = "SELECT SId FROM Student WHERE username= '******'";
DataTable d = c.searchData(sqlcheck);//validate data from db
string profid = d.ToString();
CommonDBTransaction co = new CommonDBTransaction();
modId = metroTextBoxModId.Text;
string sql = "SELECT * FROM StudentModule WHERE sid = '" + profid + "'AND mid='" + modId + "'";
DataTable dt = co.searchData(sql);//validate data from db
if (dt.Rows.Count > 0)
{
MetroMessageBox.Show(this, "You have already registered for this module!", "Warning");
metroGridModules.DataSource = dt;
metroGridModules.Refresh();
}
else
{
st.addstudentModule(); // insert data
modFee = metroTextBoxMFee.Text;
Bill b = new Bill(modFee, stdId, modId);
BillTransaction bt = new BillTransaction();
bt.addBill(b); //insert data
this.Hide();
Billing bill = new Billing();
bill.Show();
MetroMessageBox.Show(this, "Registration successful");
}
}
}
private void metroButtonProceedMod_Click(object sender, EventArgs e)
{
if (metroComboBoxMods.Text == "Add")
{
if (metroTextBoxModuleId.Text == "" || metroTextBoxModuleName.Text == "" || metroTextBoxFaculty.Text == "" || metroTextBoxFaculty.Text == "" || metroTextBoxDuration.Text == "" || metroTextBoxFee.Text == "" || metroTextBoxDescription.Text == "")
{
MetroMessageBox.Show(this, "Please fill all fields in order to add a new Module!");
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Module WHERE MId = '" + metroTextBoxModuleId.Text + "'";
DataTable d = c.searchData(sql);
metroGridModules.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Module obj = new Module(metroTextBoxModuleId.Text, metroTextBoxModuleName.Text, metroTextBoxFaculty.Text, metroComboBoxSemester.Text, metroTextBoxDuration.Text, metroTextBoxFee.Text, metroTextBoxDescription.Text);
ModuleTransactions tr = new ModuleTransactions();
tr.addModule(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearModule();
metroGridModules.Refresh();
}
}
}
else if (metroComboBoxMods.Text == "Update")
{
if (metroTextBoxModuleId.Text == "" || metroTextBoxModuleName.Text == "" || metroTextBoxFaculty.Text == "" || metroTextBoxFaculty.Text == "" || metroTextBoxDuration.Text == "" || metroTextBoxFee.Text == "" || metroTextBoxDescription.Text == "")
{
MetroMessageBox.Show(this, "Please fill all fields in order to add a new Module!");
}
else
{
Module obj = new Module(metroTextBoxModuleId.Text, metroTextBoxModuleName.Text, metroTextBoxFaculty.Text, metroComboBoxSemester.Text, metroTextBoxDuration.Text, metroTextBoxFee.Text, metroTextBoxDescription.Text);
ModuleTransactions tr = new ModuleTransactions();
tr.updateModule(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearModule();
metroGridModules.Refresh();
}
}
else if (metroComboBoxMods.Text == "Search")
{
Module obj = new Module();
ModuleTransactions tr2 = new ModuleTransactions();
try
{
obj = tr2.datafill(metroTextBoxSearchMod.Text);
metroTextBoxModuleId.Text = obj.getID();
metroTextBoxModuleName.Text = obj.getMName();
metroTextBoxFaculty.Text = obj.getFaculty();
metroComboBoxSemester.Text = obj.getSemester();
metroTextBoxDuration.Text = obj.getDuration();
metroTextBoxFee.Text = obj.getModulefee();
metroTextBoxDescription.Text = obj.getModuleOverview();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Stafford University Registration System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (metroComboBoxMods.Text == "Delete")
{
if (metroGridModules.Rows.Count == 0)
{
MetroMessageBox.Show(this, "No data found to delete");
}
else
{
DialogResult del = MessageBox.Show("Are you Sure you want to delete :" + metroTextBoxSearchMod.Text + "", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (del == DialogResult.Yes)
{
ModuleTransactions tr3 = new ModuleTransactions();
try
{
tr3.deleteStudentModule(metroTextBoxSearchMod.Text);
tr3.deleteModule(metroTextBoxSearchMod.Text);
MetroMessageBox.Show(this, "Successfully Deleted");
metroGridModules.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Delete Student", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Ok. As per confirmation, this record has not been deleted.");
}
}
}
else
{
MetroMessageBox.Show(this, "Please select a option button to Proceed!");
}
}
private void metroButtonProceed_Click(object sender, EventArgs e)
{
if (metroComboBoxOptStd.Text == "Add")
{
if (metroTextBoxStudentId.Text == "" || metroTextBoxFirstName.Text == "" || metroTextBoxLastName.Text == "" || metroTextBoxDOB.Text == "" || metroTextBoxMobileNo.Text == "" || metroTextBoxEmail.Text == "" || metroTextBoxAddress.Text == "" || metroComboBoxGen.Text == "" || metroTextBoxUsername.Text == "" || metroTextBoxPassword.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
if (!Regex.Match(metroTextBoxMobileNo.Text, @"^\d{10}$").Success)
{
MetroMessageBox.Show(this, "Please re-enter the contact number", "Warning");
metroTextBoxMobileNo.Focus();
}
if (!Regex.Match(metroTextBoxEmail.Text, @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,4})+)$").Success)
{
MetroMessageBox.Show(this, "Invalid E-Mail address Please re-enter correct address");
metroTextBoxEmail.Focus();
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Student WHERE SId = '" + metroTextBoxStudentId.Text + "' or Username = '******'";
DataTable d = c.searchData(sql);
metroGridStudents.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Student obj = new Student(metroTextBoxStudentId.Text, metroTextBoxFirstName.Text, metroTextBoxLastName.Text, metroTextBoxDOB.Text, metroTextBoxMobileNo.Text, metroTextBoxEmail.Text, metroTextBoxAddress.Text, metroComboBoxGen.Text, metroTextBoxUsername.Text, metroTextBoxPassword.Text);
StudentTransactions tr = new StudentTransactions();
tr.addstudent(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearStudent();
metroGridStudents.Refresh();
}
}
}
else if (metroComboBoxOptStd.Text == "Update")
{
if (metroTextBoxStudentId.Text == "" || metroTextBoxFirstName.Text == "" || metroTextBoxLastName.Text == "" || metroTextBoxDOB.Text == "" || metroTextBoxMobileNo.Text == "" || metroTextBoxEmail.Text == "" || metroTextBoxAddress.Text == "" || metroComboBoxGen.Text == "" || metroTextBoxUsername.Text == "" || metroTextBoxPassword.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
if (!Regex.Match(metroTextBoxMobileNo.Text, @"^\d{10}$").Success)
{
MetroMessageBox.Show(this, "Please re-enter the contact number", "Warning");
metroTextBoxMobileNo.Focus();
}
if (!Regex.Match(metroTextBoxEmail.Text, @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,4})+)$").Success)
{
MetroMessageBox.Show(this, "Invalid E-Mail address Please re-enter correct address");
metroTextBoxEmail.Focus();
}
else
{
Student obj = new Student(metroTextBoxStudentId.Text, metroTextBoxFirstName.Text, metroTextBoxLastName.Text, metroTextBoxDOB.Text, metroTextBoxMobileNo.Text, metroTextBoxEmail.Text, metroTextBoxAddress.Text, metroComboBoxGen.Text, metroTextBoxUsername.Text, metroTextBoxPassword.Text);
StudentTransactions tr = new StudentTransactions();
tr.updateStudent(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearStudent();
metroGridStudents.Refresh();
}
}
else if (metroComboBoxOptStd.Text == "Search")
{
Student obj = new Student();
StudentTransactions tr2 = new StudentTransactions();
try
{
obj = tr2.dataFill(metroTextSearch.Text);
metroTextBoxStudentId.Text = obj.getid();
metroTextBoxFirstName.Text = obj.getFirstName();
metroTextBoxLastName.Text = obj.getLastName();
metroTextBoxDOB.Text = obj.getDOB();
metroTextBoxMobileNo.Text = obj.getContactNo();
metroTextBoxEmail.Text = obj.getEmail();
metroTextBoxAddress.Text = obj.getAddress();
metroComboBoxGen.Text = obj.getGender();
metroTextBoxUsername.Text = obj.getUsername();
metroTextBoxPassword.Text = obj.getPassword();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Stafford University Registration System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (metroComboBoxOptStd.Text == "Delete")
{
if (metroGridStudents.Rows.Count == 0)
{
MetroMessageBox.Show(this, "No data found to delete");
}
else
{
DialogResult del = MessageBox.Show("Are you Sure you want to delete :" + metroTextBoxStudentId.Text + "", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (del == DialogResult.Yes)
{
StudentTransactions tr3 = new StudentTransactions();
try
{
tr3.deleteFromStudentModule(metroTextBoxStudentId.Text);
tr3.deleteStudent(metroTextBoxStudentId.Text);
MetroMessageBox.Show(this, "Successfully Deleted");
clearStudent();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Delete Student", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Ok. As per confirmation, this record has not been deleted.");
}
}
}
else
{
MetroMessageBox.Show(this, "Please select a option button to Proceed!");
}
}