private void btnnew_Click(object sender, EventArgs e)
{
inc = 0;
sql = "SELECT * FROM tblitems";
config.Load_DTG(sql, dtglist);
maxcolumn = dtglist.Columns.Count - 1;
dtglist.Columns[maxcolumn].Visible = false;
btnadd.Visible = false;
select_navigation("SELECT ITEMID FROM tblitems");
lblmax.Text = maxrow.ToString();
lblinc.Text = inc.ToString();
sql = "SELECT DESCRIPTION FROM `tblsettings` WHERE `PARA`='CATEGORY'";
config.fiil_CBO(sql, cbotype);
sql = "SELECT DESCRIPTION FROM `tblsettings` WHERE `PARA`='Unit'";
config.fiil_CBO(sql, cbounit);
funct.clearTxt(pnl_stockmaster);
}
private void cboLevel_SelectedValueChanged(object sender, EventArgs e)
{
sql = "SELECT `SUBJ_CODE` as 'Subject', `SUBJ_DESCRIPTION` as 'Description' FROM `subject` WHERE `YR` = '" + cboLevel.Text + "'";
config.Load_DTG(sql, dtgSubject);
dtgSubject.Font = new Font("Arial", 9);
sql = "SELECT `SECTION` FROM `tblsection` WHERE LEVEL='" + cboLevel.Text + "'";
config.fiil_CBO(sql, cbosection);
}
private void frmReports_Load(object sender, EventArgs e)
{
sql = "SELECT `LEVEL` FROM `level`";
config.fiil_CBO(sql, cboLevel);
sql = "SELECT `ACADYR` FROM `ay`";
config.fiil_CBO(sql, cbosy);
sql = "SELECT `SECTION` FROM `tblsection` WHERE LEVEL='" + cboLevel.Text + "'";
config.fiil_CBO(sql, cbo_section);
}
private void tsNew_Click(object sender, EventArgs e)
{
sql = "SELECT ACADYR FROM ay";
config.fiil_CBO(sql, cbosy);
sql = "SELECT LEVEL FROM level";
config.fiil_CBO(sql, cboYear);
txtsubjDesc.Clear();
txtsujCode.Clear();
txtsujCode.Focus();
}
private void txtSubjectID_TextChanged(object sender, EventArgs e)
{
sql = "SELECT ACADYR FROM ay";
config.fiil_CBO(sql, cbosy);
sql = "SELECT LEVEL FROM level";
config.fiil_CBO(sql, cboYear);
sql = "SELECT * FROM `subject` WHERE `SUBJ_ID`='" + txtSubjectID.Text + "'";
config.singleResult(sql);
txtsujCode.Text = config.dt.Rows[0].Field <string>("SUBJ_CODE");
txtsubjDesc.Text = config.dt.Rows[0].Field <string>("SUBJ_DESCRIPTION");
cboYear.Text = config.dt.Rows[0].Field <string>("YR");
}
private void btnNew_Click(object sender, EventArgs e)
{
sql = "SELECT * FROM items";
config.Load_DTG(sql, dtgList);
select_navigation("SELECT ITEMID FROM items");
sql = "SELECT DESCRIPTION FROM `settings` WHERE `PARA`='CATEGORY'";
config.fiil_CBO(sql, type);
sql = "SELECT DESCRIPTION FROM `settings` WHERE `PARA`='Unit'";
config.fiil_CBO(sql, units);
funct.clearTxt(pnl_productManager);
}
private void frmSection_Load(object sender, EventArgs e)
{
sql = "SELECT `SECTIONID` as 'ID', `SECTION`,LEVEL FROM `tblsection`";
config.Load_DTG(sql, dtgList);
txtSection.Clear();
txtSection.Focus();
id = "0";
sql = "SELECT `LEVEL` FROM `level`";
config.fiil_CBO(sql, cboLevel);
}
private void tsNew_Click(object sender, EventArgs e)
{
func.clearTxt(GroupBox1);
txtStudentId.Clear();
rdoMale.Checked = true;
rdoFemale.Checked = false;
chkBirthCert.Checked = false;
chkPic.Checked = false;
chkReportCard.Checked = false;
chkCertification.Checked = false;
sql = "SELECT ACADYR FROM ay";
config.fiil_CBO(sql, cboAddSy);
}
private void txtStudentId_TextChanged(object sender, EventArgs e)
{
sql = "SELECT ACADYR FROM ay";
config.fiil_CBO(sql, cboAddSy);
sql = "SELECT * FROM tblstudent WHERE IDNO = '" + txtStudentId.Text + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
txtFName.Text = config.dt.Rows[0].Field <string>("FNAME");
txtLName.Text = config.dt.Rows[0].Field <string>("LNAME");
txtMName.Text = config.dt.Rows[0].Field <string>("MNAME");
txtAddress.Text = config.dt.Rows[0].Field <string>("HOME_ADD");
txtguardian.Text = config.dt.Rows[0].Field <string>("GUARDIAN");
txtguardianadd.Text = config.dt.Rows[0].Field <string>("GUARDIAN_ADD");
txtguardiantel.Text = config.dt.Rows[0].Field <int>("GUARDIAN_TEL").ToString();
txtPBirth.Text = config.dt.Rows[0].Field <string>("BPLACE");
dtpDbirth.Text = config.dt.Rows[0].Field <DateTime>("BDAY").ToString();
txtAge.Text = config.dt.Rows[0].Field <int>("AGE").ToString();
txtWeigth.Text = config.dt.Rows[0].Field <int>("WEIGTH").ToString();
txtHeight.Text = config.dt.Rows[0].Field <int>("HEIGTH").ToString();
txtLastSchoolAttend.Text = config.dt.Rows[0].Field <string>("LASTSCHOOLATTEND");
if (config.dt.Rows[0].Field <string>("SEX") == "FEMALE")
{
rdoFemale.Checked = true;
}
else
{
rdoMale.Checked = true;
}
// 'students requirements
sql = "SELECT * FROM `tblrequirements` WHERE IDNO = '" + txtStudentId.Text + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
if (config.dt.Rows[0].Field <string>("NSO") == "Yes")
{
chkBirthCert.Checked = true;
}
else
{
chkBirthCert.Checked = false;
}
if (config.dt.Rows[0].Field <string>("PICID") == "Yes")
{
chkPic.Checked = true;
}
else
{
chkPic.Checked = false;
}
if (config.dt.Rows[0].Field <string>("REPORTCARD") == "Yes")
{
chkReportCard.Checked = true;
}
else
{
chkReportCard.Checked = false;
}
if (config.dt.Rows[0].Field <string>("CERTIFICATE_OF_TRANSFER") == "Yes")
{
chkCertification.Checked = true;
}
else
{
chkCertification.Checked = false;
}
}
}
}