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