/// <summary>
/// Created by: Josephine Monteza
/// Date Created: 07/May/2014
/// Description: Export Report
/// ----------------------------------------------------
/// </summary>
public bool ExportPDFAll(string exportType, string reportsTitle, string sUserID)
{
try
{
Warning[] warnings = null;
string[] streamIds = null;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filetype = string.Empty;
// just gets the Report title... make your own method
//ReportViewer needs a specific type (not always the same as the extension)
filetype = exportType == "PDF" ? "PDF" : exportType;
string sServerUser = ConfigurationSettings.AppSettings["ReportUser"].ToString();
string sServerPwd = ConfigurationSettings.AppSettings["ReportPwd"].ToString();
string sServerDomain = ConfigurationSettings.AppSettings["ReportDomain"].ToString();
IReportServerCredentials irsc = new ReportCredentials(sServerUser, sServerPwd, sServerDomain);
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
// Create report parameter
ReportParameter paramUser = new ReportParameter();
paramUser.Name = "pUserID";
paramUser.Values.Add(sUserID);
// Set the report parameters for the report
ReportViewer1.ServerReport.SetParameters(
new ReportParameter[] { paramUser });
byte[] bytes = ReportViewer1.ServerReport.Render(filetype, null, // deviceinfo not needed for csv
out mimeType, out encoding, out extension, out streamIds, out warnings);
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.ContentType = mimeType;
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + reportsTitle + "." + exportType);
System.Web.HttpContext.Current.Response.BinaryWrite(bytes);
FileStream fs = new FileStream(Server.MapPath("~/Extract/CrewAdmin/" + reportsTitle + "." + exportType), FileMode.OpenOrCreate);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
System.Web.HttpContext.Current.Response.Flush();
// System.Web.HttpContext.Current.Response.End();
//HttpContext.Current.ApplicationInstance.CompleteRequest();
}
catch (Exception ex)
{
//throw ex;
}
finally
{
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
Reports oReport = new Reports(0, dsn);
if (Request.QueryString["r"] != null && Request.QueryString["r"] != "")
{
try
{
Variables oVariable = new Variables(intEnvironment);
Functions oFunction = new Functions(0, dsn, intEnvironment);
int intReport = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["r"]));
string strReport = oReport.Get(intReport, "path");
string strPhysical = oReport.Get(intReport, "physical");
if (strReport != "")
{
ReportViewer1.Visible = true;
bool boolOLD = (oReport.Get(intReport, "old") == "1");
string strURL = "";
if (boolOLD == false)
{
DataSet dsKey = oFunction.GetSetupValuesByKey(Environment.MachineName + "_REPORTING");
if (dsKey.Tables[0].Rows.Count > 0)
{
strURL = dsKey.Tables[0].Rows[0]["Value"].ToString();
}
}
//else
// strURL = oVariable.DefaultReportURL_OLD();
if (strURL != "")
{
Uri u = new Uri(strURL);
ReportViewer1.ServerReport.ReportServerUrl = u;
ReportViewer1.ServerReport.ReportPath = strReport;
ReportCredentials oReportCredential = new ReportCredentials(0, dsn, intEnvironment);
ReportViewer1.ServerReport.ReportServerCredentials = oReportCredential;
ReportViewer1.ZoomPercent = 10;
ReportViewer1.ShowToolBar = false;
ReportViewer1.WaitMessageFont.Size = FontUnit.XXSmall;
ReportViewer1.SizeToReportContent = true;
}
else
{
divNA.Visible = true;
}
}
else
{
divNA.Visible = true;
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Reports oReport = new Reports(0, dsn);
if (!IsPostBack)
{
if (Request.QueryString["n"] != null && Request.QueryString["n"] != "")
{
try
{
Variables oVariable = new Variables(intEnvironment);
Functions oFunction = new Functions(0, dsn, intEnvironment);
string strURL = "";
DataSet dsKey = oFunction.GetSetupValuesByKey(Environment.MachineName + "_REPORTING");
if (dsKey.Tables[0].Rows.Count > 0)
{
strURL = dsKey.Tables[0].Rows[0]["Value"].ToString();
}
if (strURL != "")
{
Uri u = new Uri(strURL);
ReportViewer1.ServerReport.ReportServerUrl = u;
ReportViewer1.ServerReport.ReportPath = "/Project Reports/Infrastructure Project Status Scorecard";
ReportViewer1.ShowParameterPrompts = false;
ReportCredentials oReportCredential = new ReportCredentials(0, dsn, intEnvironment);
ReportViewer1.ServerReport.ReportServerCredentials = oReportCredential;
ReportParameter[] parameters = new ReportParameter[1];
parameters[0] = new ReportParameter("Project", oFunction.decryptQueryString(Request.QueryString["n"]));
ReportViewer1.ServerReport.SetParameters(parameters);
ReportViewer1.ZoomPercent = 100;
ReportViewer1.ServerReport.Refresh();
panShow.Visible = true;
}
else
{
Response.Write("Invalid Reporting URL ~ " + Environment.MachineName + "_REPORTING");
}
}
catch (Exception ex)
{
panError.Visible = true;
Response.Write(ex.Message);
}
}
}
}
/// <summary>
/// Created by: Josephine Monteza
/// Date Created: 07/May/2014
/// Description: Export Report
/// ----------------------------------------------------
/// </summary>
public bool ExportPDFCrewverification(string exportType, string reportsTitle, string SeafareID, string LOENumber, string joindate, string Vessel, string Port)
{
try
{
List <SeafarerImage> SeafarerImage = new List <SeafarerImage>();
MGW.QRCode.Codec.QRCodeEncoder rq = new MGW.QRCode.Codec.QRCodeEncoder();
System.Drawing.Bitmap myImage;
List <CrewImmigration> Immigration = new List <CrewImmigration>();
DateTime Mydate = new DateTime();
Mydate = GlobalCode.Field2DateTime(joindate);
myImage = rq.Encode(SeafareID + "+" + LOENumber + "+" + Mydate.ToString("MMMM") + " " + Mydate.Day.ToString() + " " + Mydate.Year.ToString() + "+" + Vessel + "+" + Port);
SeafarerImage.Add(new SeafarerImage
{
Image = GlobalCode.Field2BitmapByte(myImage),
ImageType = "jpg",
LOENumber = LOENumber,
SeaparerID = GlobalCode.Field2Long(SeafareID),
LogInUser = GlobalCode.Field2String(Session["UserName"])
});
TRAVELMART.BLL.ImmigrationBLL BLL = new TRAVELMART.BLL.ImmigrationBLL();
BLL.InsertQRCode(SeafarerImage);
Warning[] warnings = null;
string[] streamIds = null;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filetype = string.Empty;
// just gets the Report title... make your own method
//ReportViewer needs a specific type (not always the same as the extension)
filetype = exportType == "PDF" ? "PDF" : exportType;
string sServerUser = ConfigurationSettings.AppSettings["ReportUser"].ToString();
string sServerPwd = ConfigurationSettings.AppSettings["ReportPwd"].ToString();
string sServerDomain = ConfigurationSettings.AppSettings["ReportDomain"].ToString();
IReportServerCredentials irsc = new ReportCredentials(sServerUser, sServerPwd, sServerDomain);
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportParameter[] ParamReport = new ReportParameter[2];
ParamReport[0] = new ReportParameter("pSeafarerID", SeafareID);
ParamReport[1] = new ReportParameter("pLOEControlNumber", LOENumber);
//// Create report parameter
//ReportParameter ParamReport = new ReportParameter();
//ParamReport.Name = "pSeafarerID";
//ParamReport.Values.Add(SeafareID);
//ParamReport.Name = "pLOEControlNumber";
//ParamReport.Values.Add(LOENumber);
ReportViewer1.ServerReport.SetParameters(ParamReport);
//paramUser.Values.Add(sUserID);
// Set the report parameters for the report
//ReportViewer1.ServerReport.SetParameters(
// new ReportParameter[] { ParamReport });
byte[] bytes = ReportViewer1.ServerReport.Render(filetype, null, // deviceinfo not needed for csv
out mimeType, out encoding, out extension, out streamIds, out warnings);
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.ContentType = mimeType;
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + reportsTitle + "." + exportType);
System.Web.HttpContext.Current.Response.BinaryWrite(bytes);
FileStream fs = new FileStream(Server.MapPath("~/Extract/Immigration/" + reportsTitle + "." + exportType), FileMode.OpenOrCreate);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
System.Web.HttpContext.Current.Response.Flush();
// System.Web.HttpContext.Current.Response.End();
//HttpContext.Current.ApplicationInstance.CompleteRequest();
}
catch (Exception ex)
{
//throw ex;
}
finally
{
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
Reports oReport = new Reports(0, dsn);
if (!IsPostBack)
{
int intApplication = -1;
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (intApplication > -1 && Request.QueryString["r"] != null && Request.QueryString["r"] != "")
{
try
{
Variables oVariable = new Variables(intEnvironment);
Functions oFunction = new Functions(0, dsn, intEnvironment);
int intReport = Int32.Parse(oFunction.decryptQueryString(Request.QueryString["r"]));
string strReport = oReport.Get(intReport, "path");
if (strReport != "")
{
bool boolOLD = (oReport.Get(intReport, "old") == "1");
string strURL = "";
if (boolOLD == false)
{
DataSet dsKey = oFunction.GetSetupValuesByKey(Environment.MachineName + "_REPORTING");
if (dsKey.Tables[0].Rows.Count > 0)
{
strURL = dsKey.Tables[0].Rows[0]["Value"].ToString();
}
}
//else
// strURL = oVariable.DefaultReportURL_OLD();
if (strURL != "")
{
Uri u = new Uri(strURL);
ReportViewer1.ServerReport.ReportServerUrl = u;
ReportViewer1.ServerReport.ReportPath = strReport;
ReportCredentials oReportCredential = new ReportCredentials(0, dsn, intEnvironment);
ReportViewer1.ServerReport.ReportServerCredentials = oReportCredential;
ReportViewer1.ZoomPercent = Int32.Parse(oReport.Get(intReport, "percentage"));
if (oReport.Get(intReport, "application") == "1")
{
ReportParameter[] parameters = new ReportParameter[1];
parameters[0] = new ReportParameter("applicationid", intApplication.ToString());
ReportViewer1.ServerReport.SetParameters(parameters);
// ???
ReportViewer1.ServerReport.Refresh();
}
}
else
{
Response.Write("Invalid Reporting URL ~ " + Environment.MachineName + "_REPORTING");
}
}
else
{
Response.Write("Invalid Report Path");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
}
