/// <summary>
/// LoadByCompaniesIdProjectId
/// </summary>
/// <param name="companiesId">companiesId</param>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
public void LoadByCompaniesIdProjectId(int companiesId, int projectId, int companyId)
{
ProjectCostingSheetInformationReportInformationGateway projectCostingSheetInformationReportInformationGateway = new ProjectCostingSheetInformationReportInformationGateway(Data);
projectCostingSheetInformationReportInformationGateway.LoadByCompaniesIdProjectId(companiesId, projectId, companyId);
UpdateForReport();
}
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();
}
}
}
