//GET: api/Reports/M
public string Get(string id)
{
Telerik.Reporting.Report report = null;
switch (id)
{
case "L":
{
report = new LeadsReport();
break;
}
case "C":
{
report = new CustomerReport();
break;
}
case "A":
{
report = new AdminTeamMemberReport();
break;
}
}
var path = CreatePath(id, report?.Name);
CreatePdfFile(report, path.Item1);
return(path.Item2);
}
protected void RaporuOlustur()
{
//Create new CultureInfo
var cultureInfo = new System.Globalization.CultureInfo("tr-TR");
// Set the language for static text (i.e. column headings, titles)
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
// Set the language for dynamic text (i.e. date, time, money)
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
EFDal ed = new EFDal();
var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = new KalibrasyonRaporlari.PersGetiriAnaliz();
this.rptPersonelGetiri.ReportSource = instanceReportSource;
Telerik.Reporting.Report report = (Telerik.Reporting.Report)instanceReportSource.ReportDocument;
report.ReportParameters["BolgeKodu"].Value = Convert.ToInt32(Session["dshBolgeKodu"].ToString());//ed.kal_BolgeKoduDon(Context.User.Identity.Name);
report.ReportParameters["BasTar"].Value = DateTime.Parse(Session["dshBasTar"].ToString());
report.ReportParameters["SonTar"].Value = DateTime.Parse(Session["dshSonTar"].ToString());
report.ReportParameters["Personel"].Value = Context.User.Identity.Name;
Telerik.Reporting.TextBox txtReportHeader = report.Items.Find("txtReportHeader", true)[0] as Telerik.Reporting.TextBox;
txtReportHeader.Value = report.ReportParameters["BasTar"].Value.ToString().Replace(" 00:00:00", "") + " ve " + report.ReportParameters["SonTar"].Value.ToString().Replace(" 00:00:00", "") +
" tarihleri arasında gerçekleştirilen kalibrasyonları aşağıda görebilirsiniz";
}
private void ImprimirXLS(ArrayList ALValorParametrosInternos, Type instance)
{
try
{
Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
report1.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("XLS", report1, null);
string ruta = Server.MapPath("Reportes") + "\\" + instance.Name + ".xls";
if (File.Exists(ruta))
{
File.Delete(ruta);
}
FileStream fs = new FileStream(ruta, FileMode.Create);
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
fs.Flush();
fs.Close();
RAM1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
}
catch (Exception ex)
{
throw ex;
}
}
private DataSet DriverGradingDetail(Telerik.Reporting.Report currentReport)
{
DataAccess.IGPS dacGPS = new DataAccess.GPS();
DateTime fromDate = Convert.ToDateTime(currentReport.ReportParameters["StartDate"].Value);
DateTime toDate = Convert.ToDateTime(currentReport.ReportParameters["EndDate"].Value);
Int32 orgUnitId = Convert.ToInt32(currentReport.ReportParameters["OrgUnitID"].Value);
return(dacGPS.CANGetDriverGradingDetail(orgUnitId, fromDate, toDate));
}
private void CreatePdfFile(Telerik.Reporting.Report report, string reportName)
{
var processor = new ReportProcessor();
var result = processor.RenderReport("PDF", report, null);
using (var pdfStream = new MemoryStream(result.DocumentBytes))
using (var reportFile = new FileStream(Path.Combine(GetReportFilePath(), reportName), FileMode.Create))
{
pdfStream.CopyTo(reportFile);
}
}
private static void ExportToPDF(Report report, string exportPath)
{
var reportProcessor = new ReportProcessor();
var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
using (var fs = new FileStream(exportPath, FileMode.Create))
{
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
ReportViewer1.Report = new rptBreakage();
DateTime dateFrom = Convert.ToDateTime(txtStartDate.Text);
DateTime?dateTo = null;
if (txtEndDate.Text != "")
{
dateTo = Convert.ToDateTime(txtEndDate.Text);
}
int item = Convert.ToInt32(ddlItem.SelectedValue);
int set = Convert.ToInt32(ddlSet.SelectedValue);
int machine = Convert.ToInt32(ddlMachine.SelectedValue);
int pOperator = Convert.ToInt32(ddlMachine.SelectedValue);
int company = Convert.ToInt16(Session["CompanyID"]);
(ReportViewer1.Report as rptBreakage).paramDateFrom = dateFrom; //UniqueCode.GetDateFormat_MM_dd_yyy(txtStartDate.Text);
(ReportViewer1.Report as rptBreakage).paramDateTo = dateTo;
(ReportViewer1.Report as rptBreakage).paramItem = item;
(ReportViewer1.Report as rptBreakage).paramSet = set;
(ReportViewer1.Report as rptBreakage).paramMachine = machine;
(ReportViewer1.Report as rptBreakage).paramOperator = pOperator;
(ReportViewer1.Report as rptBreakage).companyId = company;
Telerik.Reporting.Report report = (Telerik.Reporting.Report) this.ReportViewer1.Report;
Telerik.Reporting.TextBox txt = report.Items.Find("dtFrom", true)[0] as Telerik.Reporting.TextBox;
Telerik.Reporting.TextBox txt1 = report.Items.Find("dtTo", true)[0] as Telerik.Reporting.TextBox;
txt.Value = dateFrom.ToString("dd-MM-yyyy");
string edate = dateTo != null?dateTo.Value.ToString("dd-MM-yyyy") : "";
if (txtEndDate.Text != "")
{
txt1.Value = "To " + edate;
}
else
{
txt1.Value = edate;
}
ReportViewer1.RefreshReport();
}
catch (Exception ex)
{
ex.ToString();
}
}
public static Telerik.Reporting.Report GenerateReport(string ReportName, string appCssPath, dynamic ReportParams)
{
Telerik.Reporting.Report rpt = new Telerik.Reporting.Report();
_appCssPath = appCssPath;
try
{
//rpt = GetInstance <Telerik.Reporting.Report>(Type.GetType(ReportName), paramObject);
rpt = GetReportInstance(ReportName, ReportParams);
return(rpt);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void RaporuOlustur()
{
//Create new CultureInfo
var cultureInfo = new System.Globalization.CultureInfo("tr-TR");
// Set the language for static text (i.e. column headings, titles)
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
// Set the language for dynamic text (i.e. date, time, money)
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
EFDal ed = new EFDal();
var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
//instanceReportSource.ReportDocument = new KalibrasyonReportLibrary.Egitimler();
instanceReportSource.ReportDocument = new KalibrasyonRaporlari.Egitimler();
this.rptEgitimler.ReportSource = instanceReportSource;
Telerik.Reporting.Report report = (Telerik.Reporting.Report)instanceReportSource.ReportDocument;
/*
* report.ReportParameters["BolgeKodu"].Value = ed.kal_BolgeKoduDon(Context.User.Identity.Name);
* report.ReportParameters["BasTar"].Value = DateTime.Parse("2015-01-01");
* report.ReportParameters["BitTar"].Value = DateTime.Parse("2015-06-01");
*/
report.ReportParameters["BolgeKodu"].Value = Convert.ToInt32(Session["dshBolgeKodu"].ToString());//ed.kal_BolgeKoduDon(Context.User.Identity.Name);
report.ReportParameters["BasTar"].Value = DateTime.Parse(Session["dshBasTar"].ToString());
report.ReportParameters["BitTar"].Value = DateTime.Parse(Session["dshSonTar"].ToString());
//report.ReportParameters["SeciliDonemGetirisi"].Value = ed.EgitimRaporuIcinSeciliDonemGetirisiDon(Convert.ToInt32(Session["dshBolgeKodu"].ToString()), DateTime.Parse(Session["dshBasTar"].ToString()), DateTime.Parse(Session["dshSonTar"].ToString()));
report.ReportParameters["SeciliDonemGetirisi"].Value = ed.EgitimRaporuIcinSeciliDonemGetirisiDon(Convert.ToInt32(report.ReportParameters["BolgeKodu"].Value), DateTime.Parse(report.ReportParameters["BasTar"].Value.ToString()), DateTime.Parse(report.ReportParameters["BitTar"].Value.ToString()));
//report.ReportParameters["Personel"].Value = Context.User.Identity.Name;
Telerik.Reporting.TextBox txtAciklama = report.Items.Find("txtAciklama", true)[0] as Telerik.Reporting.TextBox;
txtAciklama.Value = report.ReportParameters["BasTar"].Value.ToString().Replace(" 00:00:00", "") + " ve " + report.ReportParameters["BitTar"].Value.ToString().Replace(" 00:00:00", "") +
" tarihleri arasında bölgelere ait özet eğitim bilgisini aşağıda görebilirsiniz";
}
protected void RaporuOlustur()
{
//Create new CultureInfo
var cultureInfo = new System.Globalization.CultureInfo("tr-TR");
// Set the language for static text (i.e. column headings, titles)
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
// Set the language for dynamic text (i.e. date, time, money)
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
EFDal ed = new EFDal();
var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = new KalibrasyonRaporlari.CihazBazli();
this.rptCihazBazli.ReportSource = instanceReportSource;
Telerik.Reporting.Report report = (Telerik.Reporting.Report)instanceReportSource.ReportDocument;
/*
* report.ReportParameters["BolgeKodu"].Value = Convert.ToInt32(Session["dshBolgeKodu"].ToString());//ed.kal_BolgeKoduDon(Context.User.Identity.Name);
* report.ReportParameters["BasTar"].Value = DateTime.Parse("2015-01-01");
* report.ReportParameters["SonTar"].Value = DateTime.Parse("2015-06-01");
* //report.ReportParameters["Personel"].Value = Context.User.Identity.Name;
*/
report.ReportParameters["BolgeKodu"].Value = Convert.ToInt32(Session["dshBolgeKodu"].ToString());//ed.kal_BolgeKoduDon(Context.User.Identity.Name);
report.ReportParameters["BasTar"].Value = DateTime.Parse(Session["dshBasTar"].ToString());
report.ReportParameters["SonTar"].Value = DateTime.Parse(Session["dshSonTar"].ToString());
Telerik.Reporting.TextBox txtAciklama = report.Items.Find("txtAciklama", true)[0] as Telerik.Reporting.TextBox;
txtAciklama.Value = ed.BolgeKodundanBolgeAdiniDon(Convert.ToInt32(report.ReportParameters["BolgeKodu"].Value.ToString())) + " bölgesinde, " + report.ReportParameters["BasTar"].Value.ToString().Replace(" 00:00:00", "") + " ve " + report.ReportParameters["SonTar"].Value.ToString().Replace(" 00:00:00", "") +
" tarihleri arasında yapılan kalibrasyonların cihazlar üzerine dağılımını aşağıda görebilirsiniz";
}
private void frmMain_Load(object sender, EventArgs e)
{
buttonClose.Left = this.Width - buttonClose.Width;
string[] args = Environment.GetCommandLineArgs();
_whichReport = int.Parse(args[1]);
switch (_whichReport)
{
case 1:
WaldenReports.LabatoryRequest
report1 = new WaldenReports.LabatoryRequest();
_theReport = new WaldenReports.LabatoryRequest();
Telerik.Reporting.TextBox _patientTextBox = new Telerik.Reporting.TextBox();
_patientTextBox = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPatientName"];
_patientTextBox.Value = args[2];
report1.DataSource =
OrderOutsideServicesList.ServiceListing;
reportViewer1.Report = report1;
reportViewer1.RefreshReport();
break;
case 2:
break;
case 3:
break;
default:
//Console.WriteLine("Invalid selection. Please select 1, 2, or 3.");
break;
}
}
void ExportToPDF(Telerik.Reporting.Report reportToExport)
{
ReportProcessor reportProcessor = new ReportProcessor();
Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = reportToExport;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
string fileName = result.DocumentName + "." + result.Extension;
Response.Clear();
Response.ContentType = result.MimeType;
Response.Cache.SetCacheability(HttpCacheability.Private);
Response.Expires = -1;
Response.Buffer = true;
Response.AddHeader("Content-Disposition",
string.Format("{0};FileName=\"{1}\"",
"attachment",
fileName));
Response.BinaryWrite(result.DocumentBytes);
Response.End();
}
public MemoryStream CreateCoverSheetV2(string _faxTo, string _faxNumber, int _pageCount,
string notes, string from, int whichCoverSheet)
{
MemoryStream _stream = null;
int _totalFaxPages = _pageCount + 1;
//whichCoverSheet = 2;
try
{
switch (whichCoverSheet)
{
case 1:
report1 = new WaldenReports.CtOrthoFaxCover1();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 2:
report1 = new WaldenReports.CtOrthoFaxCover2();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 3:
report1 = new WaldenReports.CtOrthoFaxCover3();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 4:
report1 = new WaldenReports.FaxCoverCtOrtho2();
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 7:
report1 = new WaldenReports.GenericCoverLetter();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
_practiceName = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPracticeName"];
_practiceName.Value = string.Empty;
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
default:
break;
}//end switch statement
//Process();
_stream = ExportToPDF(report1);
return _stream;
}
catch (Exception er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
return _stream;
}
}
public MemoryStream CreateCoverSheetV2(string _faxTo, string _faxNumber, int _pageCount,
string notes, string from, int whichCoverSheet)
{
MemoryStream _stream = null;
int _totalFaxPages = _pageCount + 1;
//whichCoverSheet = 7;
try
{
switch (whichCoverSheet)
{
case 1:
report1 = new WaldenReports.CtOrthoFaxCover1();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 2:
report1 = new WaldenReports.CtOrthoFaxCover2();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 3:
report1 = new WaldenReports.CtOrthoFaxCover3();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 4:
report1 = new WaldenReports.FaxCoverCtOrtho2();
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
case 7:
report1 = new WaldenReports.GenericCoverLetter();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
_practiceName = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPracticeName"];
_practiceName.Value = string.Empty;
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + from;
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + notes;
}
catch { }
break;
default:
break;
}//end switch statement
//Process();
_stream = ExportToPDF(report1);
return _stream;
}
catch (Exception er)
{
//Common.Log("CreateCoverSheet: " + er.Message);
return _stream;
}
}
protected void RadBtnSaveLetter_Click(object sender, EventArgs e)
{
//Saving
strMagnumID = Request.QueryString["MagnumID"].ToString();
strQuoteAuditID = Request.QueryString["QuoteAuditID"].ToString();
string strQuoteOptionAuditTrailIDO1 = "0";
string strQuoteOptionAuditTrailIDO2 = "0";
string strQuoteOptionAuditTrailIDO3 = "0";
string strQuoteOptionAuditTrailIDO4 = "0";
string strQuoteOptionAuditTrailIDO5 = "0";
string strMessageMain = string.Empty;
string strMessage = string.Empty;
int intcheckCount = 0;
try
{
Telerik.Web.UI.RadGrid OptionsGrid = (Telerik.Web.UI.RadGrid)RadPanelBar1.FindItemByValue("PanelItem1").FindControl("RadGridOptions");
#region "Get options"
foreach (GridDataItem item in OptionsGrid.Items)
{
if ((item.FindControl("CheckBoxSelect") as System.Web.UI.WebControls.CheckBox).Checked == true)
{
intcheckCount += 1;
#region "Old"
//switch (item.Cells[3].Text.Trim())
//{
// case "1":
// if (strQuoteOptionAuditTrailIDO1 == "0")
// strQuoteOptionAuditTrailIDO1 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "2":
// if (strQuoteOptionAuditTrailIDO2 == "0")
// strQuoteOptionAuditTrailIDO2 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "3":
// if (strQuoteOptionAuditTrailIDO3 == "0")
// strQuoteOptionAuditTrailIDO3 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "4":
// if (strQuoteOptionAuditTrailIDO4 == "0")
// strQuoteOptionAuditTrailIDO4 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "5":
// if (strQuoteOptionAuditTrailIDO5 == "0")
// strQuoteOptionAuditTrailIDO5 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
//}
#endregion
switch (intcheckCount)
{
case 1:
strQuoteOptionAuditTrailIDO1 = item.Cells[2].Text;
break;
case 2:
strQuoteOptionAuditTrailIDO2 = item.Cells[2].Text;
break;
case 3:
strQuoteOptionAuditTrailIDO3 = item.Cells[2].Text;
break;
case 4:
strQuoteOptionAuditTrailIDO4 = item.Cells[2].Text;
break;
case 5:
strQuoteOptionAuditTrailIDO5 = item.Cells[2].Text;
break;
}
}
}
#endregion
DataSet DS = new DataSet();
#region "SQL"
SqlConnection sqlConnectionX;
SqlCommand sqlCommandX;
SqlParameter sqlParam;
SqlDataReader sqlDR;
sqlConnectionX = new SqlConnection(ConfigurationManager.AppSettings["SQLConnection"]);
sqlConnectionX.Open();
sqlCommandX = new SqlCommand();
sqlCommandX.Connection = sqlConnectionX;
sqlCommandX.CommandType = CommandType.StoredProcedure;
sqlCommandX.CommandText = "spx_SELECT_QuoteDetailByAuditTrailID_Detailed";
sqlParam = new SqlParameter("QuoteAuditTrailID", strQuoteAuditID);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption1ID", strQuoteOptionAuditTrailIDO1);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption2ID", strQuoteOptionAuditTrailIDO2);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption3ID", strQuoteOptionAuditTrailIDO3);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption4ID", strQuoteOptionAuditTrailIDO4);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption5ID", strQuoteOptionAuditTrailIDO5);
sqlCommandX.Parameters.Add(sqlParam);
sqlDR = sqlCommandX.ExecuteReader();
DataTable dt = new DataTable("Info");
dt.Load(sqlDR);
DS.Tables.Add(dt);
sqlDR.Close();
sqlCommandX.Cancel();
sqlCommandX.Dispose();
#endregion
// Creating and configuring the ObjectDataSource component:
var objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = DS; // GetData returns a DataSet with three tables
//objectDataSource.DataMember = "Product"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
//objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("FullName", typeof(string), "=Fields.Name + ' ' + Fields.ProductNumber")); // Adding a sample calculated field.
// Creating a new report
Telerik.Reporting.Report report = new Telerik.Reporting.Report();
//if ((dt.Rows[0][36].ToString() == "ok") && (dt.Rows[0][37].ToString() == "ok"))
//{
// report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
//}
//if (dt.Rows[0][36].ToString() != "ok")
//{
// report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
//}
//if (dt.Rows[0][37].ToString() != "ok")
//{
// report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
//}
//Telerik.Reporting.Report report = new Telerik.Reporting.Report();
if (((dt.Rows[0][36].ToString() == "ok") && (dt.Rows[0][37].ToString() == "ok")) || ((dt.Rows[0][72].ToString() != "FDB") && (dt.Rows[0][73].ToString() != "FDB")))
{
//Both quoteLife and QuoteDisability were selected
if ((dt.Rows[0][42].ToString() == "1") && (dt.Rows[0][43].ToString() == "1"))
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
//if only QuoteLife was selected
if ((dt.Rows[0][42].ToString() == "1") && (dt.Rows[0][43].ToString() == "0"))
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
//if only QuoteDisability was selected
if ((dt.Rows[0][42].ToString() == "0") && (dt.Rows[0][43].ToString() == "1"))
{
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisOnly"));
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
}
else
{
//2015-10-12 - changed to include if user selects ADB or ACDB then show both life and disability
//if (dt.Rows[0][36].ToString() != "ok")
//{
// report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
//}
//if (dt.Rows[0][37].ToString() != "ok")
//{
// report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
//}
if (dt.Rows[0][36].ToString() != "ok")
{
if (dt.Rows[0][72].ToString() == "FDB")
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
}
else
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
}
if (dt.Rows[0][37].ToString() != "ok")
{
if (dt.Rows[0][73].ToString() == "FDB")
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
else
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
}
}
DateTime now = DateTime.Now;
//Console.WriteLine("Today is " + now.ToString("MMMM dd, yyyy") + ".");
report.DocumentName = now.ToString("ddMMhhmm") + "_" + strMagnumID + "_Quote requested";
// Assigning the ObjectDataSource component to the DataSource property of the report.
report.DataSource = objectDataSource;
// Use the InstanceReportSource to pass the report to the viewer for displaying
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = report;
string fileName = report.DocumentName + ".PDF";
//string path = System.IO.Path.GetTempPath();
//string strFolder = "~/files/";
//string month = dateTime.ToString("MMMM");
int intMonth = System.DateTime.Now.Month;
string strMonth = intMonth.ToString();
if (intMonth < 10)
strMonth = "0" + intMonth.ToString();
string path = Server.MapPath("~/files/");
path += now.ToString("yyyy") + "\\" + strMonth;
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);
}
string filePath = System.IO.Path.Combine(path, fileName);
ReportProcessor reportProcessor = new ReportProcessor();
Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
using (FileStream fs = new FileStream(filePath, FileMode.Create))
{
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}
#region "Insert File location into DB"
sqlCommandX = new SqlCommand();
sqlCommandX.Connection = sqlConnectionX;
sqlCommandX.CommandType = CommandType.StoredProcedure;
sqlCommandX.CommandText = "spx_INSERT_QuoteFile";
sqlParam = new SqlParameter("QuoteAuditTrailID", strQuoteAuditID);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteFile", filePath);
sqlCommandX.Parameters.Add(sqlParam);
sqlCommandX.ExecuteNonQuery();
sqlDR.Close();
sqlCommandX.Cancel();
sqlCommandX.Dispose();
#endregion
sqlConnectionX.Close();
HiddenFieldSavedFileName.Value = filePath;
//Color color = (Color)ColorConverter.ConvertFromString("#00CC00");
System.Drawing.Color col = System.Drawing.ColorTranslator.FromHtml("#00CC00");
lblInfo.ForeColor = col;
lblInfo.Text = "File saved successfully";
RadBtnEmail.Visible = true;
}
catch (Exception ex)
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = ex.Message;
}
}
private void LoadReport()
{
strMagnumID = Request.QueryString["MagnumID"].ToString();
strQuoteAuditID = Request.QueryString["QuoteAuditID"].ToString();
string strQuoteOptionAuditTrailIDO1 = "0";
string strQuoteOptionAuditTrailIDO2 = "0";
string strQuoteOptionAuditTrailIDO3 = "0";
string strQuoteOptionAuditTrailIDO4 = "0";
string strQuoteOptionAuditTrailIDO5 = "0";
string strMessageMain = string.Empty;
string strMessage = string.Empty;
bool blnContinue = true;
int intcheckCount = 0;
intUserID = Convert.ToInt32(Session["UserID"]);
Telerik.Web.UI.RadGrid OptionsGrid = (Telerik.Web.UI.RadGrid)RadPanelBar1.FindItemByValue("PanelItem1").FindControl("RadGridOptions");
foreach (GridDataItem item in OptionsGrid.Items)
{
if ((item.FindControl("CheckBoxSelect") as System.Web.UI.WebControls.CheckBox).Checked == true)
{
intcheckCount += 1;
#region "Old"
//switch (item.Cells[3].Text.Trim())
//{
// case "1":
// if (strQuoteOptionAuditTrailIDO1 == "0")
// strQuoteOptionAuditTrailIDO1 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "2":
// if (strQuoteOptionAuditTrailIDO2 == "0")
// strQuoteOptionAuditTrailIDO2 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "3":
// if (strQuoteOptionAuditTrailIDO3 == "0")
// strQuoteOptionAuditTrailIDO3 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "4":
// if (strQuoteOptionAuditTrailIDO4 == "0")
// strQuoteOptionAuditTrailIDO4 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
// case "5":
// if (strQuoteOptionAuditTrailIDO5 == "0")
// strQuoteOptionAuditTrailIDO5 = item.Cells[2].Text;
// else
// {
// blnContinue = false;
// }
// break;
//}
#endregion
switch (intcheckCount)
{
case 1:
strQuoteOptionAuditTrailIDO1 = item.Cells[2].Text;
break;
case 2:
strQuoteOptionAuditTrailIDO2 = item.Cells[2].Text;
break;
case 3:
strQuoteOptionAuditTrailIDO3 = item.Cells[2].Text;
break;
case 4:
strQuoteOptionAuditTrailIDO4 = item.Cells[2].Text;
break;
case 5:
strQuoteOptionAuditTrailIDO5 = item.Cells[2].Text;
break;
}
}
}
if (intcheckCount > 5)
blnContinue = false;
if (blnContinue == false)
{
//lblInfo.Text = "You can only select one item for each option, please check the options";
lblInfo.Text = "You can only select a maximum of 5 options";
ReportViewer1.Visible = false;
ReportViewer1.ReportSource = null;
}
else
{
RadBtnSaveLetter.Visible = true;
//RadBtnEmail.Visible = true;
DataSet DS = new DataSet();
#region "Old Code"
////Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
////instanceReportSource.ReportDocument = new Report.QuoteLetter();
////this.ReportViewer1.ReportSource = instanceReportSource;
//DataTable SummaryDT = new DataTable();
//DataColumn DT1 = new DataColumn("Scenario");
//DataColumn DT2 = new DataColumn("Premium [Total]");
//DataColumn DT3 = new DataColumn("CoverAmount [Life]");
//DataColumn DT4 = new DataColumn("Premium [Life] incl. DC fee");
//DataColumn DT5 = new DataColumn("CoverAmount [Disability]");
//DataColumn DT6 = new DataColumn("Premium [Disability] incl. DC fee");
////DT1.DataType = System.Type.GetType("System.String");
//SummaryDT.Columns.Add(DT1);
//SummaryDT.Columns.Add(DT2);
//SummaryDT.Columns.Add(DT3);
//SummaryDT.Columns.Add(DT4);
//SummaryDT.Columns.Add(DT5);
//SummaryDT.Columns.Add(DT6);
//DataRow row = SummaryDT.NewRow();
//row[DT1] = "Option 1";
//row[DT2] = "";
//row[DT3] = "";
//row[DT4] = "";
//row[DT5] = "";
//row[DT6] = "";
//SummaryDT.Rows.Add(row);
//DS.Tables.Add(SummaryDT);
#endregion
#region "SQL"
SqlConnection sqlConnectionX;
SqlCommand sqlCommandX;
SqlParameter sqlParam;
SqlDataReader sqlDR;
sqlConnectionX = new SqlConnection(ConfigurationManager.AppSettings["SQLConnection"]);
sqlConnectionX.Open();
sqlCommandX = new SqlCommand();
sqlCommandX.Connection = sqlConnectionX;
sqlCommandX.CommandType = CommandType.StoredProcedure;
sqlCommandX.CommandText = "spx_SELECT_QuoteDetailByAuditTrailID_Detailed";
sqlParam = new SqlParameter("QuoteAuditTrailID", strQuoteAuditID);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption1ID", strQuoteOptionAuditTrailIDO1);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption2ID", strQuoteOptionAuditTrailIDO2);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption3ID", strQuoteOptionAuditTrailIDO3);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption4ID", strQuoteOptionAuditTrailIDO4);
sqlCommandX.Parameters.Add(sqlParam);
sqlParam = new SqlParameter("QuoteOption5ID", strQuoteOptionAuditTrailIDO5);
sqlCommandX.Parameters.Add(sqlParam);
sqlDR = sqlCommandX.ExecuteReader();
DataTable dt = new DataTable("Info");
dt.Load(sqlDR);
DS.Tables.Add(dt);
sqlDR.Close();
sqlCommandX.Cancel();
sqlCommandX.Dispose();
sqlConnectionX.Close();
#endregion
// Creating and configuring the ObjectDataSource component:
var objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = DS; // GetData returns a DataSet with three tables
//objectDataSource.DataMember = "Product"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
//objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("FullName", typeof(string), "=Fields.Name + ' ' + Fields.ProductNumber")); // Adding a sample calculated field.
// Creating a new report
Telerik.Reporting.Report report = new Telerik.Reporting.Report();
//Telerik.Reporting.Report report = new Telerik.Reporting.Report();
if (((dt.Rows[0][36].ToString() == "ok") && (dt.Rows[0][37].ToString() == "ok")) || ((dt.Rows[0][72].ToString() != "FDB") && (dt.Rows[0][73].ToString() != "FDB")))
{
//Both quoteLife and QuoteDisability were selected
if ((dt.Rows[0][42].ToString() == "1") && (dt.Rows[0][43].ToString() == "1"))
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
//if only QuoteLife was selected
if ((dt.Rows[0][42].ToString() == "1") && (dt.Rows[0][43].ToString() == "0"))
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
//if only QuoteDisability was selected
if ((dt.Rows[0][42].ToString() == "0") && (dt.Rows[0][43].ToString() == "1"))
{
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisOnly"));
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
//report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
}
else
{
if (dt.Rows[0][36].ToString() != "ok")
{
if (dt.Rows[0][72].ToString() == "FDB")
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterDisabilityOnly"));
}
else
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
}
if (dt.Rows[0][37].ToString() != "ok")
{
if (dt.Rows[0][73].ToString() == "FDB")
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetterLifeOnly"));
}
else
{
report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
}
}
}
report.DocumentName = strMagnumID;
// Assigning the ObjectDataSource component to the DataSource property of the report.
report.DataSource = objectDataSource;
// Use the InstanceReportSource to pass the report to the viewer for displaying
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = report;
// Assigning the report to the report viewer.
ReportViewer1.ReportSource = reportSource;
ReportViewer1.RefreshReport();
//ReportViewer1.RefreshData();
////Saving
//string fileName = report.DocumentName + ".PDF";
//string path = System.IO.Path.GetTempPath();
//string filePath = System.IO.Path.Combine(path, fileName);
//ReportProcessor reportProcessor = new ReportProcessor();
//Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
//instanceReportSource.ReportDocument = report;
//RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
//using (FileStream fs = new FileStream(filePath, FileMode.Create))
//{
// fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
//}
//Telerik.Reporting.Report report = (Telerik.Reporting.Report)Activator.CreateInstance(System.Reflection.Assembly.Load("Report").GetType("Report.QuoteLetter"));
////report.DocumentName = strTemplateName;
////report.DataSource = DS;
//ReportViewer1.ReportSource = report;
//var typeReportSource = new Telerik.Reporting.TypeReportSource();
//typeReportSource.TypeName = "Telerik.Reporting.Examples.CSharp.ListBoundReport, CSharp.ReportLibrary";
//this.ReportViewer1.ReportSource = typeReportSource;
}
}
private void CreateCoverSheet(string _faxTo,string _faxNumber)
{
try
{
switch (_whichCoverPage)
{
case 1:
report1 = new WaldenReports.NvobgynCover1();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
try
{
//_to.Value = " " + txtFaxName.Text;
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + txtFrom.Text;
}
catch { }
try
{
_pages.Value = " " + _faxing.FaxPageCount.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
//_faxPhone.Value = " " + txtFaxNumber.Text;
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + txtNotes.Text;
}
catch { }
// _to.Value = "To: " + txtFaxName.Text;
// _from.Value = "From: " + comboUsers.Text; ;
// _pages.Value = "Pages: " + txtPages.Text;
// _faxPhone.Value = "Phone: " + txtFaxNumber.Text;
// _notes.Value = "Notes: " + txtNotes.Text;
break;
case 2:
report1 = new WaldenReports.GenericCoverLetter();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
_practiceName = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPracticeName"];
_practiceName.Value = Common.PracticeName;
try
{
//_to.Value = " " + txtFaxName.Text;
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + txtFrom.Text;
}
catch { }
try
{
_pages.Value = " " + _faxing.FaxPageCount.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
//_faxPhone.Value = " " + txtFaxNumber.Text;
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + txtNotes.Text;
}
catch { }
//_to.Value = " " + txtFaxName.Text;
//_from.Value = " " + comboUsers.Text; ;
//_pages.Value = " " + _faxing.FaxPageCount.ToString();
//_faxPhone.Value = " " + txtFaxNumber.Text;
//_notes.Value = " " + txtNotes.Text;
break;
case 3:
report1 = new WaldenReports.FaxCoverCtOrtho();
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
//_to.Value = " " + txtFaxName.Text;
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + txtFrom.Text;
}
catch { }
try
{
_pages.Value = " " + _faxing.FaxPageCount.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
//_faxPhone.Value = " " + txtFaxNumber.Text;
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + txtNotes.Text;
}
catch { }
break;
case 4:
report1 = new WaldenReports.FaxCoverCtOrtho2();
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
//_to.Value = " " + txtFaxName.Text;
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + txtFrom.Text;
}
catch { }
try
{
_pages.Value = " " + _faxing.FaxPageCount.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
//_faxPhone.Value = " " + txtFaxNumber.Text;
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + txtNotes.Text;
}
catch { }
break;
default:
break;
}//end switch statement
MemoryStream oStream = ExportToPDF(report1);
FileStream _presStream = new FileStream(Common.StoreComputer
+ Common.StoreShare + Common.IndividualPath
+ "\\cover.pdf", FileMode.Create);
oStream.WriteTo(_presStream);
oStream.Close();
_presStream.Close();
}
catch (Exception er)
{
Common.Log("CreateCoverSheet: " + er.Message);
}
}
private MemoryStream CreateCoverSheet(string _faxTo, string _faxNumber, int _pageCount)
{
MemoryStream _stream = null;
int _totalFaxPages = _pageCount + 1;
int _whichCoverPage = 4;
try
{
switch (_whichCoverPage)
{
case 1:
report1 = new WaldenReports.NvobgynCover1();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + "From";
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + "Notes";
}
catch { }
break;
case 2:
report1 = new WaldenReports.FaxCoverCtOrtho();
try
{
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
string s1 = er.Message;
}
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + "From";
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + "Notes";
}
catch { }
break;
case 3:
report1 = new WaldenReports.GenericCoverLetter();
_to = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
_practiceName = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPracticeName"];
//_practiceName.Value = Common.PracticeName;
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + "From";
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + "Notes";
}
catch { }
break;
case 4:
report1 = new WaldenReports.FaxCoverCtOrtho2();
_to = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
_from = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
_pages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
_faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
_notes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
_to.Value = " " + _faxTo;
}
catch { }
try
{
_from.Value = " " + "From";
}
catch { }
try
{
_pages.Value = " " + _totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
_faxPhone.Value = " " + _faxNumber;
}
catch { }
try
{
_notes.Value = " " + "Notes";
}
catch { }
break;
default:
break;
}//end switch statement
Process();
_stream = ExportToPDF(report1);
return _stream;
}
catch (Exception er)
{
Walden.CompleteFax.Library.Database.Log(er.Message);
//Common.Log("CreateCoverSheet: " + er.Message);
return _stream;
}
}
public MemoryStream CreateCoverSheetV2(string faxToName, string faxNumber, int pageCount,
string notes, string from, int whichCoverSheet)
{
MemoryStream stream = null;
int totalFaxPages = pageCount + 1;
try
{
switch (whichCoverSheet)
{
case 1:
report1 = new WaldenReports.CtOrthoFaxCover1();
try
{
faxTo = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxFrom = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxNotes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxTo.Value = " " + faxToName;
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxFrom.Value = " " + from;
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPages.Value = " " + totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPhone.Value = " " + faxNumber;
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxNotes.Value = " " + notes;
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
break;
case 2:
report1 = new WaldenReports.CtOrthoFaxCover2();
try
{
faxTo = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxFrom = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxNotes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxTo.Value = " " + faxToName;
}
catch { }
try
{
faxFrom.Value = " " + from;
}
catch { }
try
{
faxPages.Value = " " + totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
faxPhone.Value = " " + faxNumber;
}
catch { }
try
{
faxNotes.Value = " " + notes;
}
catch { }
break;
case 3:
report1 = new WaldenReports.CtOrthoFaxCover3();
try
{
faxTo = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxFrom = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxNotes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
}
catch (System.StackOverflowException er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
try
{
faxTo.Value = " " + faxToName;
}
catch { }
try
{
faxFrom.Value = " " + from;
}
catch { }
try
{
faxPages.Value = " " + totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
faxPhone.Value = " " + faxNumber;
}
catch { }
try
{
faxNotes.Value = " " + notes;
}
catch { }
break;
case 4:
report1 = new WaldenReports.FaxCoverCtOrtho2();
faxTo = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtTo"];
faxFrom = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFrom"];
faxPages = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPages"];
faxPhone = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtFaxPhone"];
faxNotes = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtNote"];
try
{
faxTo.Value = " " + faxToName;
}
catch { }
try
{
faxFrom.Value = " " + from;
}
catch { }
try
{
faxPages.Value = " " + totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
faxPhone.Value = " " + faxNumber;
}
catch { }
try
{
faxNotes.Value = " " + notes;
}
catch { }
break;
case 7:
report1 = new WaldenReports.GenericCoverLetter();
faxTo = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtTo"];
faxFrom = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFrom"];
faxPages = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtPages"];
faxPhone = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtFaxPhone"];
faxNotes = (Telerik.Reporting.TextBox)report1.Items[1].Items["txtNote"];
practiceName = (Telerik.Reporting.TextBox)report1.Items[0].Items["txtPracticeName"];
practiceName.Value = string.Empty;
try
{
faxTo.Value = " " + faxToName;
}
catch { }
try
{
faxFrom.Value = " " + from;
}
catch { }
try
{
faxPages.Value = " " + totalFaxPages.ToString()
+ " (including cover sheet)";
}
catch { }
try
{
faxPhone.Value = " " + faxNumber;
}
catch { }
try
{
faxNotes.Value = " " + notes;
}
catch { }
break;
default:
break;
}//end switch statement
//Process();
stream = ExportToPdf(report1);
return stream;
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return stream;
}
}