private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
JlLiningPlanTDS jlLiningPlanTDS = (JlLiningPlanTDS)Session["jlLiningPlanTDS"];
JlLiningPlan jlLiningPlan = new JlLiningPlan();
jlLiningPlan.ProcessForReport(jlLiningPlanTDS);
// ... set properties to master page
master.Data = jlLiningPlan.Data;
master.Table = jlLiningPlan.TableName;
// Get report
if (jlLiningPlan.Table.Rows.Count > 0)
{
master.Report = new JlLiningPlanReport();
// ... for client
int companyId = Int32.Parse(Session["companyID"].ToString());
int currentClientId = Int32.Parse(hdfCurrentClientId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", projectGateway.GetProjectNumber(currentProjectId));
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
private void masterParameters(mReport1 master)
{
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
int companyId = Int32.Parse(hdfCompanyId.Value);
// ... set parameters to report
if (master.Format == "pdf")
{
// ... ... client
if (ddlClient.SelectedValue != "-1")
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
// ... ... project
if (ddlProject.SelectedValue != "-1")
{
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
// ... ... category
if (ddlCategory.SelectedValue != "-1")
{
string currentCategory = ddlCategory.SelectedValue;
master.SetParameter("Category", currentCategory);
}
else
{
master.SetParameter("Category", "All");
}
// ... ... user
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"]), companyId);
string user = loginGateway.GetLastName(Convert.ToInt32(Session["loginID"]), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(Session["loginID"]), companyId);
master.SetParameter("User", user.Trim());
// ... for start date
string startDateParameter = startDate.Month.ToString() + "/" + startDate.Day.ToString() + "/" + startDate.Year.ToString();
master.SetParameter("StartDate", startDateParameter);
// ... for end date
string endDateParameter = endDate.Month.ToString() + "/" + endDate.Day.ToString() + "/" + endDate.Year.ToString();
master.SetParameter("EndDate", endDateParameter);
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
int companyId = Int32.Parse(hdfCompanyId.Value);
LiquiForce.LFSLive.BL.Projects.Projects.ProductionReport productionReport = new LiquiForce.LFSLive.BL.Projects.Projects.ProductionReport();
if (ddlCountry.SelectedValue == "(All)")
{
if (ddlClient.SelectedValue == "-1")
{
productionReport.LoadByStartDateEndDate(startDate, endDate, companyId);
}
else
{
int clientId = int.Parse(ddlClient.SelectedValue);
if (ddlProject.SelectedValue == "-1")
{
productionReport.LoadByClientIdStartDateEndDate(clientId, startDate, endDate, companyId);
}
else
{
int projectId = int.Parse(ddlProject.SelectedValue);
productionReport.LoadByClientIdProjectIdStartDateEndDate(clientId, projectId, startDate, endDate, companyId);
}
}
}
else
{
int country = Int32.Parse(ddlCountry.SelectedValue);
if (ddlClient.SelectedValue == "-1")
{
productionReport.LoadByCountryIdStartDateEndDate(country, startDate, endDate, companyId);
}
else
{
int clientId = int.Parse(ddlClient.SelectedValue);
if (ddlProject.SelectedValue == "-1")
{
productionReport.LoadByCountryIdClientIdStartDateEndDate(country, clientId, startDate, endDate, companyId);
}
else
{
int projectId = int.Parse(ddlProject.SelectedValue);
productionReport.LoadByCountryIdClientIdProjectIdStartDateEndDate(country, clientId, projectId, startDate, endDate, companyId);
}
}
}
LiquiForce.LFSLive.DA.Projects.Projects.ProductionReportGateway productionReportGateway = new LiquiForce.LFSLive.DA.Projects.Projects.ProductionReportGateway(productionReport.Data);
// ... set properties to master page
master.Data = productionReportGateway.Data;
master.Table = productionReportGateway.TableName;
// Get report
if (productionReportGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.ProductionReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.ProductionReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("Project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("Project", project);
}
// ... ... Date
string startDateParameter = tkrdpStartDate.SelectedDate.Value.ToShortDateString();
master.SetParameter("StartDate", startDateParameter);
string endDateParameter = tkrdpEndDate.SelectedDate.Value.ToShortDateString();
master.SetParameter("EndDate", endDateParameter);
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
}
else
{
// ... ... Date
string startDateParameter = tkrdpStartDate.SelectedDate.Value.ToShortDateString();
master.SetParameter("StartDate", startDateParameter);
string endDateParameter = tkrdpEndDate.SelectedDate.Value.ToShortDateString();
master.SetParameter("EndDate", endDateParameter);
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
LiquiForce.LFSLive.BL.CWP.Common.LateralLocationSheetReport lateralLocationSheetReport = new LiquiForce.LFSLive.BL.CWP.Common.LateralLocationSheetReport();
int companyId = Int32.Parse(hdfCurrentCompanyId.Value);
// Restore TDS
JlNavigatorTDS jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
// Get Data
lateralLocationSheetReport.LoadByProjectIdJlNavigatorTDS(Int32.Parse(hdfCurrentProjectId.Value), jlNavigatorTDS, companyId);
// ... set properties to master page
master.Data = lateralLocationSheetReport.Data;
master.Table = lateralLocationSheetReport.TableName;
// Get report
if (lateralLocationSheetReport.Table.Rows.Count > 0)
{
master.Report = new LateralLocationSheetReport();
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", projectGateway.GetProjectNumber(currentProjectId));
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.JunctionLining.JlToBuildReport jlToBuildReport = new LiquiForce.LFSLive.BL.CWP.JunctionLining.JlToBuildReport();
if (ddlClient.SelectedValue == "-1")
{
jlToBuildReport.Load(int.Parse(hdfCompanyId.Value));
}
else
{
if (ddlProject.SelectedValue == "-1")
{
jlToBuildReport.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue));
}
else
{
jlToBuildReport.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue));
}
}
if (cbxAutoFillLinerOrdered.Checked)
{
try
{
jlToBuildReport.UpdateForReport();
}
catch
{
string url = string.Format("./error_page.aspx?error={0}", "Autofill Liner In Process Failed. Please check your Database");
Response.Redirect(url);
}
}
// ... set properties to master page
master.Data = jlToBuildReport.Data;
master.Table = jlToBuildReport.TableName;
// Get report
if (jlToBuildReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new JlToBuildReport();
}
else
{
master.Report = new JlToBuildReportExport();
}
// ... set parameters to report
int companyId = Int32.Parse(hdfCompanyId.Value);
if (master.Format == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_summary.aspx");
}
// Tag Page
TagPage();
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value);
Session.Remove("pointRepairsRepairsTempDummy");
Session.Remove("pointRepairsCommentsTempDummy");
// ... pr_navigator2.aspx
if (Request.QueryString["source_page"] == "pr_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedPr"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
pointRepairsTDS = new PointRepairsTDS();
pointRepairsRepairsTemp = new PointRepairsTDS.RepairDetailsDataTable();
pointRepairsCommentsTemp = new PointRepairsTDS.CommentDetailsDataTable();
PointRepairsSectionDetails pointRepairsSectionDetails = new PointRepairsSectionDetails(pointRepairsTDS);
pointRepairsSectionDetails.LoadByWorkId(workId, companyId);
PointRepairsWorkDetails pointRepairsWorkDetails = new PointRepairsWorkDetails(pointRepairsTDS);
pointRepairsWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS);
pointRepairsRepairDetails.LoadAllByWorkId(workId, companyId);
PointRepairsCommentDetails pointRepairsCommentDetails = new PointRepairsCommentDetails(pointRepairsTDS);
pointRepairsCommentDetails.LoadAllByWorkIdWorkType(workId, companyId, "Point Repairs");
}
else
{
hdfActiveTab.Value = (string)Session["activeTabPr"];
// Restore datasets
pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"];
pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"];
pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"];
}
tcPrDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
Session["filterExpression"] = "Deleted = 0";
// Store dataset
Session["pointRepairsTDS"] = pointRepairsTDS;
Session["pointRepairsRepairsTemp"] = pointRepairsRepairsTemp;
Session["pointRepairsCommentsTemp"] = pointRepairsCommentsTemp;
}
// ... pr_delete.aspx or pr_edit.aspx
if ((Request.QueryString["source_page"] == "pr_delete.aspx") || (Request.QueryString["source_page"] == "pr_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"];
pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"];
pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"];
// ... Set initial tab
if ((string)Session["dialogOpenedPr"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabPr"];
}
tcPrDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
ApplyFilter();
switch ((string)Session["filterExpression"])
{
case "Deleted = 0":
ddlFilter.SelectedIndex = 0;
break;
case "Type='Robotic Reaming' AND Deleted = 0":
ddlFilter.SelectedIndex = 1;
break;
case "Type='Point Lining' AND Deleted = 0":
ddlFilter.SelectedIndex = 2;
break;
case "Type='Grouting' AND Deleted = 0":
ddlFilter.SelectedIndex = 3;
break;
default:
ddlFilter.SelectedIndex = 0;
break;
}
}
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// ... Data for current point repairs work
LoadPointRepairsData(currentProjectId, assetId, companyId);
}
else
{
// Restore datasets
pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"];
pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"];
pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcPrDetails.ActiveTabIndex = activeTab;
ApplyFilter();
}
}
private void Generate3()
{
mReportForM12 master = (mReportForM12)this.Master;
string unitType = ddlUnitType.SelectedValue;
int companyId = Convert.ToInt32(hdfCompanyId.Value);
FlM1ReportTDS flM1ReportTDS = new FlM1ReportTDS();
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report flM1Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report(flM1ReportTDS);
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report(flM1ReportTDS);
GetM1Data(flM1Report, unitType, companyId);
GetM2Data(flM2Report, unitType);
// ... set properties to master page
//FlM1ReportTDS dataSet = new FlM1ReportTDS();
//dataSet.M1ReportByClient.Merge(flM1Report, true);
//dataSet.M2_SECTION.Merge(flM2Report, true);
master.Data3 = flM1ReportTDS;
master.Table1 = flM1Report.TableName;
master.Table2 = flM2Report.TableName;
// Get report
if (flM2Report.Table.Rows.Count > 0 || flM1Report.Table.Rows.Count > 0)
{
if (master.Format3 == "pdf")
{
master.Report3 = new FlM12Report();
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter3("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter3("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter3("Project", name);
}
else
{
master.SetParameter3("Project", "All");
}
master.SetParameter3("UnitType", unitType);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter3("User", user.Trim());
}
else
{
//master.Report2 = new FlM12ReportExport();
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string whereClause = "(P.Deleted = 0) AND (P.ProjectType = 'Proposal')";
if (ddlCountry.SelectedValue != "(All)")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.CountryID = " + ddlCountry.SelectedValue + ")";
}
if (ddlClient.SelectedValue != "-1")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.ClientID = " + ddlClient.SelectedValue + ")";
}
if (ddlState.SelectedValue != "(All)")
{
if (whereClause.Length > 0) whereClause += " AND ";
if (ddlState.SelectedValue == "AwardedBidding")
{
whereClause += "((P.ProjectState = 'Bidding') OR (P.ProjectState = 'Awarded'))";
}
else
{
whereClause += "(P.ProjectState = '" + ddlState.SelectedValue + "')";
}
}
whereClause += " AND (P.ProjectType != 'Internal')";
LiquiForce.LFSLive.BL.Projects.Projects.TotalValueWorkAheadReport totalValueWorkAheadReport = new LiquiForce.LFSLive.BL.Projects.Projects.TotalValueWorkAheadReport();
totalValueWorkAheadReport.LoadWhere(whereClause, ddlCurrency.SelectedValue, decimal.Parse(tbxExchangeRate.Text));
// ... set properties to master page
master.Data = totalValueWorkAheadReport.Data;
master.Table = totalValueWorkAheadReport.TableName;
// Get report
if (totalValueWorkAheadReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.TotalValueWorkAheadReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.TotalValueWorkAheadReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
master.SetParameter("GrandTotal", "GRAND TOTAL (" + ddlCurrency.SelectedValue.Trim() + "):");
master.SetParameter("Currency", ddlCurrency.SelectedValue.Trim());
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("Client", clientName);
}
// ... ... state
if (ddlState.SelectedValue == "(All)")
{
master.SetParameter("State", "All");
}
else
{
if (ddlState.SelectedValue == "AwardedBidding")
{
master.SetParameter("State", "Awarded & Bidding");
}
else
{
master.SetParameter("State", ddlState.SelectedValue);
}
}
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
}
else
{
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
master.SetParameter("GrandTotal", "GRAND TOTAL (" + ddlCurrency.SelectedValue.Trim() + "):");
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlLiningCompletedReport flLiningCompletedReport = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlLiningCompletedReport();
int companyId = Int32.Parse(hdfCompanyId.Value);
if (ddlCountry.SelectedValue == "(All)")
{
if (ddlClient.SelectedValue == "-1")
{
flLiningCompletedReport.LoadByStartDateEndDate(startDate, endDate, companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
flLiningCompletedReport.LoadByCompaniesIdStartDateEndDate(int.Parse(ddlClient.SelectedValue), startDate, endDate, companyId);
}
else
{
flLiningCompletedReport.LoadByCompaniesIdProjectIdStartDateEndDate(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, companyId);
}
}
}
else
{
int countryId = Int32.Parse(ddlCountry.SelectedValue);
if (ddlClient.SelectedValue == "-1")
{
flLiningCompletedReport.LoadByStartDateEndDateCountryId(startDate, endDate, countryId, companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
flLiningCompletedReport.LoadByCompaniesIdStartDateEndDateCountryId(int.Parse(ddlClient.SelectedValue), startDate, endDate, countryId, companyId);
}
else
{
flLiningCompletedReport.LoadByCompaniesIdProjectIdStartDateEndDateCountryId(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, countryId, companyId);
}
}
}
// Set properties to master page
master.Data = flLiningCompletedReport.Data;
master.Table = flLiningCompletedReport.TableName;
// Get report
if (flLiningCompletedReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new FlLiningCompletedReport();
}
else
{
master.Report = new FlLiningCompletedReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... ... client
if (ddlClient.SelectedValue != "-1")
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
// ... ... project
if (ddlProject.SelectedValue != "-1")
{
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
}
}
}
private void GeneratePL(mReport1 master, string projectTimeState, string confirmedSize1, string confirmedSize2, string accessType, ref DateTime startDate, ref DateTime endDate, string work_, ref string function_, int companyId)
{
if (ddlPhase.SelectedValue == "PLInstall")
{
function_ = "Install";
}
if (ddlPhase.SelectedValue == "PLPrep")
{
function_ = "Prep";
}
int? countryId = null;
if (ddlCountry.SelectedIndex > 0)
{
countryId = Convert.ToInt32(ddlCountry.SelectedValue);
}
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManHoursPerPhasePL printManhoursPerPhase = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManHoursPerPhasePL();
if (ddlClient.SelectedValue == "-1")
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByStartDateEndDateProjectTimeStateWorkFunction(countryId, startDate, endDate, projectTimeState, work_, function_, companyId, confirmedSize1, confirmedSize2, accessType);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByCompaniesIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId, confirmedSize1, confirmedSize2, accessType);
}
else
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId, confirmedSize1, confirmedSize2, accessType);
}
}
// ... set properties to master page
master.Data = printManhoursPerPhase.Data;
master.Table = printManhoursPerPhase.TableName;
// Get report
if (printManhoursPerPhase.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
switch (function_)
{
case "Install":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLInstall();
break;
case "Prep":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLPrep();
break;
case "Reinstate":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLReinstate();
break;
}
}
else
{
switch (function_)
{
case "Install":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLInstall();
break;
case "Prep":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLPrep();
break;
case "Reinstate":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportPLLReinstate();
break;
}
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("client", clientName);
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
// ... ... phase / function
if (ddlPhase.SelectedValue == "(All)")
{
master.SetParameter("phase", "All");
}
else
{
master.SetParameter("phase", ddlPhase.SelectedItem.Text);
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.PointRepairs.PrOverviewReport prOverviewReport = new LiquiForce.LFSLive.BL.CWP.PointRepairs.PrOverviewReport();
int companyId = Int32.Parse(hdfCompanyId.Value);
if (ddlClient.SelectedValue == "-1")
{
if (ddlPrType.SelectedValue == "(All)")
{
prOverviewReport.Load(companyId);
}
else
{
prOverviewReport.LoadByPrType(ddlPrType.SelectedValue, companyId);
}
}
else
{
int clientId = Int32.Parse(ddlClient.SelectedValue);
if (ddlProject.SelectedValue == "-1")
{
if (ddlPrType.SelectedValue == "(All)")
{
prOverviewReport.LoadByCompaniesId(companyId, clientId);
}
else
{
prOverviewReport.LoadByCompaniesIdPrType(companyId, clientId, ddlPrType.SelectedValue);
}
}
else
{
int projectId = Int32.Parse(ddlProject.SelectedValue);
if (ddlPrType.SelectedValue == "(All)")
{
prOverviewReport.LoadByCompaniesIdProjectId(companyId, clientId, projectId);
}
else
{
prOverviewReport.LoadByCompaniesIdProjectIdPrType(companyId, clientId, projectId, ddlPrType.SelectedValue);
}
}
}
// ... set properties to master page
master.Data = prOverviewReport.Data;
master.Table = prOverviewReport.TableName;
// Get report
if (prOverviewReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_ADMIN"]))
{
master.Report = new PrOverviewReport();
}
}
else
{
if (Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_ADMIN"]))
{
master.Report = new PrOverviewReportExport();
}
}
// ... set parameters to report
if (master.Format == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
if (ddlPrType.SelectedValue != "(All)")
{
// ... for point repair type
master.SetParameter("Type", ddlPrType.SelectedValue);
}
else
{
master.SetParameter("Type", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
}
}
private void GenerateMH(mReport1 master, string projectTimeState, ref DateTime startDate, ref DateTime endDate, string work_, string function_, int companyId)
{
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManHoursPerPhaseMH printManhoursPerPhase = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManHoursPerPhaseMH();
string shape = "%"; if (ddlShape.SelectedIndex > 0) shape = ddlShape.SelectedValue;
string location = "%"; if (ddlLocation.SelectedIndex > 0) location = ddlLocation.SelectedValue;
int conditionRating = 1;
string material = "%"; if (ddlMaterial.SelectedIndex > 0) material = ddlMaterial.SelectedItem.Text;
string crew = "%"; if (ddlCrew.SelectedIndex > 0) crew = ddlCrew.SelectedValue;
int? countryId = null;
if (ddlCountry.SelectedIndex > 0)
{
countryId = Convert.ToInt32(ddlCountry.SelectedValue);
}
if (ddlClient.SelectedValue == "-1")
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByStartDateEndDateProjectTimeStateWorkFunction(countryId, startDate, endDate, projectTimeState, work_, function_, companyId, shape, conditionRating, location, material, crew);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByCompaniesIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId, shape, conditionRating, location, material, crew);
}
else
{
// ... For specific type of work and specific function
printManhoursPerPhase.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId, shape, conditionRating, location, material, crew);
}
}
// ... set properties to master page
master.Data = printManhoursPerPhase.Data;
master.Table = printManhoursPerPhase.TableName;
// Get report
if (printManhoursPerPhase.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
switch (function_)
{
case "Prep":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportMHGeneral();
break;
case "Spray":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportMHGeneral();
break;
}
}
else
{
switch (function_)
{
case "Prep":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportMHGeneralExport();
break;
case "Spray":
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseReportMHGeneralExport();
break;
}
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("client", clientName);
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
// ... ... phase / function
if (ddlPhase.SelectedValue == "(All)")
{
master.SetParameter("phase", "All");
}
else
{
master.SetParameter("phase", ddlPhase.SelectedItem.Text);
}
// ... ... MH Shape
if (ddlShape.SelectedValue == "(All)")
{
master.SetParameter("Shape", "All");
}
else
{
master.SetParameter("Shape", ddlShape.SelectedValue);
}
// ... ... Condition Rating
if (ddlConditioningRating.SelectedValue == "-1")
{
master.SetParameter("ConditionRating", "All");
}
else
{
master.SetParameter("ConditionRating", ddlConditioningRating.SelectedValue);
}
// ... ... Location
if (ddlLocation.SelectedValue == "(All)")
{
master.SetParameter("Location", "All");
}
else
{
master.SetParameter("Location", ddlLocation.SelectedValue);
}
// ... ... Material
if (ddlMaterial.SelectedValue == "(All)")
{
master.SetParameter("Material", "All");
}
else
{
master.SetParameter("Material", ddlMaterial.SelectedItem.Text);
}
// ... ... Crew
if (ddlCrew.SelectedValue == "(All)")
{
master.SetParameter("Crew", "All");
}
else
{
master.SetParameter("Crew", ddlCrew.SelectedValue);
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%";
string projectTimeState = "%";
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
int clientId = 0; if (ddlClient.SelectedValue != "-1") clientId = Int32.Parse(ddlClient.SelectedValue);
int projectId = 0; if (ddlProject.SelectedValue != "-1") projectId = Int32.Parse(ddlProject.SelectedValue);
string personnelAgencySelected = "%";
if (pnlPersonnelAgency.Visible)
{
if (ddlPersonalAgency.SelectedIndex > 0)
{
personnelAgencySelected = ddlPersonalAgency.SelectedValue + "%";
}
}
PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway();
printHoursForPayrollPeriodGateway.ClearBeforeFill = false;
foreach (ListItem lst in cbxlEmployee.Items)
{
if (lst.Selected)
{
if (ddlCountry.SelectedValue == "-1")
{
if (ddlEmployeeType.SelectedValue != "Salaried")
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, false, personnelAgencySelected);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, false, personnelAgencySelected);
}
else
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, false, personnelAgencySelected);
}
}
}
else
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeState(startDate, endDate, int.Parse(lst.Value), projectTimeState, false);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, false);
}
else
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, false);
}
}
}
}
else
{
if (ddlEmployeeType.SelectedValue != "Salaried")
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, false, personnelAgencySelected);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, false, personnelAgencySelected);
}
else
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, false, personnelAgencySelected);
}
}
}
else
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeState(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, false);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, false);
}
else
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, false);
}
}
}
}
}
}
printHoursForPayrollPeriodGateway.ClearBeforeFill = true;
// ... set properties to master page
master.Data = printHoursForPayrollPeriodGateway.Data;
master.Table = printHoursForPayrollPeriodGateway.TableName;
// Get report
if (printHoursForPayrollPeriodGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodReportOld();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodReportExportOld();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... team member
if (IsAllEmployeesSelected())
{
master.SetParameter("teamMember", "All");
}
else
{
string fullName = GetEmployeesSelected();
master.SetParameter("teamMember", fullName);
}
// ... ... team member type
if (ddlEmployeeType.SelectedValue == "(All)")
{
master.SetParameter("teamMemberType", "All");
}
else
{
if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada");
if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA");
if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS");
if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada");
if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA");
if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG");
if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA");
if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried");
if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId,companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("Project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("Project", project);
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
else
{
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.Jliner.JlinerOverviewReport jlinerOverviewReport = new LiquiForce.LFSLive.BL.CWP.Jliner.JlinerOverviewReport();
int companyId = Convert.ToInt32(Session["companyID"]);
if (ddlSelectAClient.SelectedValue == "-1")
{
jlinerOverviewReport.Load(companyId);
jlinerOverviewReport.UpdateCommentsForReport();
}
else
{
jlinerOverviewReport.LoadByCompaniesID(Int32.Parse(ddlSelectAClient.SelectedValue), companyId);
jlinerOverviewReport.UpdateCommentsForReport();
}
// ... set properties to master page
master.Data = jlinerOverviewReport.Data;
master.Table = jlinerOverviewReport.TableName;
// Get report
if (jlinerOverviewReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
if (Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]))
{
master.Report = new rJlinerOverviewReport();
}
else
{
master.Report = new rJLinerOverviewReportSimple();
}
}
else
{
if (Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]))
{
master.Report = new rJlinerOverviewReportExport();
}
else
{
master.Report = new rJlinerOverviewReportSimpleExport();
}
}
// ... set parameters to report
if (master.Format == "pdf")
{
if (ddlSelectAClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlSelectAClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
LiquiForce.LFSLive.BL.CWP.ManholeRehabilitation.MrSummaryReport mrSummaryReport = new LiquiForce.LFSLive.BL.CWP.ManholeRehabilitation.MrSummaryReport();
int companyId = Int32.Parse(hdfCompanyId.Value);
Page.Validate();
if (Page.IsValid)
{
// Get Data
// For all clients
if (ddlClient.SelectedValue == "-1")
{
// validate checkboxes
if (cbxMhId.Checked)
{
ArrayList assetId = new ArrayList();
foreach (ListItem lst in cbxlMhId.Items)
{
if (lst.Selected)
{
assetId.Add(lst.Value);
}
}
mrSummaryReport.LoadByAssetId(companyId, assetId);
}
}
// For specific client
else
{
// For all projects
if (ddlProject.SelectedValue == "-1")
{
if (cbxMhId.Checked)
{
ArrayList assetId = new ArrayList();
foreach (ListItem lst in cbxlMhId.Items)
{
if (lst.Selected)
{
assetId.Add(lst.Value);
}
}
mrSummaryReport.LoadByCompaniesIdAssetId(companyId, int.Parse(ddlClient.SelectedValue), assetId);
}
}
// For specific project
else
{
if (cbxMhId.Checked)
{
ArrayList assetId = new ArrayList();
foreach (ListItem lst in cbxlMhId.Items)
{
if (lst.Selected)
{
assetId.Add(lst.Value);
}
}
mrSummaryReport.LoadByCompaniesIdProjectIdAssetId(companyId, int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), assetId);
}
}
}
}
// ... set properties to master page
master.Data = mrSummaryReport.Data;
master.Table = mrSummaryReport.TableName;
// Get report
if (mrSummaryReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new MrSummaryReport();
}
else
{
master.Report = new MrSummaryReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
}
private void Generate()
{
Page.Validate();
if (Page.IsValid)
{
mReport1 master = (mReport1)this.Master;
// Get Data
string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%";
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
int clientId = 0; if (ddlClient.SelectedValue != "-1") clientId = Int32.Parse(ddlClient.SelectedValue);
int projectId = 0; if (ddlProject.SelectedValue != "-1") projectId = Int32.Parse(ddlProject.SelectedValue);
bool includeAllHours = cbxIncludeAllHours.Checked;
string personnelAgencySelected = "null";
if (pnlPersonnelAgency.Visible)
{
if (ddlPersonalAgency.SelectedIndex > 0)
{
personnelAgencySelected = ddlPersonalAgency.SelectedValue + "%";
}
}
PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway();
printHoursForPayrollPeriodGateway.ClearBeforeFill = false;
foreach (ListItem lst in cbxlEmployee.Items)
{
if (lst.Selected)
{
if (ddlCountry.SelectedValue == "-1")
{
if (ddlEmployeeType.SelectedValue != "Salaried")
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, true, personnelAgencySelected);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, true, personnelAgencySelected);
}
else
{
if (!includeAllHours)
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true, personnelAgencySelected);
}
else
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
}
}
}
else
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeState(startDate, endDate, int.Parse(lst.Value), projectTimeState, true);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, true);
}
else
{
if (!includeAllHours)
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
else
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
}
}
}
}
else
{
if (ddlEmployeeType.SelectedValue != "Salaried")
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, true, personnelAgencySelected);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, true, personnelAgencySelected);
}
else
{
if (!includeAllHours)
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true, personnelAgencySelected);
}
else
{
printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
}
}
}
else
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeState(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, true);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, true);
}
else
{
if (!includeAllHours)
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
else
{
printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true);
}
}
}
}
}
}
}
printHoursForPayrollPeriodGateway.ClearBeforeFill = true;
// ... set properties to master page
master.Data = printHoursForPayrollPeriodGateway.Data;
master.Table = printHoursForPayrollPeriodGateway.TableName;
// Get report
if (printHoursForPayrollPeriodGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
if (ddlCountry.SelectedValue == "1")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalUSAReport();
}
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalReportExport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalUSAReportExport();
}
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("ProjectTimeState", "All");
}
else
{
master.SetParameter("ProjectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... team member
if (IsAllEmployeesSelected())
{
master.SetParameter("teamMember", "All");
}
else
{
string fullName = GetEmployeesSelected();
master.SetParameter("teamMember", fullName);
}
// ... ... team member type
if (ddlEmployeeType.SelectedValue == "(All)")
{
master.SetParameter("teamMemberType", "All");
}
else
{
if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada");
if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA");
if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS");
if (ddlEmployeeType.SelectedValue == "PAGCA")
{
master.SetParameter("teamMemberType", "PAG Canada");
}
if (ddlEmployeeType.SelectedValue == "PAGUS")
{
master.SetParameter("teamMemberType", "PAG USA");
}
if (ddlEmployeeType.SelectedValue == "PAG")
{
master.SetParameter("teamMemberType", "All PAG");
}
if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA");
if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried");
if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor");
}
string employeeTypeSelected = ddlEmployeeType.SelectedValue;
string employeeTypeSelectedFull = ddlEmployeeType.SelectedItem.Text;
string country = "";
if (ddlCountry.SelectedValue == "1")
{
country = "CANADA";
}
else
{
country = "USA";
}
if (employeeTypeSelected == "PAGCA" || employeeTypeSelected == "PAGUS" || employeeTypeSelected == "PAG")
{
master.SetParameter("name", "TEAM MEMBER HOURS FOR PAYROLL PERIOD - " + country + " - " + employeeTypeSelectedFull.ToUpper() + " - (New Version With Approval)");
}
else
{
master.SetParameter("name", "TEAM MEMBER HOURS FOR PAYROLL PERIOD - " + country + " - (New Version With Approval)");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("Project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("Project", project);
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
if (ddlPersonalAgency.SelectedIndex > 0)
{
master.SetParameter("personnelAgency", ddlPersonalAgency.SelectedItem.Text);
}
else
{
master.SetParameter("personnelAgency", "All");
}
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLetter;
}
}
}
else
{
PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway();
mReport1 master = (mReport1)this.Master;
master.Data = printHoursForPayrollPeriodGateway.Data;
master.Table = printHoursForPayrollPeriodGateway.TableName;
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
int companyId = Convert.ToInt32(Session["companyID"]);
string type = Request.QueryString["type"].ToString();
int costingSheetId = 0;
int projectId = 0;
ProjectCostingSheetInformationBasicInformation projectCostingSheetInformationBasicInformation = new ProjectCostingSheetInformationBasicInformation();
if (ddlCostingSheets.SelectedValue != "-1")
{
// Get Data
costingSheetId = Convert.ToInt32(ddlCostingSheets.SelectedValue);
projectCostingSheetInformationBasicInformation.LoadByCostingSheetIdForPreviewReport(costingSheetId, companyId);
ProjectCostingSheetInformationBasicInformationGateway projectCostingSheetInformationBasicInformationGateway = new ProjectCostingSheetInformationBasicInformationGateway(projectCostingSheetInformationBasicInformation.Data);
projectId = projectCostingSheetInformationBasicInformationGateway.GetProjectID(costingSheetId);
// ... set properties to master page
master.Data = projectCostingSheetInformationBasicInformation.Data;
master.Table = projectCostingSheetInformationBasicInformation.TableName;
master.Report = new ProjectCostingSheetsPreview();
// Get report
if (projectCostingSheetInformationBasicInformation.Table.Rows.Count > 0)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
int clientId = projectGateway.GetClientID(projectId);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(clientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(clientId));
string name = projectGateway.GetName(projectId);
master.SetParameter("Project", name);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("CostingSheet", projectCostingSheetInformationBasicInformationGateway.GetName(costingSheetId));
if (type == "resume")
{
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = true;
//((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = true;
}
else
{
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = false;
//((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = false;
}
if (projectGateway.GetCountryID(projectId) == 1)//Canada
{
// General
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text32"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text34"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text36"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text38"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsUsd"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalUsd2"].ObjectFormat.EnableSuppress = true;
// Labour Hours
ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails");
ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume");
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Units
ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails");
ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume");
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Materials
ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails");
ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume");
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Subcontractors
ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails");
//ReportDocument rpSubcontractorsResune = master.Report.OpenSubreport("SubcontractorsResume");
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
///
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Other Costs
ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails");
ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume");
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
}
else//USA
{
// General
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text31"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text33"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text35"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text37"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsCad"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalCad2"].ObjectFormat.EnableSuppress = true;
// Labour Hours
ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails");
ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume");
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text9"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Units
ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails");
ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume");
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Materials
ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails");
ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume");
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Subcontractors
ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails");
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
// Other Costs
ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails");
ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume");
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
}
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
int companyId = Int32.Parse(hdfCompanyId.Value);
PrintHoursForProjectGateway printHoursForProjectGateway = new PrintHoursForProjectGateway();
if (ddlEmployeeType.SelectedValue == "(All)")
{
if (ddlClient.SelectedValue == "-1")
{
printHoursForProjectGateway.LoadByStartDateEndDateProjectTimeState(startDate, endDate, projectTimeState, companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForProjectGateway.LoadByCompaniesIdStartDateEndDateProjectTimeState(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, companyId);
}
else
{
printHoursForProjectGateway.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeState(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, companyId);
}
}
}
else
{
string teamMemberType = ddlEmployeeType.SelectedValue;
if (ddlClient.SelectedValue == "-1")
{
printHoursForProjectGateway.LoadByStartDateEndDateProjectTimeStateTeamMemberType(startDate, endDate, projectTimeState, teamMemberType, companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
printHoursForProjectGateway.LoadByCompaniesIdStartDateEndDateProjectTimeStateTeamMemberType(Int32.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, teamMemberType, companyId);
}
else
{
printHoursForProjectGateway.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateTeamMemberType(Int32.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, teamMemberType, companyId);
}
}
}
// ... set properties to master page
master.Data = printHoursForProjectGateway.Data;
master.Table = printHoursForProjectGateway.TableName;
// Get report
if (printHoursForProjectGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForProjectReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForProjectReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... team member type
if (ddlEmployeeType.SelectedValue == "(All)")
{
master.SetParameter("teamMemberType", "All");
}
else
{
if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada");
if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA");
if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS");
if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada");
if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA");
if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG");
if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA");
if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried");
if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
else
{
master.SetParameter("startDate", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("endDate", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
private void Generate2()
{
mReportForM12 master = (mReportForM12)this.Master;
string unitType = ddlUnitType.SelectedValue;
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report();
if (ddlClient.SelectedValue == "-1")
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadBySectionId(int.Parse(hdfCompanyId.Value), sectionsId, unitType);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByDate(int.Parse(hdfCompanyId.Value), m1Date.ToShortDateString(), unitType);
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByStreet(int.Parse(hdfCompanyId.Value), tbxStreet.Text.Trim(), unitType);
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadBySubArea(int.Parse(hdfCompanyId.Value), tbxSubArea.Text.Trim(), unitType);
}
else
{
flM2Report.Load(int.Parse(hdfCompanyId.Value), unitType);
}
}
}
}
}
else
{
if (ddlProject.SelectedValue == "-1")
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadByCompaniesIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, sectionsId);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByCompaniesIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, m1Date.ToShortDateString());
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByCompaniesIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxStreet.Text.Trim());
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadByCompaniesIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxSubArea.Text.Trim());
}
else
{
flM2Report.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType);
}
}
}
}
}
else
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadByCompaniesIdProjectIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, sectionsId);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByCompaniesIdProjectIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, m1Date.ToShortDateString());
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByCompaniesIdProjectIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxStreet.Text.Trim());
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadByCompaniesIdProjectIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxSubArea.Text.Trim());
}
else
{
flM2Report.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType);
}
}
}
}
}
}
// ... set properties to master page
master.Data2 = flM2Report.Data;
master.Table2 = flM2Report.TableName;
// Get report
if (flM2Report.Table.Rows.Count > 0)
{
if (master.Format2 == "pdf")
{
master.Report2 = new FlM2Report();
}
else
{
master.Report2 = new FlM2ReportExport();
}
// ... set parameters to report
int companyId = Convert.ToInt32(Session["companyID"]);
if (master.Format2 == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentCompanyId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentCompanyId, companyId);
master.SetParameter2("Client", companiesGateway.GetName(currentCompanyId));
}
else
{
master.SetParameter2("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter2("Project", name);
}
else
{
master.SetParameter2("Project", "All");
}
master.SetParameter2("UnitType", unitType);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter2("User", user.Trim());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LinningPlanTDS linningPlanTDS = (LinningPlanTDS)Session["linningPlanTDS"];
LiquiForce.LFSLive.BL.CWP.Jliner.LinningPlan linningPlan = new LiquiForce.LFSLive.BL.CWP.Jliner.LinningPlan();
linningPlan.ProcessForReport(linningPlanTDS);
// ... set properties to master page
master.Data = linningPlan.Data;
master.Table = linningPlan.TableName;
// Get report
int companyId = Convert.ToInt32(Session["companyID"]);
if (linningPlan.Table.Rows.Count > 0)
{
master.Report = new LinningPlan();
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
int companyId = Convert.ToInt32(Session["companyID"]);
ProjectCostingSheetInformationReportInformation projectCostingSheetInformationReportInformation = new ProjectCostingSheetInformationReportInformation();
if (ddlClient.SelectedValue == "-1")
{
projectCostingSheetInformationReportInformation.Load(companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
projectCostingSheetInformationReportInformation.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
}
else
{
projectCostingSheetInformationReportInformation.LoadByCompaniesIdProjectId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(ddlProject.SelectedValue), companyId);
}
}
// ... set properties to master page
master.Data = projectCostingSheetInformationReportInformation.Data;
master.Table = projectCostingSheetInformationReportInformation.TableName;
// Get report
if (projectCostingSheetInformationReportInformation.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new ConsolidatedCostingSheetReport();
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// For process code
ProjectCostingSheetInformationReportInformationGateway projectCostingSheetInformationReportInformationGateway = new ProjectCostingSheetInformationReportInformationGateway(projectCostingSheetInformationReportInformation.Data);
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(hdfCompanyId.Value));
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("client", clientName);
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
}
else
{
master.Report = new ConsolidatedCostingSheetPreviewReport();
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string orderBy = ddlOrderBy.SelectedValue;
string whereClause = "(P.Deleted = 0) AND (P.ProjectType = 'Ballpark') AND (P.ProjectState = 'Active')";
if (ddlCountry.SelectedValue != "(All)")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.CountryID = " + ddlCountry.SelectedValue + ")";
}
if (ddlClient.SelectedValue != "-1")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.ClientID = " + ddlClient.SelectedValue + ")";
}
if (ddlSalesman.SelectedValue != "-1")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.SalesmanID = " + ddlSalesman.SelectedValue + ")";
}
LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport ballparkSummayReport = new LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport();
ballparkSummayReport.LoadWhereOrderBy(whereClause, orderBy, ddlCurrency.SelectedValue, decimal.Parse(tbxExchangeRate.Text));
// ... set properties to master page
master.Data = ballparkSummayReport.Data;
master.Table = ballparkSummayReport.TableName;
// Get report
if (ballparkSummayReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
master.SetParameter("Currency", ddlCurrency.SelectedValue.Trim());
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("Client", clientName);
}
// ... ... salesman
if (ddlSalesman.SelectedValue == "-1")
{
master.SetParameter("Salesman", "All");
}
else
{
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(Int32.Parse(ddlSalesman.SelectedValue));
string salesman = employeeGateway.GetFullName(Int32.Parse(ddlSalesman.SelectedValue));
master.SetParameter("Salesman", salesman);
}
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... order by
if (ddlOrderBy.SelectedValue == "P.CountryID")
{
master.SetParameter("OrderBy", "Country");
}
else
{
if (ddlOrderBy.SelectedValue == "P.ProjectNumber")
{
master.SetParameter("OrderBy", "Project Number");
}
else
{
if (ddlOrderBy.SelectedValue == "P.Name")
{
master.SetParameter("OrderBy", "Project Name");
}
else
{
if (ddlOrderBy.SelectedValue == "C.Name")
{
master.SetParameter("OrderBy", "Client");
}
else
{
master.SetParameter("OrderBy", "Salesman");
}
}
}
}
}
else
{
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport flOutstandingInvestigationIssuesReport = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport();
if (ddlClient.SelectedValue == "-1")
{
flOutstandingInvestigationIssuesReport.Load(int.Parse(hdfCompanyId.Value));
}
else
{
if (ddlProject.SelectedValue == "-1")
{
flOutstandingInvestigationIssuesReport.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue));
}
else
{
flOutstandingInvestigationIssuesReport.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue));
}
}
// ... set properties to master page
master.Data = flOutstandingInvestigationIssuesReport.Data;
master.Table = flOutstandingInvestigationIssuesReport.TableName;
// Get report
if (flOutstandingInvestigationIssuesReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new FlOutstandingInvestigationIssuesReport();
}
else
{
master.Report = new FlOutstandingInvestigationIssuesReportExport();
}
// ... set parameters to report
int companyId = Convert.ToInt32(Session["companyID"]);
if (master.Format == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
string work_ = "all"; if (ddlTypeOfWork.SelectedValue != "(All)") work_ = ddlTypeOfWork.SelectedValue;
string function_ = "all"; if (ddlFunction.SelectedValue != "(All)") function_ = ddlFunction.SelectedValue;
int companyId = Int32.Parse(hdfCompanyId.Value);
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintProjectCosting printProjectCosting = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintProjectCosting();
if (ddlClient.SelectedValue == "-1")
{
if (ddlTypeOfWork.SelectedValue == "(All)")
{
// ... ... For all types of work and all functions
printProjectCosting.LoadByStartDateEndDateProjectTimeState(startDate, endDate, projectTimeState, companyId);
}
else
{
if (ddlFunction.SelectedValue == "(All)")
{
// ... ... For specific type of work and all functions
printProjectCosting.LoadByStartDateEndDateProjectTimeStateWork(startDate, endDate, projectTimeState, work_, companyId);
}
else
{
// ... ... For specific type of work and specific function
printProjectCosting.LoadByStartDateEndDateProjectTimeStateWorkFunction(startDate, endDate, projectTimeState, work_, function_, companyId);
}
}
}
else
{
if (ddlProject.SelectedValue == "-1")
{
if (ddlTypeOfWork.SelectedValue == "(All)")
{
// ... ... For all types of work and all functions
printProjectCosting.LoadByCompaniesIdStartDateEndDateProjectTimeState(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, companyId);
}
else
{
if (ddlFunction.SelectedValue == "(All)")
{
// ... ... For specific type of work and all functions
printProjectCosting.LoadByCompaniesIdStartDateEndDateProjectTimeStateWork(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, work_, companyId);
}
else
{
// ... ... For specific type of work and specific function
printProjectCosting.LoadByCompaniesIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId);
}
}
}
else
{
if (ddlTypeOfWork.SelectedValue == "(All)")
{
// ... ... For all types of work and all functions
printProjectCosting.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeState(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, companyId);
}
else
{
if (ddlFunction.SelectedValue == "(All)")
{
// ... ... For specific type of work and all functions
printProjectCosting.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWork(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, work_, companyId);
}
else
{
// ... ... For specific type of work and specific function
printProjectCosting.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction(int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), startDate, endDate, projectTimeState, work_, function_, companyId);
}
}
}
}
LiquiForce.LFSLive.DA.LabourHours.ProjectTime.PrintProjectCostingGateway printProjectCostingGateway = new LiquiForce.LFSLive.DA.LabourHours.ProjectTime.PrintProjectCostingGateway(printProjectCosting.Data);
// ... set properties to master page
master.Data = printProjectCostingGateway.Data;
master.Table = printProjectCostingGateway.TableName;
// Get report
if (printProjectCostingGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintProjectCostingReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintProjectCostingReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
// ... ... type of work
if (ddlTypeOfWork.SelectedValue == "(All)")
{
master.SetParameter("typeOfWork", "All");
}
else
{
master.SetParameter("typeOfWork", ddlTypeOfWork.SelectedValue);
}
// ... ... function
if (ddlFunction.SelectedValue == "(All)")
{
master.SetParameter("function", "All");
}
else
{
master.SetParameter("function", ddlFunction.SelectedValue);
}
// ... ... Date
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
else
{
// ... ... Date
master.SetParameter("startDate", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("endDate", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
