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