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