public ActionResult ExportXls()
{
StiReport report = this.GetReport();
StiReportResponse.ResponseAsXls(report);
return(View());
}
protected void ButtonExport_Click(object sender, EventArgs e)
{
StiReport report = new StiReport();
DataSet data = new DataSet();
report.Load(Server.MapPath(String.Format("Reports\\{0}.mrt", ListBoxReports.SelectedItem.Text)));
data.ReadXml(Server.MapPath(@"Data\Demo.xml"));
report.RegData(data);
switch (ListBoxFormats.SelectedIndex)
{
case 0:
StiReportResponse.ResponseAsPdf(report);
break;
case 1:
StiReportResponse.ResponseAsHtml(report);
break;
case 2:
StiReportResponse.ResponseAsXls(report);
break;
case 3:
StiReportResponse.ResponseAsText(report);
break;
case 4:
StiReportResponse.ResponseAsRtf(report);
break;
}
}
public ActionResult PrintHtml()
{
StiReport report = this.GetReport();
StiReportResponse.PrintAsHtml(report);
return(View());
}
protected void ButtonExport_Click(object sender, EventArgs e)
{
var report = new StiReport();
report.Load(Server.MapPath($"Reports\\{ListBoxReports.SelectedItem.Text}.mrt"));
switch (ListBoxFormats.SelectedIndex)
{
case 0:
StiReportResponse.ResponseAsPdf(report);
break;
case 1:
StiReportResponse.ResponseAsHtml(report);
break;
case 2:
StiReportResponse.ResponseAsXls(report);
break;
case 3:
StiReportResponse.ResponseAsText(report);
break;
case 4:
StiReportResponse.ResponseAsRtf(report);
break;
}
}
protected void ButtonExport_Click(object sender, EventArgs e)
{
StiWebViewer1.Visible = false;
StiWebDesigner1.Visible = false;
var dashboard = Dashboard.CreateTemplate(appPath);
StiReportResponse.ResponseAsExcel2007(dashboard);
}
protected void Page_Load(object sender, EventArgs e)
{
Reports.RptTotalDeVendasPorProduto rpt = new Reports.RptTotalDeVendasPorProduto();
rpt.Render();
StiReportResponse.ResponseAsPdf(this, rpt);
}
protected void ButtonExportImage_Click(object sender, EventArgs e)
{
var report = GetTemplate();
StiReportResponse.ResponseAsPng(report);
}
protected void ButtonExportExcel_Click(object sender, EventArgs e)
{
var report = GetTemplate();
StiReportResponse.ResponseAsExcel2007(report);
}
protected void ButtonPrintHtml_Click(object sender, EventArgs e)
{
StiReport report = this.GetReport();
StiReportResponse.PrintAsHtml(report);
}
protected void ButtonPrintPdf_Click(object sender, EventArgs e)
{
var report = this.GetReport();
StiReportResponse.PrintAsPdf(report);
}
protected void grd_CourseList_ItemCommand(object sender, GridCommandEventArgs e)
{
ExamBusiness EBusiness = new ExamBusiness();
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
var ip = (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null &&
HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "")
? HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]
: HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
if (ip.Contains(","))
{
ip = ip.Split(',').First();
}
//DataTable dtdet = new DataTable();
// dtdet = EBusiness.Get_ExamdetailbyDid(int.Parse(e.CommandArgument.ToString()));
if (e.CommandName == "ExamSheet" || e.CommandName == "ExamSheetA4")
{
var did = e.CommandArgument.ToString();
var whichBtn = (e.CommandSource as Button).ID;
DataTable dt1 = new DataTable();
dt1 = EBusiness.ExamAnswerSheetbyDid(did, int.Parse(Session[sessionNames.userID_Karbar].ToString()));
StiReport rpt = new StiReport();
string targetReport = "";
if (whichBtn == "btn_printExamSheet")
{
targetReport = Server.MapPath("../Reports/AnswerSheet1.mrt");
}
else if (whichBtn == "btn_printExamSheetByA4Format")
{
targetReport = Server.MapPath("../Reports/AnswerSheetA4.mrt");
}
rpt.Load(targetReport);
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Supplementary", CB.ReportConnection.ToString()));
if (whichBtn == "btn_printExamSheet")
{
rpt.ReportName = $"{did}-{ddl_ExamDate.SelectedValue}-{ddl_Saate.SelectedValue}-A3";
}
else if (whichBtn == "btn_printExamSheetByA4Format")
{
rpt.ReportName = $"{did}-{ddl_ExamDate.SelectedValue}-{ddl_Saate.SelectedValue}-A4";
}
rpt.ReportCacheMode = StiReportCacheMode.Off;
rpt.Compile();
rpt.CompiledReport.DataSources["[Exam].[SP_ExamAnswerSheetbyDid]"].Parameters["@did"].ParameterValue = did;
rpt.CompiledReport.DataSources["[Exam].[SP_ExamAnswerSheetbyDid]"].Parameters["@ExaminerID"].ParameterValue = int.Parse(Session[sessionNames.userID_Karbar].ToString());
rpt.CompiledReport.DataSources["[Exam].[SP_ExamAnswerSheetbyDid]"].Parameters["@examDate"].ParameterValue = ddl_ExamDate.SelectedValue;
rpt.CompiledReport.DataSources["[Exam].[SP_ExamAnswerSheetbyDid]"].Parameters["@examTime"].ParameterValue = ddl_Saate.SelectedValue;
rpt.RegData(dt1);
StiReportResponse.ResponseAsPdf(this.Page, rpt, true);
CommonBusiness cmnb = new CommonBusiness();
CB.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 68, "چاپ پاسخنامه", int.Parse(e.CommandArgument.ToString()));
}
}
