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