private void btnRemove_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { if (Box.questionBox("Are you sure you want to remove this student?", "REMOVE?")) { try { int id = Convert.ToInt32(flx[flx.RowSel, "ayStudentID"]); if (removeStudent(id)) { Box.infoBox("Student successfully removed."); loaddata(); } else { Box.warnBox("Something went wrong. Please contact system administrator."); } } catch (Exception er) { Box.errBox(er.Message); // throw; } } } else { Box.warnBox("No data found."); } }
private void btnDelete_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { int id = Convert.ToInt32(flx[flx.RowSel, "userID"]); if (Box.questionBox("Are you sure you want to delete this row?", "DELETE?")) { con = Connection.con(); con.Open(); if (delete(id) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data deleted successfully"); loadData(); } else { con.Close(); con.Dispose(); Box.errBox("Something went wrong. Please contact System Administrator."); } } } else { Box.warnBox("Please select a row."); } }
//void getComPorts() //{ // string[] ports = SerialPort.GetPortNames(); // foreach (string port in ports) // { // ///Console.WriteLine(port); // cmbPort.Items.Add(port); // } //} private void StudentAddForm_Load(object sender, EventArgs e) { try { //getComPorts(); // lblStatus.Text = "NOT READY"; // lblStatus.ForeColor = Color.Red; con = Connection.con(); con.Open(); cGrade.populateComboGrade(con, cmbGrade); // cProgram.populateCombo(con, cmbProgram); con.Close(); con.Close(); if (id > 0) { getData(); } } catch (Exception er) { Box.errBox(er.Message); // throw; } }
private void btnScan_Click(object sender, EventArgs e) { try { //int rfidport = Convert.ToInt32(Properties.Settings.Default.rfidPort.Replace("COM","")); if (rfid.method_rf_init_com(Properties.Settings.Default.rfidPort, 115200) == 0) { // rfid.method_rf_beep(10); // rfid.method_rf_light(1); isRFIDConnect = true; } if (isRFIDConnect) { rfid.ReadCard(); // rfid.method_rf_beep(10); txtRFID.Text = rfid.m_cardNo; rfid.method_close_port(); } else { Box.warnBox("No RFID Connected."); } } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (flx.Rows.Count > 1) { if (Box.questionBox("Are you sure you want to delete this room?", "DELETE?")) { int id = Convert.ToInt32(flx[flx.RowSel, "roomID"]); Helper.deleteData("rooms", "roomID", id); Box.infoBox("Room successfully deleted."); LoadData(); } } else { Box.infoBox("No data found."); } } catch (Exception er) { Box.errBox(er.Message); // throw; } }
int tobeSent() { try { con = Connection.con(); con.Open(); query = "select * from msgs where msgparentID=?id"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?id", last_id); //i = Convert.ToInt32(cmd.ExecuteScalar()); MySqlDataAdapter adptr = new MySqlDataAdapter(cmd); adptr.Fill(dataToSend); adptr.Dispose(); cmd.Dispose(); con.Close(); con.Dispose(); return(dataToSend.Rows.Count); } catch (Exception er) { Box.errBox(er.Message); //throw; return(0); } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (flx.Rows.Count < 2) { Box.warnBox("Please select a row."); return; } if (Box.questionBox("Are you sure you want to delete this row?", "DELETE?")) { // con = Connection.con(); int id = (int)flx[flx.RowSel, "sectionID"]; con = Connection.con(); con.Open(); section.delete(con, id); Box.infoBox("Data deleted successfully."); loadData(); } } catch (Exception er) { Box.errBox(er.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { loaddata(); } catch (Exception er) { Box.errBox(er.Message); } }
private void UserMainform_Load(object sender, EventArgs e) { try { loadData(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
void sendMessages() { try { threadSendSMS.RunWorkerAsync(); } catch (Exception er) { Box.errBox(er.Message); // throw; } }
private void AcademicYear_Load(object sender, EventArgs e) { try { loaddata(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void txtSstudentID_KeyDown(object sender, KeyEventArgs e) { try { loaddata(); } catch (Exception er) { Box.errBox(er.Message); // throw; } }
private void SMSBrowsePhonebook_Load(object sender, EventArgs e) { try { cat.allInComboBox(cmbCategory); loaddata(); } catch (Exception er) { Box.errBox(er.Message); } }
private void button1_Click(object sender, EventArgs e) { try { loaddata(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
void processSave() { MySqlTransaction trans = null; con = Connection.con(); con.Open(); trans = con.BeginTransaction(); try { query = "insert into msgs_parent (subject, subjectDesc) values (?subj, ?subjdesc)"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?subj", txtSubject.Text); cmd.Parameters.AddWithValue("?subjdesc", txtSubjectDesc.Text); cmd.ExecuteNonQuery(); cmd.Dispose(); last_id = Helper.returnLastInsertID(con); cmd.Dispose(); query = "insert into msgs (msg, mobile, msgparentID) values (?msgs, ?mobile, ?msgid)"; cmd = new MySqlCommand(query, con); foreach (string mobileNo in listMobileNo) { cmd.Parameters.AddWithValue("?msgs", txtMsg.Text); cmd.Parameters.AddWithValue("?mobile", mobileNo); cmd.Parameters.AddWithValue("?msgid", last_id); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } trans.Commit(); cmd.Dispose(); } catch (Exception er) { Box.errBox("An error occured. Saving data will now rollback." + er.Message); try { trans.Rollback(); } catch (MySqlException ex) { Box.errBox("An exception of type " + ex.GetType() + " was encountered while attempting to roll back the transaction."); //throw; } } con.Close(); con.Dispose(); }
private void btnLogin_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtUsername.Text)) { Box.warnBox("Please input username."); txtUsername.Focus(); return; } if (String.IsNullOrEmpty(txtPwd.Text)) { Box.warnBox("Please input password."); txtPwd.Focus(); return; } try { if (Auth()) { txtUsername.Text = ""; txtPwd.Text = ""; if (position == "ADMINISTRATOR") { AdministratorForm frm = new AdministratorForm(this); frm.Show(); this.Hide(); } if (position == "TEACHER") { TeacherMainForm frm = new TeacherMainForm(this); frm.Show(); this.Hide(); } if (position == "STAFF") { Mainform frm = new Mainform(this); frm.Show(); this.Hide(); } } else { Box.warnBox("Username and Password error!"); txtPwd.Focus(); } } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void AYStudentsList_Load(object sender, EventArgs e) { try { Helper.LoadCmb("select distinct(ayCode) from academicyear order by aycode asc", cmbAYCode); loaddata(); } catch (Exception er) { Box.errBox(er.Message + "\nPlease contact System Administrator."); // throw; } }
private void cmbCategory_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { try { loaddata(); } catch (Exception er) { Box.errBox(er.Message); //throw; } } }
private void SMSMainform_Load(object sender, EventArgs e) { timerTime.Start(); timerLate.Start(); txtModemLogs.AppendText("SYSTEM LOGS : "); try { getComPorts(); } catch (Exception er) { Box.errBox(er.Message); // throw; } }
private void PhoneBookAdd_Load(object sender, EventArgs e) { try { cat.allInComboBox(cmbPosition); if (id > 0) { getData(); } } catch (Exception er) { Box.errBox(er.Message); // throw; } }
public void loaddata() { try { std.studentID = txtstdID.Text; std.rfid = txtRFID.Text; std.lname = txtlname.Text; std.fname = txtfname.Text; flx.AutoGenerateColumns = false; flx.DataSource = std.dtStudent(0); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void Mainform_Load(object sender, EventArgs e) { //default baud = 115200 con = Connection.con(); con.Open(); lblStripAYCode.Text = new ClassAcademicYear().getCurrentAYActive(con); con.Close(); con.Dispose(); cmbRemarks.SelectedIndex = 0; try { int port = Convert.ToInt16(Properties.Settings.Default.rfidPort.Replace("COM", "")), baud = 115200; int status = rf_init_com(port, baud); if (status == 0) { // Box.infoBox("Device connected successfully."); lblRFID.Text = "RFID : CONNECTED"; rf_beep(icdev, 10); rf_light(icdev, 1); isConnected = true; // Sleep(100); button1_Click(sender, e); lblStatus.Text = "READY TO SCAN."; } else { lblRFID.Text = "RFID : NOT CONENCTED"; lblStatus.Text = "RFID ERROR"; lblStatus.ForeColor = Color.Red; isConnected = false; // rf_beep(icdev, 50); //rf_beep(icdev, 10); } //threadSMS.RunWorkerAsync(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void btnSelect_Click(object sender, EventArgs e) { try { _frm.txtTeacherID.Text = Convert.ToString(flx[flx.RowSel, "userID"]); string lname = Convert.ToString(flx[flx.RowSel, "lname"]); string fname = Convert.ToString(flx[flx.RowSel, "fname"]); string mname = Convert.ToString(flx[flx.RowSel, "mname"]); _frm.txtName.Text = (lname + ", " + fname + " " + mname).Trim(); this.Close(); } catch (Exception er) { Box.errBox(er.Message); // throw; } }
private void StudentListBrowseStudent_Load(object sender, EventArgs e) { try { con = Connection.con(); con.Open(); new ClassGrade().populateComboGrade(con, cmbGrade); con.Close(); con.Dispose(); LoadData(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void StudentListAdd_Load(object sender, EventArgs e) { try { ac.comboAcademicYear(cmbAcademicYear); con = Connection.con(); con.Open(); cmbAcademicYear.Text = ac.getCurrentAYActive(con); con.Dispose(); con.Dispose(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void button1_Click(object sender, EventArgs e) { loopBreak = true; if (loopBreak) { button1.Enabled = false; } try { backgroundWorker1.RunWorkerAsync(); } catch (Exception er) { Box.errBox(er.Message); // throw; } // ReadCard(); }
void markSent(int msgid) { try { con = Connection.con(); con.Open(); query = "update msgs set isSent = 1 where msgsID=?id"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?id", msgid); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
private void PhoneBookMainform_Load(object sender, EventArgs e) { try { //if (isStudentActive) //{ // tabControl1.SelectedIndex = 1; // //tabPage1. //} cat.allInComboBox(cmbCategory); loaddata(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
public void loadData() { try { cProg.progCode = txtpCode.Text; cProg.progDesc = txtpDesc.Text; flx.AutoGenerateColumns = false; con = Connection.con(); con.Open(); flx.DataSource = cProg.dtPrograms(con); con.Close(); con.Dispose(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }
public void loadData() { try { section.section = txtSection.Text; section.grade = cmbGrade.Text; con = Connection.con(); con.Open(); flx.AutoGenerateColumns = false; flx.DataSource = section.dtSection(con); con.Close(); con.Dispose(); } catch (Exception er) { Box.errBox(er.Message); //throw; } }