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;
}
}
