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