// ////////////////////////////////////////////////////////////////////////
// NAVIGATION EVENTS
//
protected void tkrmTop_ItemClick(object sender, RadMenuEventArgs e)
{
string url = "";
string headerValues = "";
switch (e.Item.Value)
{
case "mClearSearch":
url = "./jliner_navigator.aspx?source_page=lm&client=" + hdfCurrentClient.Value;
break;
case "mPreview":
int totalColumns = 38;
// Update comments
JlinerNavigator jlinerNavigator = new JlinerNavigator(jlinerNavigatorTDS);
jlinerNavigator.UpdateCommentsHistoryForReport();
// Establishing header values
if (cbxId.Checked) headerValues += "ID";
if (cbxClientLateralId.Checked) headerValues += " * Client Lateral ID";
if (cbxHamiltonInspectionNumber.Checked) headerValues += " * Hamilton Inspection Number";
if (cbxStreet.Checked) headerValues += " * Street";
if (cbxAddress.Checked) headerValues += " * Address";
if (cbxCity.Checked) headerValues += " * City";
if (cbxUSMH.Checked) headerValues += " * USMH";
if (cbxDSMH.Checked) headerValues += " * DSMH";
if (cbxVideoInspection.Checked) headerValues += " * Video Inspection";
if (cbxVideoLengthToPropertyLine.Checked) headerValues += " * Video Length To PL";
if (cbxPipeLocated.Checked) headerValues += " * Pipe Located";
if (cbxServicesLocated.Checked) headerValues += " * Services Located";
if (cbxCoRequired.Checked) headerValues += " * C/O Req.";
if (cbxPitRequired.Checked) headerValues += " * Pit Req.";
if (cbxCoPitLocation.Checked) headerValues += " * CO/Pit Location";
if (cbxCoInstalled.Checked) headerValues += " * C/O Installed";
if (cbxBackfilledConcrete.Checked) headerValues += " * Backfilled Con.";
if (cbxBackfilledSoil.Checked) headerValues += " * Backfilled Soil";
if (cbxGrouted.Checked) headerValues += " * Grouted";
if (cbxCored.Checked) headerValues += " * Cored";
if (cbxPrepped.Checked) headerValues += " * Prepped";
if (cbxPreVideo.Checked) headerValues += " * Pre-Video";
if (cbxMeasured.Checked) headerValues += " * Measured";
if (cbxLinerSize.Checked) headerValues += " * Liner Size";
if (cbxLiningThruCo.Checked) headerValues += " * Lining Thru C/O";
if (cbxNoticeDelivered.Checked) headerValues += " * Notice Delivered";
if (cbxInProcess.Checked) headerValues += " * In Process";
if (cbxInStock.Checked) headerValues += " * In Stock";
if (cbxDelivered.Checked) headerValues += " * Delivered";
if (cbxLinerInstalled.Checked) headerValues += " * Liner Installed";
if (cbxFinalVideo.Checked) headerValues += " * Final Video";
if (cbxDistanceFromUSMH.Checked) headerValues += " * Dist. From USMH";
if (cbxDistanceFromDSMH.Checked) headerValues += " * Dist. From DSMH";
if (cbxPostContractDigRequired.Checked) headerValues += " * Post Contract Dig?";
if (cbxCoCutDown.Checked) headerValues += " * C/O Cut Down?";
if (cbxFinalRestoration.Checked) headerValues += " * Final Restoration";
if (cbxCost.Checked) headerValues += " * Cost";
if (cbxBuidRebuid.Checked) headerValues += " * Build / Rebuild";
// Establishing columns to display
string[] columns = headerValues.Split('*');
string columnsForReport = "";
int j;
// ... for visible columns
for (int i = 0; i < columns.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columns[i].Trim();
}
// ... For not visible columns
for (int i = columns.Length; i < totalColumns; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// ... For comments and history options
string comments = "None";
string history = "None";
if (cbxComments.Checked) comments = "Comments";
if (cbxHistory.Checked) history = "History";
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
Response.Write("<script language='javascript'> {window.open('./../../viewer.aspx?target_report=rJlinerPrintSearchResults" + columnsForReport + "&comments=" + comments + "&history=" + history + "&totalColumns=" + totalColumns + "&totalSelectedColumns=" + columns.Length + "&name=" + hdfClientName.Value + "&format=pdf', '_blank', 'toolbar=yes, location=yes, directories=no, status=yes, menubar=yes, scrollbars=yes, resizable=yes, copyhistory=no, width=600, height=300');}</script>");
}
break;
case "mExport":
int totalColumnsExport = 40;
headerValues = "";
columnsForReport = "";
// Update comments
JlinerNavigator jlinerNavigatorExcel = new JlinerNavigator(jlinerNavigatorTDS);
jlinerNavigatorExcel.UpdateCommentsHistoryForReport();
// Establishing header values
if (cbxId.Checked) headerValues += "ID";
if (cbxClientLateralId.Checked) headerValues += " * Client Lateral ID";
if (cbxHamiltonInspectionNumber.Checked) headerValues += " * Hamilton Inspection Number";
if (cbxStreet.Checked) headerValues += " * Street";
if (cbxAddress.Checked) headerValues += " * Address";
if (cbxCity.Checked) headerValues += " * City";
if (cbxUSMH.Checked) headerValues += " * USMH";
if (cbxDSMH.Checked) headerValues += " * DSMH";
if (cbxVideoInspection.Checked) headerValues += " * Video Inspection";
if (cbxVideoLengthToPropertyLine.Checked) headerValues += " * Video Length To PL";
if (cbxPipeLocated.Checked) headerValues += " * Pipe Located";
if (cbxServicesLocated.Checked) headerValues += " * Services Located";
if (cbxCoRequired.Checked) headerValues += " * C/O Req.";
if (cbxPitRequired.Checked) headerValues += " * Pit Req.";
if (cbxCoPitLocation.Checked) headerValues += " * CO/Pit Location";
if (cbxCoInstalled.Checked) headerValues += " * C/O Installed";
if (cbxBackfilledConcrete.Checked) headerValues += " * Backfilled Con.";
if (cbxBackfilledSoil.Checked) headerValues += " * Backfilled Soil";
if (cbxGrouted.Checked) headerValues += " * Grouted";
if (cbxCored.Checked) headerValues += " * Cored";
if (cbxPrepped.Checked) headerValues += " * Prepped";
if (cbxPreVideo.Checked) headerValues += " * Pre-Video";
if (cbxMeasured.Checked) headerValues += " * Measured";
if (cbxLinerSize.Checked) headerValues += " * Liner Size";
if (cbxLiningThruCo.Checked) headerValues += " * Lining Thru C/O";
if (cbxNoticeDelivered.Checked) headerValues += " * Notice Delivered";
if (cbxInProcess.Checked) headerValues += " * In Process";
if (cbxInStock.Checked) headerValues += " * In Stock";
if (cbxDelivered.Checked) headerValues += " * Delivered";
if (cbxLinerInstalled.Checked) headerValues += " * Liner Installed";
if (cbxFinalVideo.Checked) headerValues += " * Final Video";
if (cbxDistanceFromUSMH.Checked) headerValues += " * Dist. From USMH";
if (cbxDistanceFromDSMH.Checked) headerValues += " * Dist. From DSMH";
if (cbxPostContractDigRequired.Checked) headerValues += " * Post Contract Dig?";
if (cbxCoCutDown.Checked) headerValues += " * C/O Cut Down?";
if (cbxFinalRestoration.Checked) headerValues += " * Final Restoration";
if (cbxCost.Checked) headerValues += " * Cost";
if (cbxBuidRebuid.Checked) headerValues += " * Build / Rebuild";
if (cbxComments.Checked) headerValues += " * Comments";
if (cbxHistory.Checked) headerValues += " * History";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
url = "./../../viewer.aspx?target_report=rJlinerPrintSearchResults" + columnsForReport + "&totalColumns=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&name=" + hdfClientName.Value + "&format=excel";
}
break;
}
if (url != "") Response.Redirect(url);
}
private void PostPageChanges()
{
JlinerNavigator jlinerNavigator = new JlinerNavigator(jlinerNavigatorTDS);
// Update jlinernavigator rows
foreach (GridViewRow row in grdJlinerNavigator.Rows)
{
string id_ = ((Label)row.FindControl("lblId_")).Text.Trim();
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
jlinerNavigator.Update(id_, selected);
}
jlinerNavigator.Data.AcceptChanges();
// Store datasets
Session["jlinerNavigatorTDS"] = jlinerNavigatorTDS;
}
private JlinerNavigatorTDS SubmitSearch()
{
// Retrieve clauses
string whereClause = GetWhereClause();
string orderByClause = GetOrderByClause();
JlinerNavigator jlinerNavigator = new JlinerNavigator();
// ... Load data
jlinerNavigator.Load(whereClause, orderByClause);
return (JlinerNavigatorTDS)jlinerNavigator.Data;
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
Response.Redirect("./error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if ((Request.QueryString["target_report"] == null) || (Request.QueryString["format"] == null))
{
Response.Redirect("./error_page.aspx?error=" + "Invalid query string in viewer.aspx");
}
// Initialize
bool empty = false;
// Get report data
#region Get report data
switch (Request.QueryString["target_report"])
{
// ... TimesheetMissing
case "TimesheetMissing":
bool includeSalaried = (Request.QueryString["include_salaried"] == "true") ? true : false;
TimesheetMissingReportGateway gateway = new TimesheetMissingReportGateway();
if (Request.QueryString["all_employees"] == "true")
{
if (Request.QueryString["all_countries"] == "true")
{
gateway.LoadByFromTo(DateTime.Parse(Request.QueryString["date_from"]), DateTime.Parse(Request.QueryString["date_to"]), Request.QueryString["employee_state"], Request.QueryString["employee_type"], includeSalaried);
}
else
{
gateway.LoadByCountryIdFromTo(int.Parse(Request.QueryString["country_id"]), DateTime.Parse(Request.QueryString["date_from"]), DateTime.Parse(Request.QueryString["date_to"]), Request.QueryString["employee_state"], Request.QueryString["employee_type"], includeSalaried);
}
}
else
{
if (Request.QueryString["all_countries"] == "true")
{
gateway.LoadByEmployeeIDFromTo(int.Parse(Request.QueryString["employee_id"]), DateTime.Parse(Request.QueryString["date_from"]), DateTime.Parse(Request.QueryString["date_to"]), Request.QueryString["employee_state"], Request.QueryString["employee_type"], includeSalaried);
}
else
{
gateway.LoadByCountryIdEmployeeIDFromTo(int.Parse(Request.QueryString["country_id"]), int.Parse(Request.QueryString["employee_id"]), DateTime.Parse(Request.QueryString["date_from"]), DateTime.Parse(Request.QueryString["date_to"]), Request.QueryString["employee_state"], Request.QueryString["employee_type"], includeSalaried);
}
}
if (gateway.Table.Rows.Count > 0)
{
report = new TimesheetMissingReport();
report.SetDataSource(gateway.Data);
if (Request.QueryString["format"] == "pdf")
{
((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false;
}
else
{
((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true;
}
}
else
{
empty = true;
}
break;
// rJlinerPrintSearchResults
case "rJlinerPrintSearchResults":
JlinerNavigatorTDS jlinerNavigatorTDS = (JlinerNavigatorTDS)Session["jlinerNavigatorTDS"];
LiquiForce.LFSLive.BL.CWP.Jliner.JlinerNavigator jlinerNavigator = new LiquiForce.LFSLive.BL.CWP.Jliner.JlinerNavigator(jlinerNavigatorTDS);
if (jlinerNavigator.Table.Rows.Count > 0)
{
report = new LiquiForce.LFSLive.WebUI.CWP.Jliner.rJlinerPrintSearchResults();
report.SetDataSource(jlinerNavigator.Data);
ArrayList parameterList = new ArrayList();
parameterList.Add(Request.QueryString["name"]);
SetCurrentValuesForParameterField(report, "name", parameterList);
parameterList.Clear();
if (Request.QueryString["format"] == "pdf")
{
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumns"]); i++)
{
j = i + 1;
if (Request.QueryString["header" + j].ToString() == "Hamilton Inspection Number")
{
parameterList.Add("Hamilton Insp.#");
SetCurrentValuesForParameterField(report, "header" + j, parameterList);
parameterList.Clear();
}
else
{
if (Request.QueryString["header" + j].ToString() == "Build / Rebuild")
{
parameterList.Add("Build / Rebuild #");
SetCurrentValuesForParameterField(report, "header" + j, parameterList);
parameterList.Clear();
}
else
{
parameterList.Add(Request.QueryString["header" + j]);
SetCurrentValuesForParameterField(report, "header" + j, parameterList);
parameterList.Clear();
}
}
}
parameterList.Add(Request.QueryString["comments"]);
SetCurrentValuesForParameterField(report, "header39", parameterList);
parameterList.Clear();
parameterList.Add(Request.QueryString["history"]);
SetCurrentValuesForParameterField(report, "header40", parameterList);
parameterList.Clear();
// ... Sections
((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetailForExel"]).SectionFormat.EnableSuppress = true;
if (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 12)
{
((Section)report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = false;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 12) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 24))
{
((Section)report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = true;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 24) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 36))
{
((Section)report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = true;
}
else
{
((Section)report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = true;
}
}
}
}
else
{
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumns"]); i++)
{
j = i + 1;
if (Request.QueryString["header" + j].ToString() == "Hamilton Inspection Number")
{
parameterList.Add("Hamilton Insp.#");
SetCurrentValuesForParameterField(report, "header" + j, parameterList);
parameterList.Clear();
}
else
{
parameterList.Add(Request.QueryString["header" + j]);
SetCurrentValuesForParameterField(report, "header" + j, parameterList);
parameterList.Clear();
}
}
// ... Sections
((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sDetailForExel"]).SectionFormat.EnableSuppress = false;
((Section)report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetailSectionComments"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetailSectionHistory"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sDetailSeparator"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true;
((Section)report.ReportDefinition.Sections["sTitle"]).SectionFormat.EnableSuppress = true;
}
// Report format
report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
else
{
empty = true;
}
break;
}
#endregion
if (!empty)
{
// Configure report
// ... Disk options
string physicalApplicationPath = Request.PhysicalApplicationPath;
if (Request.PhysicalApplicationPath.Substring(Request.PhysicalApplicationPath.Length - 1, 1) != "\\")
{
physicalApplicationPath += "\\";
}
string fName = "";
switch (Request.QueryString["format"])
{
case "pdf":
fName = physicalApplicationPath + "export\\" + Guid.NewGuid().ToString() + ".pdf";
Session["fName"] = fName;
break;
case "excel":
fName = physicalApplicationPath + "export\\" + Guid.NewGuid().ToString() + ".xls";
Session["fName"] = fName;
break;
case "word":
break;
}
DiskFileDestinationOptions diskOptions = new DiskFileDestinationOptions();
diskOptions.DiskFileName = fName;
// ... Export options
report.ExportOptions.DestinationOptions = diskOptions;
report.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
switch (Request.QueryString["format"])
{
case "pdf":
report.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
break;
case "excel":
ExcelFormatOptions excelOptions = new ExcelFormatOptions();
excelOptions.ExcelUseConstantColumnWidth = false;
excelOptions.ExcelTabHasColumnHeadings = false;
report.ExportOptions.ExportFormatType = ExportFormatType.Excel;
report.ExportOptions.FormatOptions = excelOptions;
break;
case "word":
break;
}
// Export report
try
{
report.Export();
}
catch (Exception ex)
{
Response.Redirect("./error_page.aspx?error=" + ex.Message);
}
// Preview report
Response.Redirect("./viewer2.aspx?target_report=" + Request.QueryString["target_report"] + "&format=" + Request.QueryString["format"], true);
}
else
{
Response.Write("<br> No records found for your report.");
}
}