public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EventReport rpt = new EventReport();
rpt.Site = this.Site;
return(rpt);
}
public EventReportForm(int proj_id, int sch_no, int event_id)
{
InitializeComponent();
DataTable evnt = new DataTable();
DataTable reso = new DataTable();
DataTable serviceEng = new DataTable();
evnt.Columns.Add("event_id", typeof(int));
evnt.Columns.Add("proj_id", typeof(int));
evnt.Columns.Add("visit_type_id", typeof(int));
evnt.Columns.Add("to_date_time", typeof(string));
evnt.Columns.Add("from_date_time", typeof(string));
evnt.Columns.Add("sch_no", typeof(int));
evnt.Columns.Add("feedback", typeof(string));
evnt.Columns.Add("Other", typeof(string));
evnt.Columns.Add("to_do_list", typeof(string));
evnt.Columns.Add("check_list", typeof(string));
evnt.Columns.Add("travelling_mode", typeof(string));
evnt.Columns.Add("accommodation_mode", typeof(string));
evnt.Columns.Add("meals", typeof(string));
evnt.Columns.Add("client_name", typeof(string));
evnt.Columns.Add("proj_name", typeof(string));
evnt.Columns.Add("visit_type", typeof(string));
reso.Columns.Add("name", typeof(string));
reso.Columns.Add("qty", typeof(int));
reso.Columns.Add("event_id", typeof(int));
reso.Columns.Add("proj_id", typeof(int));
reso.Columns.Add("sch_no", typeof(int));
serviceEng.Columns.Add("staff_id", typeof(int));
serviceEng.Columns.Add("name", typeof(string));
serviceEng.Columns.Add("task", typeof(string));
serviceEng.Columns.Add("feedback", typeof(string));
serviceEng.Columns.Add("man_hours", typeof(double));
serviceEng.Columns.Add("event_id", typeof(int));
serviceEng.Columns.Add("sch_no", typeof(int));
serviceEng.Columns.Add("proj_no", typeof(int));
string qry = "select s.visit_type_id, s.to_date_time, s.from_date_time, s.feedback," +
"s.to_do_list, s.check_list, s.travelling_mode, s.accommodation_mode, s.meals, s.Other, p.proj_name, " +
"c.name, v.type " +
"from event s, project p, client c, visit_type v " +
"where (s.sch_no = " + sch_no + " and s.proj_id = " + proj_id + " and s.event_id = " + event_id + ") and (p.proj_id = s.proj_id) and (p.client_id = c.client_id) and (s.visit_type_id = v.visit_type_id);";
try
{
MySqlDataReader reader = DBConnection.getData(qry);
if (reader.HasRows)
{
while (reader.Read())
{
evnt.Rows.Add(event_id, proj_id, reader.GetInt16("visit_type_id"), reader.GetString("from_date_time"), reader.GetString("to_do_list")
, sch_no, reader.GetString("feedback"), reader.GetString("Other"), reader.GetString("to_do_list"), reader.GetString("check_list"), reader.GetString("travelling_mode")
, reader.GetString("accommodation_mode"), reader.GetString("meals"), reader.GetString("name"), reader.GetString("proj_name"), reader.GetString("type"));
}
}
reader.Close();
string qry1 = "select et.staff_id, s.first_name, s.last_name, ett.task, et.feedback, ett.man_hours from event_technicians et, staff s, event_technician_task ett where (ett.event_tech_id = et.event_staff_id) and (et.event_id = " + event_id + " and et.proj_id = " + proj_id + " and et.sch_no = " + sch_no + ") and (et.staff_id = s.staff_id);";
MySqlDataReader reader1 = DBConnection.getData(qry1);
if (reader1.HasRows)
{
while (reader1.Read())
{
serviceEng.Rows.Add(reader1.GetInt16("staff_id"), reader1.GetString("first_name") + " " + reader1.GetString("last_name"), reader1.GetString("task"), reader1.GetString("feedback"), reader1.GetDouble("man_hours"), event_id, sch_no, proj_id);
}
}
string qry2 = "select r.name, sr.qty from resource r, event_resources sr where (sr.proj_id = " + proj_id + " and sr.sch_no = " + sch_no + " and sr.event_id = " + event_id + " ) and (sr.resource_id = r.resource_id)";
reader1.Close();
MySqlDataReader reader2 = DBConnection.getData(qry2);
if (reader2.HasRows)
{
while (reader2.Read())
{
reso.Rows.Add(reader2.GetString("name"), reader2.GetInt16("qty"), event_id, proj_id, sch_no);
}
}
reader2.Close();
EventReport sr = new EventReport();
sr.Database.Tables["schedule"].SetDataSource(evnt);
sr.Database.Tables["scheduleReso"].SetDataSource(reso);
sr.Database.Tables["engineers"].SetDataSource(serviceEng);
crystalReportViewer1.ReportSource = sr;
}
catch (Exception e)
{
throw;
}
}
