private void button6_Click(object sender, EventArgs e) { _report a = new _report(); string iQry = @"select date `DATE`, code `CODE`, establishment_name `ESTABLISHMENT`, acronym `ACRONYM`, tin `TIN`, contact_person `CONTACT_PERSON`, tel `TEL`, type `TYPE` from rwa where date between '{0}' and '{1}'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["rwaReport"].TableName); _cr_rwa rep = new _cr_rwa(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void kasReport() { _report a = new _report(); string iQry = @"select date, code, concat(surname, ', ', firstname, ' ', middlename) name, brgy, sex, cp_no, status, remarks from kasambahay2 where date between '{0}' and '{1}' and brgy like '%%{2}%%'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["kasReport"].TableName); _cr_kasReport rep = new _cr_kasReport(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void button6_Click(object sender, EventArgs e) { _report a = new _report(); string iQry = @"select date, code, concat(surname, ', ', firstname, ' ', middlename) name, address, gender, disability, remarks from pwd where date between '{0}' and '{1}'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["pwdReport"].TableName); _cr_pwd rep = new _cr_pwd(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void button3_Click(object sender, EventArgs e) { _report a = new _report(); a.qry = @"select code `CODE`, surname `SURNAME`, firstname `FIRSTNAME`, middlename `MIDDLENAME`, suffix `SUFFIX`, brgy `BARANGAY` from contacts"; a.ShowDialog(); }
private void button6_Click_1(object sender, EventArgs e) { _report a = new _report(); reportQuery st = new reportQuery(); string iQry = string.Format(st.graphAll, this.dateTimePicker1.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(iQry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["graph"].TableName); _cr_GraphStat rep = new _cr_GraphStat(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void collReporty() { _report a = new _report(); string iQry = @"SELECT date `DATE`, code `CODE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, sex `GENDER`, dob `BOD`, mother `MOTHERNAME`, father `FATHERNAME`, brgy `ADDRESS`, cp_no `CONTACT`, school `SCHOOL`, yearlevel `YEAR`, ave `AVE`, status `STATUS` FROM schoolar_coll where date between '{0}' and '{1}' and brgy like '%%{2}%%' and school like '%%{3}%%' and status like '%%{4}%%' group by code"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.Text, textBox6.Text, comboBox1.Text); string datasetTable = "colReport"; dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables[datasetTable].TableName); _cr_colReport2 rep = new _cr_colReport2(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void button6_Click(object sender, EventArgs e) { _report a = new _report(); string iQry = @"SELECT (select min(event_date) from sra where event_date between '{0}' and '{1}') `min`, (select max(event_date) from sra where event_date between '{0}' and '{1}') `max`, agency, sra_no, host, veneu, address_branch, rep_contact, concat(surname, ', ', firstname, ' ', middlename) `name`, address, age, gender, `position`, jobsite, remarks FROM sra where event_date between '{0}' and '{1}' and agency like '%%{2}%%' and sra_no like '%%{3}%%' group by agency"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, textBox1.Text, textBox2.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["sraReport"].TableName); _cr_sraReport rep = new _cr_sraReport(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void nsrpReport() { _report a = new _report(); string iQry = @"SELECT date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM ofw2 where date between '{0}' and '{1}' order by date"; dataset ds = new dataset(); string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["nsrpReport"].TableName); _cr_nsrp rep = new _cr_nsrp(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void button6_Click(object sender, EventArgs e) { _report a = new _report(); string iQry = @"SELECT event_date, event, host, veneu, concat(surname, ', ', firstname, ' ', middlename) `name`, gender, purok, address, dob, contact, work_type FROM child_labor where event_date between '{0}' and '{1}' and event like '%%{2}%%' and host like '%%{3}%%' and veneu like '%%{4}%%' and address like '%%{6}%%' and concat(surname, firstname, middlename) like '%%{5}%%'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, comboBox5.Text); string datasetTable = "childLaborReport"; dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables[datasetTable].TableName); _cr_childLaborReport rep = new _cr_childLaborReport(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void ofwReport() { _report a = new _report(); string iQry = @"select date, code, concat(surname, ', ', firstname, ' ', middlename) name, brgy `address`, sex `gender`, country, passport, type, cp_no `contact_no`, status, remarks from ofw2 where date between '{0}' and '{1}' and brgy like '%%{2}%%' and status like '%%{3}%%' "; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.Text, comboBox2.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["ofwReport"].TableName); _cr_ofw rep = new _cr_ofw(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void jfReport() { _report a = new _report(); string iQry = @"SELECT (select min(event_date) from jobfair2 where event_date between '{0}' and '{1}') `min`, (select max(event_date) from jobfair2 where event_date between '{0}' and '{1}') `max`, event_date, host, concat(surname, ', ', firstname, ' ', middlename) `name`, brgy `address`, sex `gender`, cp_no `tel_no`, position `job_position`, hiring_company, jobsite `location`, `status`, remarks FROM jobfair2 where event_date between '{0}' and '{1}' and host like '%%{2}%%'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, textBox1.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["jobFair"].TableName); _cr_jobFair rep = new _cr_jobFair(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
private void button5_Click_1(object sender, EventArgs e) { _report a = new _report(); string iQry = @"select * from ( SELECT date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, birthplace `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM schoolar_coll union all SELECT event_date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM sra2 union all SELECT event_date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM jobfair2 union all SELECT date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM kasambahay2 union all SELECT date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM ofw2 union all SELECT date `DATE`, concat(surname, ', ', firstname, ' ', middlename) `NAME`, dob `BIRTHDAY`, age `AGE`, IF(sex = 'MALE','M','F') `GENDER`, civil_status `CIVIL STATUS`, religion `RELIGION`, 'BIRTHPLACE' `BIRTHPLACE`, concat(brgy, ', ' , municipality, ', ', province) `ADDRESS`, email `EMAIL`, cp_no `CONTACT`, `4ps` `4Ps`, emp_status `EMP. STATUS`, job_pre `JOB PREF.`, educ_level `EDUC. LEVEL`, skills `SKILLS`, `from` `FROM` FROM contact2 ) fin order by date"; dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(iQry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["nsrpReport"].TableName); _cr_nsrp rep = new _cr_nsrp(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }