/// <summary> /// InitData /// </summary> protected override void InitData() { _data = new ProjectCostingSheetAddTDS(); }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_ADMIN"])) { if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_ADD"]))) { 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)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_combined_costing_sheets_add.aspx"); } if ((string)Request.QueryString["project_id"] == "0") { if (Session["projectsSelected"] != null) { projectsSelected = (ArrayList)Session["projectsSelected"]; } else { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_combined_costing_sheets_add.aspx"); } } else { projectsSelected = new ArrayList(); projectsSelected.Add(int.Parse((string)Request.QueryString["project_id"])); Session["projectsSelected"] = projectsSelected; } // Tag Page TagPage(); // Initialize viewstate variables ViewState["StepFrom"] = "Out"; Session.Remove("labourHoursInformationDummy"); Session.Remove("labourHoursInformation"); Session.Remove("unitsInformationDummy"); Session.Remove("unitsInformation"); Session.Remove("subcontractorsInformationDummy"); Session.Remove("subcontractorsInformation"); Session.Remove("materialsInformationDummy"); Session.Remove("materialsInformation"); Session.Remove("otherCostsInformationDummy"); Session.Remove("otherCostsInformation"); Session.Remove("revenueInformationDummy"); Session.Remove("revenueInformation"); Session.Remove("templateInformationDummy"); Session.Remove("templateInformation"); // ... Initialize tables projectCostingSheetAddTDS = new ProjectCostingSheetAddTDS(); labourHoursInformation = new ProjectCostingSheetAddTDS.CombinedLabourHoursInformationDataTable(); unitsInformation = new ProjectCostingSheetAddTDS.CombinedUnitsInformationDataTable(); subcontractorsInformation = new ProjectCostingSheetAddTDS.CombinedSubcontractorsInformationDataTable(); materialsInformation = new ProjectCostingSheetAddTDS.CombinedMaterialsInformationDataTable(); otherCostsInformation = new ProjectCostingSheetAddTDS.CombinedOtherCostsInformationDataTable(); revenueInformation = new ProjectCostingSheetAddTDS.CombinedRevenueInformationDataTable(); templateInformation = new ProjectCostingSheetAddTDS.TemplateInformationDataTable(); tbxTeamMembersTotalCostCAD.Text = "0"; tbxTeamMembersTotalCostUSD.Text = "0"; tbxUnitsTotalCostsCAD.Text = "0"; tbxUnitsTotalCostsUSD.Text = "0"; tbxSubcontractorsTotalCostsCAD.Text = "0"; tbxSubcontractorsTotalCostsUSD.Text = "0"; tbxMaterialsTotalCostsCAD.Text = "0"; tbxMaterialsTotalCostsUSD.Text = "0"; tbxOtherCostsTotalCostsCAD.Text = "0"; tbxOtherCostsTotalCostsUSD.Text = "0"; tbxRevenueTotal.Text = "0"; tbxGradRevenue.Text = "0"; tbxGrandProfit.Text = "0"; tbxGrandGrossMargin.Text = "0"; // ... Store tables Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; Session["labourHoursInformation"] = labourHoursInformation; Session["unitsInformation"] = unitsInformation; Session["subcontractorsInformation"] = subcontractorsInformation; Session["materialsInformation"] = materialsInformation; Session["otherCostsInformation"] = otherCostsInformation; Session["revenueInformation"] = revenueInformation; Session["templateInformation"] = templateInformation; // StepGeneralInformation wzProjectCostinsSheetsAdd.ActiveStepIndex = 0; } else { // Restore tables projectCostingSheetAddTDS = (ProjectCostingSheetAddTDS)Session["projectCostingSheetAddTDS"]; labourHoursInformation = (ProjectCostingSheetAddTDS.CombinedLabourHoursInformationDataTable)Session["labourHoursInformation"]; unitsInformation = (ProjectCostingSheetAddTDS.CombinedUnitsInformationDataTable)Session["unitsInformation"]; subcontractorsInformation = (ProjectCostingSheetAddTDS.CombinedSubcontractorsInformationDataTable)Session["subcontractorsInformation"]; materialsInformation = (ProjectCostingSheetAddTDS.CombinedMaterialsInformationDataTable)Session["materialsInformation"]; otherCostsInformation = (ProjectCostingSheetAddTDS.CombinedOtherCostsInformationDataTable)Session["otherCostsInformation"]; revenueInformation = (ProjectCostingSheetAddTDS.CombinedRevenueInformationDataTable)Session["revenueInformation"]; templateInformation = (ProjectCostingSheetAddTDS.TemplateInformationDataTable)Session["templateInformation"]; projectsSelected = (ArrayList)Session["projectsSelected"]; foreach (int projectIdSelected in projectsSelected) { ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectIdSelected); string name = projectGateway.GetName(projectIdSelected); projectList.Add(new ListItem(name, projectIdSelected.ToString())); } } }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_ADMIN"])) { if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_ADD"]))) { 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["project_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_costing_sheets_add.aspx"); } // Tag Page TagPage(); // Initialize viewstate variables ViewState["StepFrom"] = "Out"; Session.Remove("labourHoursInformationDummy"); Session.Remove("labourHoursInformation"); Session.Remove("unitsInformationDummy"); Session.Remove("unitsInformation"); Session.Remove("subcontractorsInformationDummy"); Session.Remove("subcontractorsInformation"); Session.Remove("materialsInformationDummy"); Session.Remove("materialsInformation"); Session.Remove("otherCostsInformationDummy"); Session.Remove("otherCostsInformation"); Session.Remove("revenueInformationDummy"); Session.Remove("revenueInformation"); Session.Remove("templateInformationDummy"); Session.Remove("templateInformation"); Session.Remove("hotelsInformationDummy"); Session.Remove("hotelsInformation"); Session.Remove("bondingsInformationDummy"); Session.Remove("bondingsInformation"); Session.Remove("insurancesInformationDummy"); Session.Remove("insurancesInformation"); Session.Remove("otherCategoryInformationDummy"); Session.Remove("otherCategoryInformation"); // ... Initialize tables projectCostingSheetAddTDS = new ProjectCostingSheetAddTDS(); labourHoursInformation = new ProjectCostingSheetAddTDS.LabourHoursInformationDataTable(); unitsInformation = new ProjectCostingSheetAddTDS.UnitsInformationDataTable(); subcontractorsInformation = new ProjectCostingSheetAddTDS.SubcontractorsInformationDataTable(); materialsInformation = new ProjectCostingSheetAddTDS.MaterialsInformationDataTable(); otherCostsInformation = new ProjectCostingSheetAddTDS.OtherCostsInformationDataTable(); revenueInformation = new ProjectCostingSheetAddTDS.RevenueInformationDataTable(); templateInformation = new ProjectCostingSheetAddTDS.TemplateInformationDataTable(); hotelsInformation = new ProjectCostingSheetAddTDS.HotelsInformationDataTable(); bondingsInformation = new ProjectCostingSheetAddTDS.BondingsInformationDataTable(); insurancesInformation = new ProjectCostingSheetAddTDS.InsurancesInformationDataTable(); otherCategoryInformation = new ProjectCostingSheetAddTDS.OtherCategoryInformationDataTable(); tbxTeamMembersTotalCostCAD.Text = "0"; tbxTeamMembersTotalCostUSD.Text = "0"; tbxUnitsTotalCostsCAD.Text = "0"; tbxUnitsTotalCostsUSD.Text = "0"; tbxSubcontractorsTotalCostsCAD.Text = "0"; tbxSubcontractorsTotalCostsUSD.Text = "0"; tbxMaterialsTotalCostsCAD.Text = "0"; tbxMaterialsTotalCostsUSD.Text = "0"; tbxOtherCostsTotalCostsCAD.Text = "0"; tbxOtherCostsTotalCostsUSD.Text = "0"; tbxRevenueTotal.Text = "0"; tbxGradRevenue.Text = "0"; tbxGrandProfit.Text = "0"; tbxGrandGrossMargin.Text = "0"; tbxHotelsTotalCostsCAD.Text = "0"; tbxHotelsTotalCostsUSD.Text = "0"; tbxBondingsTotalCostsCAD.Text = "0"; tbxBondingsTotalCostsUSD.Text = "0"; tbxInsurancesTotalCostsCAD.Text = "0"; tbxInsurancesTotalCostsUSD.Text = "0"; tbxOtherCategoryTotalCostsCAD.Text = "0"; tbxOtherCategoryTotalCostsUSD.Text = "0"; // ... Store tables Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; Session["labourHoursInformation"] = labourHoursInformation; Session["unitsInformation"] = unitsInformation; Session["subcontractorsInformation"] = subcontractorsInformation; Session["materialsInformation"] = materialsInformation; Session["otherCostsInformation"] = otherCostsInformation; Session["revenueInformation"] = revenueInformation; Session["templateInformation"] = templateInformation; Session["hotelsInformation"] = hotelsInformation; Session["bondingsInformation"] = bondingsInformation; Session["insurancesInformation"] = insurancesInformation; Session["otherCategoryInformation"] = otherCategoryInformation; // StepGeneralInformation wzProjectCostinsSheetsAdd.ActiveStepIndex = 0; } else { // Restore tables projectCostingSheetAddTDS = (ProjectCostingSheetAddTDS)Session["projectCostingSheetAddTDS"]; labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)Session["labourHoursInformation"]; unitsInformation = (ProjectCostingSheetAddTDS.UnitsInformationDataTable)Session["unitsInformation"]; subcontractorsInformation = (ProjectCostingSheetAddTDS.SubcontractorsInformationDataTable)Session["subcontractorsInformation"]; materialsInformation = (ProjectCostingSheetAddTDS.MaterialsInformationDataTable)Session["materialsInformation"]; otherCostsInformation = (ProjectCostingSheetAddTDS.OtherCostsInformationDataTable)Session["otherCostsInformation"]; revenueInformation = (ProjectCostingSheetAddTDS.RevenueInformationDataTable)Session["revenueInformation"]; templateInformation = (ProjectCostingSheetAddTDS.TemplateInformationDataTable)Session["templateInformation"]; hotelsInformation = (ProjectCostingSheetAddTDS.HotelsInformationDataTable)Session["hotelsInformation"]; bondingsInformation = (ProjectCostingSheetAddTDS.BondingsInformationDataTable)Session["bondingsInformation"]; insurancesInformation = (ProjectCostingSheetAddTDS.InsurancesInformationDataTable)Session["insurancesInformation"]; otherCategoryInformation = (ProjectCostingSheetAddTDS.OtherCategoryInformationDataTable)Session["otherCategoryInformation"]; } }
/// <summary> /// GetUnitData /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="unitId">unitId</param> /// <param name="work_">work_</param> /// <param name="newRow">newRow</param> /// <param name="isTowedUnitId">isTowedUnitId</param> private void GetUnitData(DateTime startDate, DateTime endDate, int unitId, string work_, ProjectCostingSheetAddTDS.UnitsInformationRow newRow, bool isTowedUnitId) { ProjectCostingSheetAddUnitListGateway projectCostingSheetAddUnitListGateway = new ProjectCostingSheetAddUnitListGateway(); projectCostingSheetAddUnitListGateway.LoadByStartDateEndDateUnitIdWork_(startDate, endDate, unitId, work_); if (projectCostingSheetAddUnitListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddUnitListGateway.LoadByStartDateEndDateUnitId(startDate, endDate, unitId); if (projectCostingSheetAddUnitListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddUnitListGateway.LoadByStartDateUnitIdWork_(startDate, unitId, work_); if (projectCostingSheetAddUnitListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddUnitListGateway.LoadByStartDateUnitId(startDate, unitId); if (projectCostingSheetAddUnitListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddUnitListGateway.LoadByUnitId(unitId); } } } } DataRow unitRow = projectCostingSheetAddUnitListGateway.GetRow(unitId); if (isTowedUnitId) { try { newRow.CostCad = (decimal)unitRow["CostCad"] / 2; newRow.CostUsd = (decimal)unitRow["CostUsd"] / 2; } catch { newRow.CostCad = 0; newRow.CostUsd = 0; } } else { newRow.CostCad = (decimal)unitRow["CostCad"]; newRow.CostUsd = (decimal)unitRow["CostUsd"]; } }
/// <summary> /// GetMaterialData /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="materialId">v</param> /// <param name="work_">work_</param> /// <param name="newRow">newRow</param> private void GetMaterialData(DateTime startDate, DateTime endDate, int materialId, string work_, ProjectCostingSheetAddTDS.MaterialsInformationRow newRow) { ProjectCostingSheetAddMaterialListGateway projectCostingSheetAddMaterialListGateway = new ProjectCostingSheetAddMaterialListGateway(); projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialIdWork_(startDate, endDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialId(startDate, endDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialIdWork_(startDate, materialId, work_); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialId(startDate, materialId); if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddMaterialListGateway.LoadByMaterialId(materialId); } } } } DataRow materialRow = projectCostingSheetAddMaterialListGateway.GetRow(materialId); newRow.CostUsd = (decimal)materialRow["CostUsd"]; newRow.CostCad = (decimal)materialRow["CostCad"]; }
/// <summary> /// GetEmployeeDataOvertime /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="employeeId">employeeId</param> /// <param name="work_">work_</param> /// <param name="newRow">newRow</param> private void GetEmployeeDataOvertime(DateTime startDate, DateTime endDate, int employeeId, string work_, ProjectCostingSheetAddTDS.LabourHoursInformationRow newRow) { ProjectCostingSheetAddEmployeeListGateway projectCostingSheetAddEmployeeListGateway = new ProjectCostingSheetAddEmployeeListGateway(); projectCostingSheetAddEmployeeListGateway.LoadByStartDateEndDateEmployeeIdWork_(startDate, endDate, employeeId, work_); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEndDateEmployeeId(startDate, endDate, employeeId); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEmployeeIdWork_(startDate, employeeId, work_); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEmployeeId(startDate, employeeId); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByEmployeeId(employeeId); } } } } DataRow employeeRow = projectCostingSheetAddEmployeeListGateway.GetRow(employeeId); newRow.LHUnitOfMeasurement = (string)employeeRow["UnitOfMeasurement"]; newRow.LHCostCad = ((decimal)employeeRow["CostCad"] * 1.5M) + (decimal)employeeRow["BenefitFactorCad"];//employeeRow["CostCad"] == PayRateCad + BurdenRateCad newRow.LHCostUsd = ((decimal)employeeRow["CostUsd"] * 1.5M) + (decimal)employeeRow["BenefitFactorUsd"];//employeeRow["CostUsd"] == PayRateUsd + BurdenRateUsd if ((decimal)employeeRow["CostCad"] > 0) { newRow.LHCostUsd = (decimal)employeeRow["CostCad"] + (decimal)employeeRow["BenefitFactorCad"];//employeeRow["CostUsd"] == PayRateUsd + BurdenRateUsd } }
/// <summary> /// GetEmployeeDataFairWageOvertime /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="employeeId">employeeId</param> /// <param name="work_">work_</param> /// <param name="newRow">newRow</param> /// <param name="contryId">contryId</param> /// <param name="fringeRate">fringeRate</param> /// <param name="fairWageRate">fairWageRate</param> private void GetEmployeeDataFairWageOvertime(DateTime startDate, DateTime endDate, int employeeId, string work_, ProjectCostingSheetAddTDS.LabourHoursInformationRow newRow, int contryId, decimal fringeRate, decimal fairWageRate) { ProjectCostingSheetAddEmployeeListGateway projectCostingSheetAddEmployeeListGateway = new ProjectCostingSheetAddEmployeeListGateway(); projectCostingSheetAddEmployeeListGateway.LoadByStartDateEndDateEmployeeIdWork_FairWage(startDate, endDate, employeeId, work_); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEndDateEmployeeIdFairWage(startDate, endDate, employeeId); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEmployeeIdWork_FairWage(startDate, employeeId, work_); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByStartDateEmployeeIdFairWage(startDate, employeeId); if (projectCostingSheetAddEmployeeListGateway.Table.Rows.Count <= 0) { projectCostingSheetAddEmployeeListGateway.LoadByEmployeeId(employeeId); } } } } DataRow employeeRow = projectCostingSheetAddEmployeeListGateway.GetRow(employeeId); newRow.LHUnitOfMeasurement = (string)employeeRow["UnitOfMeasurement"]; if (contryId == 1) { //Canada decimal regularRate = 0; if (!employeeRow.IsNull("PayRateCad")) { regularRate = (decimal)employeeRow["PayRateCad"]; } decimal rate = fairWageRate * 1.5M; decimal burdenRate = 0; if (fairWageRate < regularRate) { rate = regularRate * 1.5M; } if (!employeeRow.IsNull("BourdenFactor")) { decimal burdenFactor = (decimal)employeeRow["BourdenFactor"] / 100; burdenRate = rate * burdenFactor; } newRow.LHCostCad = rate + fringeRate + burdenRate; newRow.LHCostUsd = rate + fringeRate + burdenRate; } else { //USA decimal regularRate = 0; if (!employeeRow.IsNull("PayRateUsd")) { regularRate = (decimal)employeeRow["PayRateUsd"]; } decimal benefitFactorUsd = 0; if (!employeeRow.IsNull("HealthBenefitUsd")) { benefitFactorUsd = (decimal)employeeRow["BenefitFactorUsd"]; } decimal healtBenefitFactor = 0; if (!employeeRow.IsNull("HealthBenefitUsd")) { decimal usHealthBenefitFactor = (decimal)employeeRow["HealthBenefitUsd"] / 100; healtBenefitFactor = benefitFactorUsd + (benefitFactorUsd * usHealthBenefitFactor); } else { healtBenefitFactor = benefitFactorUsd; } decimal burdenRate = 0; decimal fringeDeficiency = fringeRate - benefitFactorUsd; decimal rate = fairWageRate * 1.5M; if (fairWageRate < regularRate) { rate = regularRate * 1.5M; } if (!employeeRow.IsNull("BourdenFactor")) { decimal burdenFactor = (decimal)employeeRow["BourdenFactor"] / 100; burdenRate = (rate + fringeDeficiency) * burdenFactor; } newRow.LHCostUsd = rate + fringeDeficiency + burdenRate + healtBenefitFactor; newRow.LHCostCad = rate + fringeDeficiency + burdenRate + healtBenefitFactor; } }
private void Generate() { Page.Validate(); if (Page.IsValid) { mReport1 master = (mReport1)this.Master; ProjectCostingSheetAddTDS projectCostingSheetAddTDS = new ProjectCostingSheetAddTDS(); LiquiForce.LFSLive.BL.Projects.Projects.PrintSummaryCostingSheetByMonthDummyInformation printSummaryCostingSheetByMonthDummyInformation = new LiquiForce.LFSLive.BL.Projects.Projects.PrintSummaryCostingSheetByMonthDummyInformation(projectCostingSheetAddTDS); int rows = 0; // Get Data string year = ddlYear.SelectedItem.Value; string month = ""; foreach (ListItem lst in cbxlMonth.Items) { if (lst.Selected) { DateTime startDate = new DateTime(int.Parse(year), int.Parse(lst.Value), 1); DateTime endDate = (startDate.AddMonths(1)).AddDays(-1); rows = rows + printSummaryCostingSheetByMonthDummyInformation.LoadAll(startDate, endDate, 3, lst.Text); if (lst.Text == "(All)") { month = "(All)"; } else { month = month + ", " + lst.Text; } } } // ... set properties to master page master.Data = printSummaryCostingSheetByMonthDummyInformation.Data; master.Table = printSummaryCostingSheetByMonthDummyInformation.TableName; // Get report if (rows > 0) { if (master.Format == "pdf") { master.Report = new PrintSummaryCostingSheetByMonthReport(); // ... ... user LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"]), 3); string user = loginGateway.GetLastName(Convert.ToInt32(Session["loginID"]), 3) + " " + loginGateway.GetFirstName(Convert.ToInt32(Session["loginID"]), 3); master.SetParameter("User", user.Trim()); // ... for start date master.SetParameter("Year", year); // ... for end date master.SetParameter("Month", month); } else { master.Report = new PrintSummaryCostingSheetByMonthReport(); // ... ... user LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"]), 3); string user = loginGateway.GetLastName(Convert.ToInt32(Session["loginID"]), 3) + " " + loginGateway.GetFirstName(Convert.ToInt32(Session["loginID"]), 3); master.SetParameter("User", user.Trim()); // ... for start date master.SetParameter("Year", year); // ... for end date master.SetParameter("Month", month); } } } }