void getData(string rfid, string aycode)
{
pictureBox1.Image = null;
dtStd.Clear();
dtStd = student.dtStudent(rfid, aycode);
if (dtStd.Rows.Count > 0)
{
id = (int)dtStd.Rows[0]["id"];
txtStudentID.Text = Convert.ToString(dtStd.Rows[0]["studentID"]);
txtLname.Text = Convert.ToString(dtStd.Rows[0]["lname"]);
txtFname.Text = Convert.ToString(dtStd.Rows[0]["fname"]);
txtMname.Text = Convert.ToString(dtStd.Rows[0]["mname"]);
txtSex.Text = Convert.ToString(dtStd.Rows[0]["sex"]);
txtGrade.Text = Convert.ToString(dtStd.Rows[0]["grade"]) + " - " + Convert.ToString(dtStd.Rows[0]["section"]);
// txtProgram.Text = (string)dtStd.Rows[0]["progCode"];
// txtDesc.Text = (string)dtStd.Rows[0]["progDesc"];
// txtYearlvl.Text = Convert.ToString(dtStd.Rows[0]["yearlvl"]);
student.studentImage(pictureBox1, dtStd, "img");
//insert student logs for SMS
//queue
insertForSMS();
id = 0;
}
else
{
clearFields();
}
}
void getData()
{
DataTable dt = new DataTable();
dt = std.dtStudent(txtRFID.Text);
if (dt.Rows.Count > 0)
{
//txtRFID.Text = Convert.ToString(dt.Rows[0]["rfid"]);
id = Convert.ToInt32(dt.Rows[0]["id"]);
txtStudentID.Text = Convert.ToString(dt.Rows[0]["studentID"]);
//txtLRN.Text = Convert.ToString(dt.Rows[0]["lrn"]);
txtLname.Text = Convert.ToString(dt.Rows[0]["lname"]);
txtFname.Text = Convert.ToString(dt.Rows[0]["fname"]);
txtMname.Text = Convert.ToString(dt.Rows[0]["mname"]);
txtSex.Text = Convert.ToString(dt.Rows[0]["sex"]);
txtGrade.Text = Convert.ToString(dt.Rows[0]["grade"]);
txtSection.Text = Convert.ToString(dt.Rows[0]["section"]);
// txtProgram.Text = Convert.ToString(dt.Rows[0]["progCode"]);
// txtDesc.Text = Convert.ToString(dt.Rows[0]["progDesc"]);
// txtYearlvl.Text = Convert.ToString(dt.Rows[0]["yearlvl"]);
txtguardian.Text = Convert.ToString(dt.Rows[0]["guardian"]);
// txtc.Text = Convert.ToString(dt.Rows[0]["mobileNo"]);
std.studentImage(picStudent, dt, "img");
}
else
{
clear();
}
}
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;
}
}
public void getData()
{
DataTable dt = new DataTable();
dt = std.dtStudent(id);
if (dt.Rows.Count > 0)
{
tempRFID = txtRFID.Text = Convert.ToString(dt.Rows[0]["rfid"]);
txtStudentID.Text = Convert.ToString(dt.Rows[0]["studentID"]);
txtLRN.Text = Convert.ToString(dt.Rows[0]["lrn"]);
txtlname.Text = Convert.ToString(dt.Rows[0]["lname"]);
txtfname.Text = Convert.ToString(dt.Rows[0]["fname"]);
txtmname.Text = Convert.ToString(dt.Rows[0]["mname"]);
cmbSex.Text = Convert.ToString(dt.Rows[0]["sex"]);
cmbGrade.Text = Convert.ToString(dt.Rows[0]["grade"]);
cmbSection.Text = Convert.ToString(dt.Rows[0]["section"]);
// cmbProgram.Text = Convert.ToString(dt.Rows[0]["progCode"]);
// txtyrlvl.Text = Convert.ToString(dt.Rows[0]["yearlvl"]);
tempMobile = txtContact.Text = Convert.ToString(dt.Rows[0]["mobileNo"]);
tempParentMobile = txtParentsContact.Text = Convert.ToString(dt.Rows[0]["pMobileNo"]);
txtguardian.Text = Convert.ToString(dt.Rows[0]["guardian"]);
std.studentImage(picStudent, dt, "img");
}
}
