private void coupon_Load(object sender, EventArgs e)
{
Basic.information_load il = new Basic.information_load();
il.load(hallNameCB, "hall_info", "hall_name");
//SELECT DISTINCT (`session`)FROM `student_info`ORDER BY `student_info`.`session` ASC
il.load(sessionCB, "student_info", "session");
}
private void deleteDeptB_Click(object sender, EventArgs e)
{
try
{
//add delete query string and delete command run
string deleteQuery = "delete from dept_info where dept_id='" + deptIdL.Text.ToString() + "' ";
df.Delete(deleteQuery);
// end of add delete query string and delete command run
Basic.information_load bn = new Basic.information_load();
bn.load(searchDeptCB, "dept_info", "dept_name");
}
catch (Exception ee)
{
MessageBox.Show("Error Occured. Message - " + ee.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void updateQoutaB_Click(object sender, EventArgs e)
{
if (qoutaNameTB.Text == "")
{
MessageBox.Show("Please fill up the qouta Name. ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
qoutaNameTB.Focus();
return;
}
try
{
// start of update command run
string updateQuery = "update qouta set qouta_name='" + qoutaNameTB.Text.ToString() + "' where qouta_id='" + qoutaIdL.Text.ToString() + "'";
df.Update(updateQuery);
//end of update command runn
Basic.information_load bn = new Basic.information_load();
bn.load(searchQoutaCB, "qouta", "qouta_name");
}
catch (Exception ee)
{
MessageBox.Show("Error Occured. Message - " + ee.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void updateDeptB_Click(object sender, EventArgs e)
{
if (deptNameTB.Text == "")
{
MessageBox.Show("Please fill up the dept Name. ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
deptNameTB.Focus();
return;
}
try
{
// start of update command run
string updateQuery = "update dept_info set dept_name='" + deptNameTB.Text.ToString() + "', faculty_id='" + facultyNameCB.SelectedItem.ToString() + "' where dept_id='" + deptIdL.Text.ToString() + "'";
df.Update(updateQuery);
//end of update command runn
Basic.information_load bn = new Basic.information_load();
bn.load(searchDeptCB, "dept_info", "dept_name");
bn.load(facultyNameCB, "faculty_info", "faculty_name");
}
catch (Exception ee)
{
MessageBox.Show("Error Occured. Message - " + ee.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
