private void deleteStudentB_Click(object sender, EventArgs e)
{
if (Basic.validation.check_empty(remarkIDL.Text) == "no")
{
return;
}
db.Delete("DELETE FROM `remark` WHERE `remark`.`remark_id` = " + remarkIDL.Text);
}
private void deleteRoomB_Click(object sender, EventArgs e)
{
if (Basic.validation.check_empty(roomidL.Text) == "no")
{
return;
}
string deleteQuery = "DELETE FROM `seat` WHERE `seat`.`room_id` = " + roomidL.Text + "";
df.Delete(deleteQuery);
}
private void deleteStudentB_Click(object sender, EventArgs e)
{
if (Basic.validation.check_empty(studentIdL.Text, "Please select a student.") == "no")
{
return;
}
string deletequery = "DELETE FROM `student_info` WHERE `student_info`.`hall_std_id` = '" + studentIdL.Text + "'";
db.Delete(deletequery);
searchStudentToDeleteRB_CheckedChanged(s, EventArgs.Empty);
}
private void deleteHallB_Click(object sender, EventArgs e)
{
try{
//add delete query string and delete command run
string deleteQuery = "delete from hall_info where hall_id='" + hallIdL.Text.ToString() + "' ";
df.Delete(deleteQuery);
// end of add delete query string and delete command run
bi.load(searchHallCB, "hall_info", "hall_name");
}
catch (Exception ee)
{
MessageBox.Show("Error Occured. Message - " + ee.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 deleteB_Click(object sender, EventArgs e)
{
db.Delete("DELETE FROM `user` WHERE `user`.`user_id` = " + infoString[0] + "");
}