/// <summary>
/// InitData. Create a PrintManhoursPerPhaseTDS dataset
/// </summary>
protected override void InitData()
{
_data = new PrintManhoursPerPhaseTDS();
}
private void GenerateAll()
{
// Get Data
string accessType = (ddlAccessType.SelectedValue == "(All)") ? "%" : ddlAccessType.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
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;
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedItem.Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
string confirmedSize1 = (ddlConfirmedSize.SelectedValue == "(All)") ? "%" : ddlConfirmedSize.SelectedValue;
string confirmedSize2 = "%"; //By default
switch (confirmedSize1)
{
case "8":
confirmedSize1 = "8%";
confirmedSize2 = "200%";
break;
case "10":
confirmedSize1 = "10%";
confirmedSize2 = "250%";
break;
case "12":
confirmedSize1 = "12%";
confirmedSize2 = "300%";
break;
case "15":
confirmedSize1 = "15%";
confirmedSize2 = "375%";
break;
case "18":
confirmedSize1 = "18%";
confirmedSize2 = "450%";
break;
case "21":
confirmedSize1 = "21%";
confirmedSize2 = "525%";
break;
case "24":
confirmedSize1 = "24%";
confirmedSize2 = "600%";
break;
case "27":
confirmedSize1 = "27%";
confirmedSize2 = "675%";
break;
case "30":
confirmedSize1 = "30%";
confirmedSize2 = "750%";
break;
}
//string work_ = "";
//string function_ = "";
int? countryId = null;
if (ddlCountry.SelectedIndex > 0)
{
countryId = Convert.ToInt32(ddlCountry.SelectedValue);
}
mReport1 master = (mReport1)this.Master;
PrintManhoursPerPhaseTDS printManhoursPerPhaseTDS = new PrintManhoursPerPhaseTDS();
bool existData = true;
// Get report
if (existData)
{
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManhoursPerPhaseGeneral printManhoursPerPhaseGeneral = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.PrintManhoursPerPhaseGeneral(printManhoursPerPhaseTDS);
if (ddlClient.SelectedIndex == 0)
{
if (ddlCountry.SelectedIndex == 0)
{
printManhoursPerPhaseGeneral.Load(companyId, startDate, endDate, projectTimeState, confirmedSize1, confirmedSize2, accessType, shape, conditionRating, location, material, crew);
}
else
{
printManhoursPerPhaseGeneral.LoadByCountryId(companyId, countryId.Value, startDate, endDate, projectTimeState, confirmedSize1, confirmedSize2, accessType, shape, conditionRating, location, material, crew);
}
}
else
{
if (ddlProject.SelectedIndex == 0)
{
printManhoursPerPhaseGeneral.LoadByClientId(companyId, Convert.ToInt32(ddlClient.SelectedValue), startDate, endDate, projectTimeState, confirmedSize1, confirmedSize2, accessType, shape, conditionRating, location, material, crew);
}
else
{
printManhoursPerPhaseGeneral.LoadByProjectId(companyId, Convert.ToInt32(ddlProject.SelectedValue), startDate, endDate, projectTimeState, confirmedSize1, confirmedSize2, accessType, shape, conditionRating, location, material, crew);
}
}
// ... set properties to master page
master.Data = printManhoursPerPhaseGeneral.Data;
master.Table = printManhoursPerPhaseGeneral.TableName;
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseGeneralReport();
// ... 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
{
string clientName = ddlClient.SelectedItem.Text;
master.SetParameter("client", clientName);
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
string project = ddlProject.SelectedItem.Text;
master.SetParameter("project", project);
}
// ... ... phase / function
master.SetParameter("phase", ddlPhase.SelectedItem.Text);
// ... ... Dates Range
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
// ... ... MH Shape
if (ddlShape.SelectedValue == "(All)")
{
master.SetParameter("Shape", "All");
}
else
{
master.SetParameter("Shape", ddlShape.SelectedValue);
}
// ... ... Condition Rating
if (ddlConditioningRating.SelectedValue == "(All)")
{
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);
}
// ... ... Confirmed Size
if (ddlConfirmedSize.SelectedValue == "(All)")
{
master.SetParameter("ConfirmedSize", "All");
}
else
{
master.SetParameter("ConfirmedSize", ddlConfirmedSize.SelectedValue);
}
// ... ... Access Type
if (ddlAccessType.SelectedValue == "(All)")
{
master.SetParameter("AccessType", "All");
}
else
{
master.SetParameter("AccessType", ddlAccessType.SelectedValue);
}
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintManhoursPerPhaseGeneralReport();
}
}
}
