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 < 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 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."); } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtSubject.Text)) { Box.warnBox("Please input subject."); return; } if (String.IsNullOrEmpty(txtMsg.Text)) { Box.warnBox("Please input message."); return; } if (rdoPhonebook.Checked == true) { if (cmbCategory.Text == "") { Box.warnBox("Please select category."); cmbCategory.Focus(); return; } } dataToSend.Clear(); getMobileNo(cmbCategory.Text); processSave(); Box.infoBox("Message will be send later."); sendMessages(); }
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."); } }
//void getMobileNo(string category) //{ // con = Connection.con(); // con.Open(); // query = "select mobileNo from vw_phonebook where category = ?cat"; // cmd = new MySqlCommand(query, con); // cmd.Parameters.AddWithValue("?cat", category); // MySqlDataReader dr = cmd.ExecuteReader(); // listMobile.Clear(); // while (dr.Read()) // { // listMobile.Add(Convert.ToString(dr["mobileNo"])); // } // dr.Close(); // cmd.Dispose(); // con.Close(); // con.Dispose(); //} //void queSMS() //{ // con = Connection.con(); // con.Open(); // query = "insert into msgs set msg=?msg, mobile=?mobile"; //} private void btnSend_Click(object sender, EventArgs e) { //ClassSMS.s if (!isSMSModemConnected) { Box.warnBox("Please connect modem first."); return; } threadSendSMS.RunWorkerAsync(); }
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 btnSelect_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { _frm.txtMobileNo.Text = Convert.ToString(flx[flx.RowSel, "mobileNo"]); this.Close(); } else { Box.warnBox("No data selected."); } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtRoomCode.Text)) { Box.warnBox("Please input room code."); return; } if (id == 0) { if (isRoomCodeExist()) { Box.warnBox("Room name already in the list."); return; } } if (temp != txtRoomCode.Text) { if (isRoomCodeExist()) { Box.warnBox("Room name already in the list."); return; } } if (!String.IsNullOrEmpty(txtTeacherID.Text)) { if (isTeacherExist()) { Box.warnBox("Teacher already assigned in " + assignedRoom); return; } } //if (String.IsNullOrEmpty(txtTeacherID.Text)) //{ // Box.warnBox("Please select teacher."); // return; //} //if (String.IsNullOrEmpty(txtTeacherID.Text)) //{ // Box.warnBox("Please select a teacher."); // return; //} processSave(); _frm.LoadData(); this.Close(); }
private void btnModify_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { PhoneBookAdd frm = new PhoneBookAdd(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "phonebookID"]); frm.ShowDialog(); } else { Box.warnBox("No data selected."); } }
private void btnModify_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { AcademicYearAdd frm = new AcademicYearAdd(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "academicyearID"]); frm.ShowDialog(); } else { Box.warnBox("No data selected."); } }
private void btnModify_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { SectionAddModify frm = new SectionAddModify(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "sectionID"]); frm.ShowDialog(); } else { Box.warnBox("Please select a row."); } }
private void btnModify_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { StudentAddForm frm = new StudentAddForm(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "id"]); frm.ShowDialog(); } else { Box.warnBox("Please select data."); } }
private void btnModify_Click(object sender, EventArgs e) { if (flx.Rows.Count < 2) { Box.warnBox("Please select a row."); return; } GradeAddModify frm = new GradeAddModify(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "gradeID"]); frm.ShowDialog(); }
private void btnAdd_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { _frm.txtStudentID.Text = Convert.ToString(flx[flx.RowSel, "id"]); _frm.txtlname.Text = Convert.ToString(flx[flx.RowSel, "lname"]); _frm.txtfname.Text = Convert.ToString(flx[flx.RowSel, "fname"]); _frm.txtmname.Text = Convert.ToString(flx[flx.RowSel, "mname"]); this.Close(); } else { Box.warnBox("No data found."); } }
private void TextBlastSMSMainform_FormClosing(object sender, FormClosingEventArgs e) { if (sendingProcess) { Box.warnBox("Sending SMS is on process."); e.Cancel = true; } //if (isSMSModemConnected) //{ // sms.CloseModemCommunication(); //} //Application.DoEvents(); }
private void btnDelete_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { if (Box.questionBox("Are you sure you want to delete this row?", "DELETE?")) { int id = Convert.ToInt32(flx[flx.RowSel, "phonebookID"]); Helper.deleteData("phonebook", "phonebookID", id); loaddata(); Box.infoBox("Row deleted."); } } 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, "academicyearID"]); if (Box.questionBox("Are you sure you want to delete this row?", "DELETE!")) { Helper.deleteData("academicyear", "academicyearID", id); Box.infoBox("Row successfully deleted."); loaddata(); } } else { Box.warnBox("No data selected."); } }
private void btnAdd_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtpCode.Text)) { Box.warnBox("Please input Program Code."); return; } if (String.IsNullOrEmpty(txtDesc.Text)) { Box.warnBox("Please input Program Description."); return; } if (id == 0) { con = Connection.con(); con.Open(); if (cProg.isExistProgram(con, txtpCode.Text)) { Box.warnBox("Program already exist."); return; } con.Close(); con.Dispose(); } if (id > 0) { if (temp != txtpCode.Text) { con = Connection.con(); con.Open(); if (cProg.isExistProgram(con, txtpCode.Text)) { Box.warnBox("Program already exist."); return; } con.Close(); con.Dispose(); } } processSave(); _frm.loadData(); this.Close(); }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(cmbGrade.Text)) { Box.warnBox("Please select Grade."); return; } if (String.IsNullOrEmpty(txtSection.Text)) { Box.warnBox("Please input section."); return; } processSave(); sMain.loadData(); this.Close(); }
private void btnDelete_Click(object sender, EventArgs e) { 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(); con.Open(); cGrade.delete(con, Convert.ToInt32(flx[flx.RowSel, "gradeID"])); con.Close(); con.Dispose(); Box.infoBox("Data deleted."); loadData(); } }
void processSave() { if (id > 0) { con = Connection.con(); con.Open(); section.grade = cmbGrade.Text; section.section = txtSection.Text; if (section.update(con, id) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully updated."); } else { con.Close(); con.Dispose(); Box.warnBox("Something went wrong. Please contact system administrator."); } } else { con = Connection.con(); con.Open(); section.grade = cmbGrade.Text; section.section = txtSection.Text; if (section.insert(con) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully saved."); } else { con.Close(); con.Dispose(); Box.warnBox("Something went wrong. Please contact system administrator."); } } }
void processSave() { cProg.progCode = txtpCode.Text.Trim(); cProg.progDesc = txtDesc.Text.Trim(); if (id > 0) { con = Connection.con(); con.Open(); if (cProg.update(con, id) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully updated."); } else { con.Close(); con.Dispose(); Box.warnBox("An error occured. Please contact system administrator."); } } else { con = Connection.con(); con.Open(); if (cProg.insert(con) > 0) { id = Helper.returnLastInsertID(con); con.Close(); con.Dispose(); Box.infoBox("Data successfully saved."); } else { con.Close(); con.Dispose(); Box.warnBox("An error occured. Please contact system administrator."); } } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtlname.Text)) { Box.warnBox("Please input name."); return; } if (!txtContact.MaskFull) { Box.warnBox("Please input contact no."); return; } if (String.IsNullOrEmpty(cmbPosition.Text)) { Box.warnBox("Please select category."); return; } processSave(); }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtRFID.Text)) { Box.warnBox("Please scan a card."); return; } if (String.IsNullOrEmpty(txtStudentID.Text)) { Box.warnBox("No student found."); return; } if (isAlreadyValidated()) { Box.warnBox("Already validated."); return; } processSave(); }
void processSave() { if (id > 0) { con = Connection.con(); con.Open(); cGrade.grade = txtGrade.Text.Trim(); if (cGrade.edit(con, id) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully updated."); } else { Box.warnBox("Something went wrong. Please contact system adminstrator."); con.Close(); con.Dispose(); } } else { con = Connection.con(); con.Open(); cGrade.grade = txtGrade.Text.Trim(); if (cGrade.insert(con) > 0) { id = Helper.returnLastInsertID(con); con.Close(); con.Dispose(); Box.infoBox("Data successfully saved!"); } else { Box.warnBox("Something went wrong. Please contact system adminstrator."); con.Close(); con.Dispose(); } } }
private void studentListToolStripMenuItem_Click(object sender, EventArgs e) { if (flx.Rows.Count > 1) { int teacherid = Convert.ToInt32(flx[flx.RowSel, "teacherID"]); if (teacherid > 0) { StudentListMainform frm = new StudentListMainform(); frm.roomid = Convert.ToInt32(flx[flx.RowSel, "roomID"]); frm.teacherid = teacherid; frm.ShowDialog(); } else { Box.warnBox("No teacher found on this room."); } } else { Box.warnBox("No data found."); } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtStudentID.Text)) { Box.warnBox("Please select a student."); return; } if (roomid < 1) { Box.warnBox("No room selected. Please contact system administrator."); return; } try { con = Connection.con(); con.Open(); int ayid = ac.getID(con, cmbAcademicYear.Text.Trim()); query = "insert into studentlists set academicYearID = ?ayid, id = ?id, roomID=?rid"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?ayid", ayid); cmd.Parameters.AddWithValue("?id", txtStudentID.Text.Trim()); cmd.Parameters.AddWithValue("?rid", roomid); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); Box.infoBox("Student successfully added."); _frm.LoadData(); this.Close(); } catch (Exception er) { Box.warnBox(er.Message); // throw; } }
private void btnAdd_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtGrade.Text)) { Box.warnBox("Please input grade level."); return; } if (id == 0) { con = Connection.con(); con.Open(); if (cGrade.isExist(con, txtGrade.Text.Trim())) { Box.warnBox("Grade already in the database."); return; } con.Close(); con.Dispose(); } if (id > 0) { if (temp != txtGrade.Text) { con = Connection.con(); con.Open(); if (cGrade.isExist(con, txtGrade.Text.Trim())) { Box.warnBox("Grade already in the database."); return; } con.Close(); con.Dispose(); } } processSave(); _frm.loadData(); this.Close(); }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtAYCode.Text)) { Box.warnBox("Please input A.Y. Code."); return; } if (String.IsNullOrEmpty(txtAYDesc.Text)) { Box.warnBox("Please input A.Y. Description."); return; } if (id == 0) { if (Helper.isExist("academicyear", "ayCode", txtAYCode.Text)) { Box.warnBox("Academic Code already taken. Pag move on nah."); return; } } if (id > 0) { if (temp != txtAYCode.Text) { if (Helper.isExist("academicyear", "ayCode", txtAYCode.Text)) { Box.warnBox("Academic Code already taken. Pag move on nah."); return; } } } processSave(); }