public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport4 rpt = new CrystalReport4();
rpt.Site = this.Site;
return(rpt);
}
private void CRReloader()
{
calendar1.Visible = true;
try
{
if (comboBox1.Text == "View all readings in a selected date" || comboBox1.Text == "Average Per Hour")
{
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm120Years);
calendar1.OnlyMonthMode = true;
if (comboBox1.Text == "View all readings in a selected date")
{
PictureLoad();
string source = "SELECT [Systolic],[Diastolic],[CDate],[CTime],[Status] from Record WHERE [PatientID] = '" + MainForm.patientID + "' and [CDate] = #" + calendar1.SelectedDate + "#";
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport1 rep = new CrystalReport1();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
else if (comboBox1.Text == "Average Per Hour")
{
PictureLoad();
string source = "SELECT Sys, Dias, Hour, CDate, Stat From HourTable Where PatientID ='" + MainForm.patientID + "' and CDate = #" + calendar1.SelectedDate + "#";
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport2 rep = new CrystalReport2();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
}
else if (comboBox1.Text == "Average Per Month")
{
PictureLoad();
calendar1.OnlyMonthMode = false;
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm120Years);
string source = "SELECT Sys, Dias, Month, Year, Stat From MonthTable Where PatientID ='" + MainForm.patientID + "' and Year = " + calendar1.SelectedDate.Year;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport3 rep = new CrystalReport3();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
else if (comboBox1.Text == "Average Per Year")
{
PictureLoad();
calendar1.OnlyMonthMode = false;
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm120Years);
string source = "SELECT Sys, Dias, Year, Stat From YearTable Where PatientID ='" + MainForm.patientID + "' and Year BETWEEN " + calendar1.year1 + " and " + calendar1.year12;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport4 rep = new CrystalReport4();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
}
catch (Exception)
{
MessageBox.Show("Invalid operation has been detected!");
Application.Exit();
}
}
