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 threadSendSMS_DoWork(object sender, DoWorkEventArgs e) { sms.InitModem(); sms.OpenModemCommunication(); Box.infoBox("Message Start sending...!"); sendingProcess = true; lblSMSNo.Invoke(new MethodInvoker(delegate { lblSMSNo.Text = Convert.ToString(tobeSent()); lblSMSSent.Text = Convert.ToString(sentMsg()); })); for (int i = 0; i < dataToSend.Rows.Count; i++) { string mobileno = Convert.ToString(dataToSend.Rows[i]["mobile"]); string msg = Convert.ToString(dataToSend.Rows[i]["msg"]); int msgsID = Convert.ToInt32(dataToSend.Rows[i]["msgsID"]); sms.SendMessage(mobileno, msg, true); markSent(msgsID); lblSMSSent.Invoke(new MethodInvoker(delegate { lblSMSSent.Text = Convert.ToString(sentMsg()); })); Thread.Sleep(2000); } sendingProcess = false; sms.CloseModemCommunication(); }
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; } }
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 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) { Properties.Settings.Default.rfidPort = cmbRFIDPort.Text; // Properties.Settings.Default.smsPort = cmbSMSPort.Text; Properties.Settings.Default.Save(); Box.infoBox("Ports successfully saved."); }
public void processSave() { if (id > 0) { con = Connection.con(); con.Open(); passDataAllFields(); std.update(con, id); con.Close(); con.Dispose(); Box.infoBox("Data successfully updated."); } else { con = Connection.con(); con.Open(); passDataAllFields(); if (std.insert(con) > 0) { id = Helper.returnLastInsertID(con); Box.infoBox("Data successfully saved."); } con.Close(); con.Dispose(); } }
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 btnSave_Click(object sender, EventArgs e) { Properties.Settings.Default.server = txtServer.Text; Properties.Settings.Default.database = txtDatabase.Text; Properties.Settings.Default.dbuser = txtUser.Text; Properties.Settings.Default.dbpwd = txtPwd.Text; Properties.Settings.Default.Save(); Box.infoBox("Settings saved"); this.Close(); }
private void btnDelete_Click(object sender, EventArgs e) { if (Box.questionBox("Are you sure you want to delete this data?", "DELETE?")) { con = Connection.con(); con.Open(); std.delete(con, Convert.ToInt32(flx[flx.RowSel, "id"])); con.Close(); con.Dispose(); Box.infoBox("Row successfully deleted."); loaddata(); } }
void processSave() { int posid = cat.getID(cmbPosition.Text); if (id > 0) { con = Connection.con(); con.Open(); query = "update phonebook set lname = ?lname, fname=?fname, mname=?mname," + " mobileNo = ?mobile, positionID=?posid where phonebookID=?id"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?lname", txtlname.Text.Trim()); cmd.Parameters.AddWithValue("?fname", txtfname.Text.Trim()); cmd.Parameters.AddWithValue("?mname", txtmname.Text.Trim()); cmd.Parameters.AddWithValue("?mobile", txtContact.Text); cmd.Parameters.AddWithValue("?posid", posid); cmd.Parameters.AddWithValue("?id", id); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Box.infoBox("Contact successfully updated!"); _frm.loaddata(); this.Close(); } else { con = Connection.con(); con.Open(); query = "insert into phonebook set lname = ?lname, fname=?fname, mname=?mname, " + "mobileNo = ?mobile, positionID=?posid"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?lname", txtlname.Text.Trim()); cmd.Parameters.AddWithValue("?fname", txtfname.Text.Trim()); cmd.Parameters.AddWithValue("?mname", txtlname.Text.Trim()); cmd.Parameters.AddWithValue("?mobile", txtContact.Text); cmd.Parameters.AddWithValue("?posid", posid); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Box.infoBox("Contact successfully saved!"); _frm.loaddata(); this.Close(); } }
void processSave() { if (id > 0) { //update con = Connection.con(); con.Open(); query = "update academicyear set ayCode=?aycode, ayDesc=?aydesc, semester=?sem where academicyearID=?id"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?aycode", txtAYCode.Text); cmd.Parameters.AddWithValue("?aydesc", txtAYDesc.Text); cmd.Parameters.AddWithValue("?sem", txtSemester.Text); //if (checkActive.Checked) { cmd.Parameters.AddWithValue("?active", 1); } //else { cmd.Parameters.AddWithValue("?active", 0); } cmd.Parameters.AddWithValue("?id", id); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Box.infoBox("Academic year successfully updated."); _frm.loaddata(); this.Close(); } else { //insert con = Connection.con(); con.Open(); query = "insert into academicyear set ayCode=?aycode, ayDesc=?aydesc, semester=?sem"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?aycode", txtAYCode.Text); cmd.Parameters.AddWithValue("?aydesc", txtAYDesc.Text); cmd.Parameters.AddWithValue("?sem", txtSemester.Text); //bool duerme = false; //if (checkActive.Checked) { cmd.Parameters.AddWithValue("?active", 1); } //else { cmd.Parameters.AddWithValue("?active", 0); } cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Box.infoBox("Academic year successfully saved."); _frm.loaddata(); this.Close(); } }
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 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."); } }
void processSave() { if (id > 0) { con = Connection.con(); con.Open(); query = "UPDATE rooms SET roomCode=?roomcode, roomDesc=?roomdesc, teacherID=?tid WHERE roomID=?rid"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?roomcode", txtRoomCode.Text.Trim()); cmd.Parameters.AddWithValue("?roomdesc", txtRoomDesc.Text.Trim()); cmd.Parameters.AddWithValue("?tid", txtTeacherID.Text); cmd.Parameters.AddWithValue("?rid", id); int i = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); if (i > 0) { Box.infoBox("Room successfully updated."); } } else { con = Connection.con(); con.Open(); query = "INSERT INTO rooms SET roomCode=?roomcode, roomDesc=?roomdesc, teacherID=?tid"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?roomcode", txtRoomCode.Text.Trim()); cmd.Parameters.AddWithValue("?roomdesc", txtRoomDesc.Text.Trim()); cmd.Parameters.AddWithValue("?tid", txtTeacherID.Text); int i = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); if (i > 0) { Box.infoBox("Room successfully saved."); } } }
void processSave() { con = Connection.con(); con.Open(); int ayid = new ClassAcademicYear().getID(con, cmbAY.Text); query = "insert into ay_students set id=?id, academicyearID=?ayid"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?id", id); cmd.Parameters.AddWithValue("?ayid", ayid); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Box.infoBox("Student validated successfully."); clear(); }
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 btnModify_Click(object sender, EventArgs e) { try { if (flx.Rows.Count > 1) { RoomAdd frm = new RoomAdd(this); frm.id = Convert.ToInt32(flx[flx.RowSel, "roomID"]); frm.ShowDialog(); } else { Box.infoBox("No data found."); } } catch (Exception er) { Box.errBox(er.Message); // throw; } }
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(); } } }
void processSave() { int posid = cat.getID(cmbPosition.Text); if (id > 0) { con = Connection.con(); con.Open(); if (update(posid) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully updated."); } else { con.Close(); con.Dispose(); Box.errBox("Something went wrong. Please contact System Administrator."); } } else { con = Connection.con(); con.Open(); if (insert(posid) > 0) { con.Close(); con.Dispose(); Box.infoBox("Data successfully saved."); } else { con.Close(); con.Dispose(); Box.errBox("Something went wrong. Please contact System Administrator."); } } }
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 btnSetActive_Click(object sender, EventArgs e) { try { con = Connection.con(); con.Open(); query = "update academicyear set active = 0; update academicyear set active = 1 where academicyearID=?id"; cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?id", Convert.ToInt32(flx[flx.RowSel, "academicyearID"])); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Dispose(); con.Close(); Box.infoBox("Set active successfully."); loaddata(); } catch (Exception er) { Box.errBox(er.Message); // throw; } }