protected void Page_Load(object sender, EventArgs e)
{
lblError.Text = string.Empty;
try
{
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string date = DateTime.Now.Day.ToString();
string hours = DateTime.Now.Hour.ToString();
string minute = DateTime.Now.Minute.ToString();
string second = DateTime.Now.Second.ToString();
string fileName = year + month + date + hours + minute + second;
DisableFormat disable = new DisableFormat();
disable.DisableUnwantedExportFormat(rptView, "PDF");
disable.DisableUnwantedExportFormat(rptView, "WORD");
SqlConnection con = new SqlConnection();
try
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString();
con.Open();
string projectCode = Request.QueryString["ProjectCode"];
string customerName_LIKE = Request.QueryString["CustomerName_LIKE"];
if (string.IsNullOrWhiteSpace(projectCode))
{
throw new Exception("No Project Code.");
}
DataTable dt_Header = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_Header]", projectCode, customerName_LIKE);
DataTable dt_TAT = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_TAT]", projectCode, customerName_LIKE);
DataTable dt_Documents = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_Documents]", projectCode, customerName_LIKE);
rptView.LocalReport.DataSources.Clear();
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_Header", dt_Header));
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_TAT", dt_TAT));
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_Documents", dt_Documents));
rptView.LocalReport.DisplayName = "Report_TAT_FinancingApproval_" + fileName;
rptView.LocalReport.Refresh();
rptView.Visible = true;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message + " " + ex.StackTrace;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string date = DateTime.Now.Day.ToString();
string hours = DateTime.Now.Hour.ToString();
string minute = DateTime.Now.Minute.ToString();
string second = DateTime.Now.Second.ToString();
string fileName = year + month + date + hours + minute + second;
DisableFormat disable = new DisableFormat();
disable.DisableUnwantedExportFormat(rptView, "PDF");
disable.DisableUnwantedExportFormat(rptView, "WORD");
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString();
try
{
con.Open();
string dateFrom = Request.QueryString["SubmitDateFrom"];
string dateTo = Request.QueryString["SubmitDateTo"];
string code = Request.QueryString["ProjectCode"];
string customer = Request.QueryString["Customer"];
string productId = Request.QueryString["MProductTypeId"];
string approve_Date = Request.QueryString["BoDDecisionDate"];
DataTable myDt = new DataTable();
myDt = dtReport(con, dateFrom, dateTo, code, customer, Convert.ToInt32(productId), approve_Date);
rptView.LocalReport.DataSources.Clear();
rptView.LocalReport.DataSources.Add(
new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", myDt));
rptView.LocalReport.DisplayName = "Report_PAM_" + fileName;
rptView.LocalReport.Refresh();
rptView.Visible = true;
}
catch (Exception ex)
{
lblError.Text = ex.Message + " " + ex.StackTrace;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string date = DateTime.Now.Day.ToString();
string hours = DateTime.Now.Hour.ToString();
string minute = DateTime.Now.Minute.ToString();
string second = DateTime.Now.Second.ToString();
string fileName = year + month + date + hours + minute + second;
DisableFormat disable = new DisableFormat();
disable.DisableUnwantedExportFormat(rptView, "PDF");
disable.DisableUnwantedExportFormat(rptView, "WORD");
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString();
try
{
con.Open();
string PeriodStart = Request.QueryString["PeriodStart"];
string PeriodEnd = Request.QueryString["PeriodEnd"];
DataTable dt_perdirectorate = dtReport(con, "[dbo].[Rpt_TAT_Report_CM_perPeriodic_SP]", PeriodStart, PeriodEnd);
DataTable dt_TAT = dtReport(con, "[dbo].[Rpt_SUM_TAT_Report_CM_Periodic_SP]", PeriodStart, PeriodEnd);
rptView.LocalReport.DataSources.Clear();
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetPeriodic", dt_perdirectorate));
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetSumTAT", dt_TAT));
rptView.LocalReport.DisplayName = "Report_TAT_CM_perPeriodic_" + fileName;
rptView.PageCountMode = PageCountMode.Actual;
rptView.LocalReport.Refresh();
rptView.Visible = true;
}
catch (Exception ex)
{
lblError.Text = ex.Message + " " + ex.StackTrace;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string date = DateTime.Now.Day.ToString();
string hours = DateTime.Now.Hour.ToString();
string minute = DateTime.Now.Minute.ToString();
string second = DateTime.Now.Second.ToString();
string fileName = year + month + date + hours + minute + second;
DisableFormat disable = new DisableFormat();
disable.DisableUnwantedExportFormat(rptView, "PDF");
disable.DisableUnwantedExportFormat(rptView, "WORD");
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString();
try
{
con.Open();
string projectCode = Request.QueryString["ProjectCode_LIKE"];
string CustomerName = Request.QueryString["CustomerName_Like"];
string CmNumber = Request.QueryString["CmNumber_LIKE"];
DataTable dt_perdirectorate = dtReport(con, "[dbo].[Rpt_TAT_Report_CM_perDirectorate_SP]", projectCode, CustomerName, CmNumber);
DataTable dt_TAT = dtReport(con, "[dbo].[Rpt_SUM_TAT_Report_CM_perDirectorate_SP]", projectCode, CustomerName, CmNumber);
rptView.LocalReport.DataSources.Clear();
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSet_CM_Directorate", dt_perdirectorate));
rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSet_SUM_TAT_Directorate", dt_TAT));
rptView.LocalReport.DisplayName = "Report_TAT_CM_perDirectorate_" + fileName;
rptView.LocalReport.Refresh();
rptView.Visible = true;
}
catch (Exception ex)
{
lblError.Text = ex.Message + " " + ex.StackTrace;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
}
}
