public clsReportAttachementComplexType GetReportAttachement()
        {
            try
            {
                TopCareDataContext db = new TopCareDataContext();
                Attachment a;

                _tempSchedule = db.Schedules.FirstOrDefault(sch => sch.ScheduleID == ScheduleID);

                LocalReport lr = new LocalReport();
                lr.ReportPath = HttpContext.Current.Server.MapPath(reportPath);

                TopCareDataSetTableAdapters.ScheduleDetailsTableAdapter ta1 = new TopCareDataSetTableAdapters.ScheduleDetailsTableAdapter();
                TopCareDataSetTableAdapters.SchedulesTableAdapter ta2 = new TopCareDataSetTableAdapters.SchedulesTableAdapter();

                //int scheduleID = Convert.ToInt32(Request.QueryString["sID"]);

                ReportDataSource ds1 = new ReportDataSource("DataSet1", (System.Data.DataTable)ta2.GetDataByScheduleID(ScheduleID));
                ReportDataSource ds2 = new ReportDataSource("DataSet2", (System.Data.DataTable)ta1.GetDataByScheduleID(ScheduleID));

                lr.DataSources.Add(ds1);
                lr.DataSources.Add(ds2);

                Warning[] warnings;
                string[] streamids;
                string mimeType;
                string encoding;
                string extension;

                byte[] bytes = lr.Render("PDF", null, out mimeType,
                        out encoding, out extension, out streamids, out warnings);

                MemoryStream s = new MemoryStream(bytes);
                s.Seek(0, SeekOrigin.Begin);

                string _attachmentFileName = String.Format("Charisma Programe Outline-{0}.pdf", _tempSchedule.DateOfEvent.Value.ToShortDateString());

                //create instance of attachement and initialize it
                a = new Attachment(s, _attachmentFileName);

                return new clsReportAttachementComplexType() { AttachedFileContent = a, AttachedFileName = _attachmentFileName };
            }
            catch (Exception)
            {
                return null;
            }
        }
 partial void DeleteSchedule(Schedule instance);
 partial void UpdateSchedule(Schedule instance);
 partial void InsertSchedule(Schedule instance);