private int UpdateDatabase()
{
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
Int64? countryId = null;
Int64? provinceId = null;
Int64? countyId = null;
Int64? cityId = null;
if (projectGateway.Table.Rows.Count > 0)
{
// ... Get ids
try
{//TODO MH
countryId = projectGateway.GetCountryID(projectId);
}
catch
{
}
if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId);
if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId);
if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId);
}
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
bool inProject = bool.Parse(hdfInProject.Value);
DB.Open();
DB.BeginTransaction();
try
{
// Save section details
ManholeRehabilitationManholeDetails manholeRehabilitationManholeDetails = new ManholeRehabilitationManholeDetails(manholeRehabilitationTDS);
manholeRehabilitationManholeDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId);
// Save work details
ManholeRehabilitationWorkDetails fullLengthLiningWorkDetails = new ManholeRehabilitationWorkDetails(manholeRehabilitationTDS);
workId = fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, inProject);
DB.CommitTransaction();
// Store datasets
manholeRehabilitationTDS.AcceptChanges();
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
return workId;
}
private void LoadSaleBillingPricing()
{
// Data for Sale/Billing/Pricing tab
if (projectTDS.LFS_PROJECT_SALE_BILLING_PRICING.Rows.Count == 0)
{
// ... If the project has no Sale/Billing/Pricing
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
string billMoney = "CAD"; if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 2) billMoney = "USD";
ProjectSaleBillingPricing projectSaleBillingPricing = new ProjectSaleBillingPricing(projectTDS);
projectSaleBillingPricing.Insert(int.Parse(hdfProjectId.Value), false, false, false, false, "", false, "", null, null, billMoney, "", false, false, "", null, false, null, false, null, Int32.Parse(hdfCompanyId.Value.Trim()));
}
ddlBillMoneySaleBillingPricing.DataBind();
//cbxBillHourly.DataBind();
//cbxBillPerUnit.DataBind();
//cbxChargesDisposal.DataBind();
//cbxChargesWater.DataBind();
//cbxSaleBidProject.DataBind();
//cbxSaleOther.DataBind();
//cbxSaleRFP.DataBind();
//cbxSaleSoleSource.DataBind();
//cbxSaleTermContract.DataBind();
//tbxBillBidHardDollar.DataBind();
//tbxBillExpectExtras.DataBind();
tbxBillPriceSaleBillingPricing.DataBind();
tbxBillSubcontractorAmount.DataBind();
//tbxChargesDisposalAmount.DataBind();
//tbxChargesWaterAmount.DataBind();
//tbxSaleGettingJob.DataBind();
//tbxSaleOtherDetail.DataBind();
//tbxSaleTermContractDetail.DataBind();
// Databind Grid for Services
//grdServices.DataBind();
}
private void UpdateDataForNavigator()
{
foreach (ActualCostsNavigatorTDS.HotelCostsRow row in (ActualCostsNavigatorTDS.HotelCostsDataTable)Table)
{
int projectId = row.ProjectID;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
row.RateUsd = row.RateCad;
}
}
}
private void TagPage()
{
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfWorkType.Value = "Full Length Lining";
hdfAssetId.Value = Request.QueryString["asset_id"].ToString();
hdfErrorFieldList.Value = "";
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
// ... Get ids
Int64 currentCountry = projectGateway.GetCountryID(projectId);
Int64? currentProvince = null; if (projectGateway.GetProvinceID(projectId).HasValue) currentProvince = (Int64)projectGateway.GetProvinceID(projectId);
Int64? currentCounty = null; if (projectGateway.GetCountyID(projectId).HasValue) currentCounty = (Int64)projectGateway.GetCountyID(projectId);
Int64? currentCity = null; if (projectGateway.GetCityID(projectId).HasValue) currentCity = (Int64)projectGateway.GetCityID(projectId);
hdfCountryId.Value = currentCountry.ToString();
hdfProvinceId.Value = currentProvince.ToString();
hdfCountyId.Value = currentCounty.ToString();
hdfCityId.Value = currentCity.ToString();
// Get workId
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
string workType = hdfWorkType.Value;
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, workType, companyId);
hdfWorkId.Value = workGateway.GetWorkId(assetId, workType, projectId).ToString();
hdfWorkIdJl.Value = GetWorkId(projectId, assetId, "Junction Lining Section", companyId).ToString();
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Reload data for work and functions depending if it's faire wage or not.
grdTypeOfWorkFunctionClassification.DataBind();
// Security check
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_ADMIN"]))
{
// ... menu reports
tkrpbLeftMenuReports.Visible = false;
// ... for job info tab
tpJobInfo.Enabled = true;
// ... for values that comes from sales billing pricing tab
//tpSaleBillingPricing.Enabled = false;
upnlSaleBillingPricingValues.Visible = false;
upnlSaleBillingPricingValues1.Visible = false;
// ... for values that comes from costing updates
//tpCostingUpdates.Enabled = false;
}
else
{
// ... menu reports
tkrpbLeftMenuReports.Visible = true;
// ... for job info tab
tpJobInfo.Enabled = true;
// ... for values that comes from sales billing pricing
//tpSaleBillingPricing.Enabled = true;
upnlSaleBillingPricingValues.Visible = true;
upnlSaleBillingPricingValues1.Visible = true;
// ... for values that comes from costing updates
//tpCostingUpdates.Enabled = true;
}
// Country check
if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1)
{
//ddlGeneralMOLForm.Visible = true;
//tbxGeneralMOLForm.Visible = false;
//lblGeneralNoticeProject.Visible = true;
//rbtnGeneralNoticeProject.Visible = true;
//lblGeneralForm1000.Visible = true;
//rbtnGeneralForm1000.Visible = true;
grdJobClassClassification.Columns[4].HeaderText = "Rate (CAD)";
grdJobClassClassification.Columns[5].HeaderText = "Fringe Rate (CAD)";
}
else
{
//ddlGeneralMOLForm.Visible = false;
//tbxGeneralMOLForm.Visible = true;
//lblGeneralNoticeProject.Visible = false;
//rbtnGeneralNoticeProject.Visible = false;
//lblGeneralForm1000.Visible = false;
//rbtnGeneralForm1000.Visible = false;
grdJobClassClassification.Columns[4].HeaderText = "Rate (USD)";
grdJobClassClassification.Columns[5].HeaderText = "Fringe Rate (USD)";
}
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "Projects";
// Project type check
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Ballpark")
{
// Active Tab
tcDetailedInformation.ActiveTabIndex = 1;
// Left menu
tkrpbLeftMenuCurrentProject.Items[0].Text = "Current Ballpark";
tkrpbLeftMenuCurrentProject.Items[0].Items[0].Text = "Ballpark";
tkrpbLeftMenuCurrentProject.Items[0].Items[2].Visible = false; //mSeparator
tkrpbLeftMenuCurrentProject.Items[0].Items[3].Visible = false; //mSections
lblHeaderTitle.Text = "Ballpark Summary";
lblTitleProject.Text = " > Ballpark: ";
// Initial section
lblProposalDate.Text = "Ballpark Date";
lblStartDate.Text = "Potential Start Date";
lblEndDate.Text = "Potential End Date";
lblStartDate.Visible = true;
tkrdpStartDate.Visible = true;
lblEndDate.Visible = true;
tkrdpEndDate.Visible = true;
// Client section
lblClientProjectNumber.Visible = false;
tbxClientProjectNumber.Visible = false;
lblClientPrimaryContactId.Visible = false;
ddlClientPrimaryContactId.Visible = false;
btnClientPrimaryContact.Visible = false;
lblClientSecondaryContactId.Visible = false;
ddlClientSecondaryContactId.Visible = false;
btnClientSecondaryContact.Visible = false;
// Pricing section
pnlPricing.Visible = true;
// Tabs visibility
tpJobInfo.Enabled = true;
upnlTypeOfWork.Visible = false;
// ... for values that comes from sales billing pricing
//tpSaleBillingPricing.Enabled = false;
upnlSaleBillingPricingValues.Visible = false;
upnlSaleBillingPricingValues1.Visible = false;
// ... for values that comes from costing update
//tpCostingUpdates.Enabled = false;
// ... for values that comes from terms po
//tpTermsPo.Enabled = false;
upnlTermsPO.Visible = false;
upnlTermsPO1.Visible = false;
upnlTermsPO2.Visible = false;
upnlTermsPO3.Visible = false;
// ... for values that comes from technical
//tpTechnical.Enabled = false;
upnlTechnical.Visible = false;
// ... for values that comes from engineer subcontractors
// tpEngineerSubcontractors.Enabled = false;
// Subcontractor section
// lblNoResults.Text = "Sub-Contractors are not defined for this ballpark";
upnlEngineerSubcontractors.Visible = false;
upnlEngineerSubcontractors1.Visible = false;
upnlEngineerSubcontractors2.Visible = false;
upnlEngineerSubcontractors3.Visible = false;
upnlEngineerSubcontractors4.Visible = false;
upnlEngineerSubcontractors5.Visible = false;
upnlEngineerSubcontractors6.Visible = false;
upnlEngineerSubcontractors7.Visible = false;
// ... for values that comes from cost exceptions
//tpCostExceptions.Enabled = false;
pnlCostsExceptions.Visible = false;
// ... for values that comes from notes
//tpNotes.Enabled = true;
upnlNotes.Visible = true;
}
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Proposal")
{
// Set initial tab
tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Left menu
tkrpbLeftMenuCurrentProject.Items[0].Text = "Current Proposal";
tkrpbLeftMenuCurrentProject.Items[0].Items[0].Text = "Proposal";
tkrpbLeftMenuCurrentProject.Items[0].Items[2].Visible = false; //mSeparator
tkrpbLeftMenuCurrentProject.Items[0].Items[3].Visible = false; //mSections
lblHeaderTitle.Text = "Proposal Summary";
lblTitleProject.Text = " > Proposal: ";
lblStartDate.Text = "Potential Start Date";
lblEndDate.Text = "Potential End Date";
// Pricing section
pnlPricing.Visible = false;
// Tabs visibility
tpJobInfo.Enabled = true;
upnlTypeOfWork.Visible = true;
// ... for values that comes from sales billing pricing
//tpSaleBillingPricing.Enabled = true;
upnlSaleBillingPricingValues.Visible = true;
upnlSaleBillingPricingValues1.Visible = true;
// ... for values that comes from costing updates
//tpCostingUpdates.Enabled = true;
// ... for values that comes from terms po
//tpTermsPo.Enabled = true;
upnlTermsPO.Visible = true;
upnlTermsPO1.Visible = true;
upnlTermsPO2.Visible = true;
upnlTermsPO3.Visible = true;
// ... for values that comes from technical
//tpTechnical.Enabled = true;
upnlTechnical.Visible = true;
// ... for values that comes from engineer subcontractors
// tpEngineerSubcontractors.Enabled = true;
// Subcontractor section
// lblNoResults.Text = "Sub-Contractors are not defined for this proposal";
upnlEngineerSubcontractors.Visible = true;
upnlEngineerSubcontractors1.Visible = true;
upnlEngineerSubcontractors2.Visible = true;
upnlEngineerSubcontractors3.Visible = true;
upnlEngineerSubcontractors4.Visible = true;
upnlEngineerSubcontractors5.Visible = true;
upnlEngineerSubcontractors6.Visible = true;
upnlEngineerSubcontractors7.Visible = true;
// ... for values that comes from cost exceptions
//tpCostExceptions.Enabled = false;
pnlCostsExceptions.Visible = false;
if ((projectGateway.GetProjectState(int.Parse(hdfProjectId.Value)) == "Awarded") || (projectGateway.GetProjectState(int.Parse(hdfProjectId.Value)) == "Bidding"))
{
tpJobInfo.Enabled = true;
//tpCostExceptions.Enabled = true;
pnlCostsExceptions.Visible = true;
}
// ... for values that comes from notes
//tpNotes.Enabled = true;
upnlNotes.Visible = true;
}
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Project")
{
// Set initial tab
tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Left menu
tkrpbLeftMenuCurrentProject.Items[0].Text = "Current Project";
tkrpbLeftMenuCurrentProject.Items[0].Items[0].Text = "Project";
lblHeaderTitle.Text = "Project Summary";
lblTitleProject.Text = " > Project: ";
lblStartDate.Text = "Start Date";
lblEndDate.Text = "End Date";
// Pricing section
pnlPricing.Visible = false;
// Tabs visibility
tpJobInfo.Enabled = true;
upnlTypeOfWork.Visible = true;
// ... for values that comes from sales billing pricing
//tpSaleBillingPricing.Enabled = true;
upnlSaleBillingPricingValues.Visible = true;
upnlSaleBillingPricingValues1.Visible = true;
// ... for values that comes from costing updates
//tpCostingUpdates.Enabled = true;
// ... for values that comes from terms po
// tpTermsPo.Enabled = true;
upnlTermsPO.Visible = true;
upnlTermsPO1.Visible = true;
upnlTermsPO2.Visible = true;
upnlTermsPO3.Visible = true;
// ... for values that comes from technical
// tpTechnical.Enabled = true;
upnlTechnical.Visible = true;
// ... for values that comes from engineer subcontractors
// tpEngineerSubcontractors.Enabled = true;
// Subcontractor section
// lblNoResults.Text = "Sub-Contractors are not defined for this project";
upnlEngineerSubcontractors.Visible = true;
upnlEngineerSubcontractors1.Visible = true;
upnlEngineerSubcontractors2.Visible = true;
upnlEngineerSubcontractors3.Visible = true;
upnlEngineerSubcontractors4.Visible = true;
upnlEngineerSubcontractors5.Visible = true;
upnlEngineerSubcontractors6.Visible = true;
upnlEngineerSubcontractors7.Visible = true;
// ... for values that comes from cost exceptions
//tpCostExceptions.Enabled = true;
pnlCostsExceptions.Visible = true;
// ... for values that comes from notes
//tpNotes.Enabled = true;
upnlNotes.Visible = true;
}
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Internal")
{
// Active Tab
tcDetailedInformation.ActiveTabIndex = 1;
// Left menu
tkrpbLeftMenuCurrentProject.Items[0].Text = "Current Internal Project";
tkrpbLeftMenuCurrentProject.Items[0].Items[0].Text = "Internal Project";
tkrpbLeftMenuCurrentProject.Items[0].Items[2].Visible = false; //mSeparator
tkrpbLeftMenuCurrentProject.Items[0].Items[3].Visible = false; //mSections
lblHeaderTitle.Text = "Internal Project Summary";
lblTitleProject.Text = " > Internal Project: ";
// Initial section
lblProposalDate.Text = "Internal Project Date";
lblStartDate.Visible = false;
tkrdpStartDate.Visible = false;
lblEndDate.Visible = false;
tkrdpEndDate.Visible = false;
tbxDescription.Width = Unit.Pixel(510);
// Client section
lblClientProjectNumber.Visible = false;
tbxClientProjectNumber.Visible = false;
lblClientPrimaryContactId.Visible = false;
ddlClientPrimaryContactId.Visible = false;
btnClientPrimaryContact.Visible = false;
lblClientSecondaryContactId.Visible = false;
ddlClientSecondaryContactId.Visible = false;
btnClientSecondaryContact.Visible = false;
// Pricing section
pnlPricing.Visible = false;
// Tabs visibility
tpJobInfo.Enabled = true;
upnlTypeOfWork.Visible = false;
// ... for values that comes from sales billing pricing
//tpSaleBillingPricing.Enabled = false;
upnlSaleBillingPricingValues.Visible = false;
upnlSaleBillingPricingValues1.Visible = false;
// ... for values that comes from costing updates
// tpCostingUpdates.Enabled = false;
// ... for values that comes from terms po
//tpTermsPo.Enabled = false;
upnlTermsPO.Visible = false;
upnlTermsPO1.Visible = false;
upnlTermsPO2.Visible = false;
upnlTermsPO3.Visible = false;
// ... for values that comes from technical
//tpTechnical.Enabled = false;
upnlTechnical.Visible = false;
// ... for values that comes from engineer subcontractors
// tpEngineerSubcontractors.Enabled = true;
// Subcontractor section
// lblNoResults.Text = "Sub-Contractors are not defined for this internal project";
upnlEngineerSubcontractors.Visible = false;
upnlEngineerSubcontractors1.Visible = false;
upnlEngineerSubcontractors2.Visible = false;
upnlEngineerSubcontractors3.Visible = false;
upnlEngineerSubcontractors4.Visible = false;
upnlEngineerSubcontractors5.Visible = false;
upnlEngineerSubcontractors6.Visible = false;
upnlEngineerSubcontractors7.Visible = false;
// ... for values that comes from cost exceptions
//tpCostExceptions.Enabled = false;
pnlCostsExceptions.Visible = false;
// ... for values that comes from notes
//tpNotes.Enabled = true;
upnlNotes.Visible = true;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Dialog title
mDialog2 dialog2 = (mDialog2)this.Master;
dialog2.DialogTitle = "Add Sub-Contractor";
// Country check
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1)
{
ddlSubcontractorMOLForm1000.Visible = true;
tbxSubcontractorMOLForm1000.Visible = false;
}
else
{
ddlSubcontractorMOLForm1000.Visible = false;
tbxSubcontractorMOLForm1000.Visible = true;
}
}
private void TagPage()
{
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfAssetId.Value = Request.QueryString["asset_id"].ToString();
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
// ... Get ids
Int64 currentCountry = projectGateway.GetCountryID(projectId);
Int64? currentProvince = null; if (projectGateway.GetProvinceID(projectId).HasValue) currentProvince = (Int64)projectGateway.GetProvinceID(projectId);
Int64? currentCounty = null; if (projectGateway.GetCountyID(projectId).HasValue) currentCounty = (Int64)projectGateway.GetCountyID(projectId);
Int64? currentCity = null; if (projectGateway.GetCityID(projectId).HasValue) currentCity = (Int64)projectGateway.GetCityID(projectId);
hdfCountryId.Value = currentCountry.ToString();
hdfProvinceId.Value = currentProvince.ToString();
hdfCountyId.Value = currentCounty.ToString();
hdfCityId.Value = currentCity.ToString();
// Get workId
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Point Repairs", companyId);
hdfWorkId.Value = workGateway.GetWorkId(assetId, "Point Repairs", projectId).ToString();
}
protected void grdTeamMembers_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
// Validate general data
Page.Validate("labourHoursEdit");
if (Page.IsValid)
{
projectGateway.LoadByProjectId(projectId);
// Validate costs
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("labourHoursCadEdit");
}
else
{
Page.Validate("labourHoursUsdEdit");
}
}
if (Page.IsValid)
{
int costingSheetId = (int)e.Keys["CostingSheetID"];
string work_ = (string)e.Keys["Work_"];
int employeeId = (int)e.Keys["EmployeeID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string name = ((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxTeamMemberEdit")).Text;
string unitOfMeasurementLH = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitOfMeasurementLHEdit")).SelectedValue;
double lHQuantity = double.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHQtyEdit")).Text.Trim());
string unitOfMeasurementMeals = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitsOfMeasurementLHMealsEdit")).SelectedValue;
int? mealsQuantity = null; if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsQtyEdit")).Text.Trim() != "") mealsQuantity = Int32.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsQtyEdit")).Text.Trim());
string unitOfMeasurementMotel = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitsOfMeasurementLHMotelEdit")).SelectedValue;
int? motelQuantity = null; if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelQtyEdit")).Text.Trim() != "") motelQuantity = Int32.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelQtyEdit")).Text.Trim());
decimal lhCostCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal? mealsCostCad = null;
decimal? motelCostCad = null;
decimal lhCostUsd = 0.0M;
decimal totalCostUsd = 0.0M;
decimal? mealsCostUsd = null;
decimal? motelCostUsd = null;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
lhCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHCostCADEdit")).Text.Trim());
if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostCADEdit")).Text.Trim() != "") mealsCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostCADEdit")).Text.Trim());
if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostCADEdit")).Text.Trim() != "") motelCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostCADEdit")).Text.Trim());
totalCostCad = (lhCostCad * decimal.Parse(lHQuantity.ToString()));
if (mealsCostCad.HasValue && mealsQuantity.HasValue) totalCostCad = totalCostCad + (mealsCostCad.Value * decimal.Parse(mealsQuantity.Value.ToString()));
if (motelCostCad.HasValue && motelQuantity.HasValue) totalCostCad = totalCostCad + (motelCostCad.Value * decimal.Parse(motelQuantity.Value.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
lhCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHCostUSDEdit")).Text.Trim());
if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostUSDEdit")).Text.Trim() != "") mealsCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostUSDEdit")).Text.Trim());
if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostUSDEdit")).Text.Trim() != "") motelCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostUSDEdit")).Text.Trim());
totalCostUsd = (lhCostUsd * decimal.Parse(lHQuantity.ToString()));
if (mealsCostUsd.HasValue && mealsQuantity.HasValue) totalCostUsd = totalCostUsd + (mealsCostUsd.Value * decimal.Parse(mealsQuantity.Value.ToString()));
if (motelCostUsd.HasValue && motelQuantity.HasValue) totalCostUsd = totalCostUsd + (motelCostUsd.Value * decimal.Parse(motelQuantity.Value.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
DateTime startDate = ((RadDatePicker)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tkrdpStartDateEdit")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tkrdpEndDateEdit")).SelectedDate.Value;
string workFunctionConcat = "";
string function_ = "";
workFunctionConcat = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlWorkFunctionEdit")).SelectedValue;
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
function_ = workFunction[1].Trim();
}
// Update data
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
model.Update(costingSheetId, work_, employeeId, refId, lHQuantity, unitOfMeasurementLH, unitOfMeasurementMeals, mealsQuantity, unitOfMeasurementMotel, motelQuantity, lhCostCad, mealsCostCad, motelCostCad, totalCostCad, lhCostUsd, mealsCostUsd, motelCostUsd, totalCostUsd, false, companyId, name, startDate, endDate, workFunctionConcat, function_);
// Store dataset
labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table;
Session["labourHoursInformation"] = labourHoursInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
StepLabourHoursInformationProcessGrid();
}
else
{
e.Cancel = true;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP5 - TRUCKS EQUIPMENT INFORMATION
//
// ////////////////////////////////////////////////////////////////////////
// STEP5 - TRUCKS EQUIPMENT INFORMATION - EVENTS
//
protected void grdUnits_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Add":
// Units Gridview, if the gridview is edition mode
if (grdUnits.EditIndex >= 0)
{
grdUnits.UpdateRow(grdUnits.EditIndex, true);
}
// Validate general data
Page.Validate("unitsNew");
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("unitsCadNew");
}
else
{
Page.Validate("unitsUsdNew");
}
}
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
string typeOfWork = ((DropDownList)grdUnits.FooterRow.FindControl("ddlTypeOfWork_New")).SelectedValue;
int unitId = Int32.Parse(((DropDownList)grdUnits.FooterRow.FindControl("ddlUnitCodeNew")).SelectedValue);
string unitCode = ((DropDownList)grdUnits.FooterRow.FindControl("ddlUnitCodeNew")).SelectedItem.Text;
string unitOfMeasurement = ((DropDownList)grdUnits.FooterRow.FindControl("ddlUnitOfMeasurementUnitsNew")).SelectedValue;
double quantity = double.Parse(((TextBox)grdUnits.FooterRow.FindControl("tbxQuantityNew")).Text.Trim());
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdUnits.FooterRow.FindControl("tbxCostCADNew")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdUnits.FooterRow.FindControl("tbxCostUSDNew")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
LFSLive.DA.FleetManagement.Units.UnitsGateway u = new LiquiForce.LFSLive.DA.FleetManagement.Units.UnitsGateway();
u.LoadByUnitId(unitId, companyId);
string unitDescription = u.GetDescription(unitId);
DateTime startDate = ((RadDatePicker)grdUnits.FooterRow.FindControl("tkrdpStartDateNew")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdUnits.FooterRow.FindControl("tkrdpEndDateNew")).SelectedDate.Value;
string workFunctionConcat = "";
string function_ = "";
workFunctionConcat = ((DropDownList)grdUnits.FooterRow.FindControl("ddlWorkFunctionNew")).SelectedValue;
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
function_ = workFunction[1].Trim();
}
ProjectCostingSheetAddUnitsInformation model = new ProjectCostingSheetAddUnitsInformation(projectCostingSheetAddTDS);
model.Insert(0, typeOfWork, unitId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, false, companyId, unitCode, unitDescription, startDate, endDate, workFunctionConcat, function_);
Session.Remove("unitsInformationDummy");
unitsInformation = (ProjectCostingSheetAddTDS.UnitsInformationDataTable)model.Table;
Session["unitsInformation"] = unitsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdUnits.DataBind();
StepTrucksEquipmentInformationProcessGrid();
}
break;
}
}
protected void grdSubcontractors_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Validate general data
Page.Validate("subcontractorsEdit");
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("subcontractorsCadEdit");
}
else
{
Page.Validate("subcontractorsUsdEdit");
}
}
if (Page.IsValid)
{
int costingSheetId = (int)e.Keys["CostingSheetID"];
int subcontractorId = (int)e.Keys["SubcontractorID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string unitOfMeasurement = ((DropDownList)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitOfMeasurementSubcontractorsEdit")).SelectedValue;
string subcontractor = ((TextBox)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tbxSubcontractorEdit")).Text;
string comment = ((TextBox)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tbxCommentEdit")).Text;
double quantity = double.Parse(((TextBox)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tbxQuantityEdit")).Text.Trim());
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tbxCostCADEdit")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tbxCostUSDEdit")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
DateTime startDate = ((RadDatePicker)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tkrdpStartDateEdit")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdSubcontractors.Rows[e.RowIndex].Cells[0].FindControl("tkrdpEndDateEdit")).SelectedDate.Value;
// Update data
ProjectCostingSheetAddSubcontractorsInformation model = new ProjectCostingSheetAddSubcontractorsInformation(projectCostingSheetAddTDS);
model.Update(costingSheetId, subcontractorId, refId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, false, companyId, comment, startDate, endDate);
// Store dataset
subcontractorsInformation = (ProjectCostingSheetAddTDS.SubcontractorsInformationDataTable)model.Table;
Session["subcontractorsInformation"] = subcontractorsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
StepSubcontractorsInformationProcessGrid();
}
else
{
e.Cancel = true;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP4 - LABOUR HOUR INFORMATION
//
// ////////////////////////////////////////////////////////////////////////
// STEP4 - LABOUR HOUR INFORMATION - EVENTS
//
protected void grdTeamMembers_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Add":
// Team member Gridview, if the gridview is edition mode
if (grdTeamMembers.EditIndex >= 0)
{
grdTeamMembers.UpdateRow(grdTeamMembers.EditIndex, true);
}
// Add New Team Member
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
// Validate general data
Page.Validate("labourHoursNew");
if (Page.IsValid)
{
projectGateway.LoadByProjectId(projectId);
// Validate costs
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("labourHoursCadNew");
}
else
{
Page.Validate("labourHoursUsdNew");
}
}
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
string typeOfWork = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTypeOfWork_New")).SelectedValue;
int employeeId = Int32.Parse(((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTeamMemberNew")).SelectedValue);
string name = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTeamMemberNew")).SelectedItem.Text;
string unitOfMeasurementLH = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitOfMeasurementLHNew")).SelectedValue;
double lHQuantity = double.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHQtyNew")).Text.Trim());
string unitOfMeasurementMeals = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitsOfMeasurementLHMealsNew")).SelectedValue;
int? mealsQuantity = null; if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsQtyNew")).Text.Trim() != "") mealsQuantity = Int32.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsQtyNew")).Text.Trim());
string unitOfMeasurementMotel = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitsOfMeasurementLHMotelNew")).SelectedValue;
int? motelQuantity = null; if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelQtyNew")).Text.Trim() != "") motelQuantity = Int32.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelQtyNew")).Text.Trim());
decimal lhCostCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal? mealsCostCad = null;
decimal? motelCostCad = null;
decimal lhCostUsd = 0.0M;
decimal totalCostUsd = 0.0M;
decimal? mealsCostUsd = null;
decimal? motelCostUsd = null;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
lhCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHCostCADNew")).Text.Trim());
if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostCADNew")).Text.Trim() != "") mealsCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostCADNew")).Text.Trim());
if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostCADNew")).Text.Trim() != "") motelCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostCADNew")).Text.Trim());
totalCostCad = (lhCostCad * decimal.Parse(lHQuantity.ToString()));
if (mealsCostCad.HasValue && mealsQuantity.HasValue) totalCostCad = totalCostCad + (mealsCostCad.Value * decimal.Parse(mealsQuantity.Value.ToString()));
if (motelCostCad.HasValue && motelQuantity.HasValue) totalCostCad = totalCostCad + (motelCostCad.Value * decimal.Parse(motelQuantity.Value.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
lhCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHCostUSDNew")).Text.Trim());
if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostUSDNew")).Text.Trim() != "") mealsCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostUSDNew")).Text.Trim());
if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostUSDNew")).Text.Trim() != "") motelCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostUSDNew")).Text.Trim());
totalCostUsd = (lhCostUsd * decimal.Parse(lHQuantity.ToString()));
if (mealsCostUsd.HasValue && mealsQuantity.HasValue) totalCostUsd = totalCostUsd + (mealsCostUsd.Value * decimal.Parse(mealsQuantity.Value.ToString()));
if (motelCostUsd.HasValue && motelQuantity.HasValue) totalCostUsd = totalCostUsd + (motelCostUsd.Value * decimal.Parse(motelQuantity.Value.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
DateTime startDate = ((RadDatePicker)grdTeamMembers.FooterRow.FindControl("tkrdpStartDateNew")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdTeamMembers.FooterRow.FindControl("tkrdpEndDateNew")).SelectedDate.Value;
string workFunctionConcat = "";
string function_ = "";
workFunctionConcat = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlWorkFunctionNew")).SelectedValue;
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
function_ = workFunction[1].Trim();
}
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
model.Insert(0, typeOfWork, employeeId, lHQuantity, unitOfMeasurementLH, unitOfMeasurementMeals, mealsQuantity, unitOfMeasurementMotel, motelQuantity, lhCostCad, mealsCostCad, motelCostCad, totalCostCad, lhCostUsd, mealsCostUsd, motelCostUsd, totalCostUsd, false, companyId, name, startDate, endDate, workFunctionConcat, function_);
Session.Remove("labourHoursInformationDummy");
labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table;
Session["labourHoursInformation"] = labourHoursInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdTeamMembers.DataBind();
StepLabourHoursInformationProcessGrid();
}
break;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP7 - SUBCONTRACTOR INFORMATION
//
// ////////////////////////////////////////////////////////////////////////
// STEP7 - SUBCONTRACTOR INFORMATION - EVENTS
//
protected void grdSubcontractors_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Add":
// Subcontractors Gridview, if the gridview is edition mode
if (grdSubcontractors.EditIndex >= 0)
{
grdSubcontractors.UpdateRow(grdSubcontractors.EditIndex, true);
}
// Validate general data
Page.Validate("subcontractorsNew");
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("subcontractorsCadNew");
}
else
{
Page.Validate("subcontractorsUsdNew");
}
}
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int subcontractorId = Int32.Parse(((DropDownList)grdSubcontractors.FooterRow.FindControl("ddlSubcontractorNew")).SelectedValue);
string unitOfMeasurement = ((DropDownList)grdSubcontractors.FooterRow.FindControl("ddlUnitOfMeasurementSubcontractorsNew")).SelectedValue;
string subcontractor = ((DropDownList)grdSubcontractors.FooterRow.FindControl("ddlSubcontractorNew")).SelectedItem.Text;
double quantity = double.Parse(((TextBox)grdSubcontractors.FooterRow.FindControl("tbxQuantityNew")).Text.Trim());
string comment = ""; if (((TextBox)grdSubcontractors.FooterRow.FindControl("tbxCommentNew")).Text.Trim() != "") comment = ((TextBox)grdSubcontractors.FooterRow.FindControl("tbxCommentNew")).Text.Trim();
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdSubcontractors.FooterRow.FindControl("tbxCostCADNew")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdSubcontractors.FooterRow.FindControl("tbxCostUSDNew")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
DateTime startDate = ((RadDatePicker)grdSubcontractors.FooterRow.FindControl("tkrdpStartDateNew")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdSubcontractors.FooterRow.FindControl("tkrdpEndDateNew")).SelectedDate.Value;
ProjectCostingSheetAddSubcontractorsInformation model = new ProjectCostingSheetAddSubcontractorsInformation(projectCostingSheetAddTDS);
model.Insert(0, subcontractorId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, comment, false, companyId, startDate, endDate, subcontractor);
Session.Remove("subcontractorsInformationDummy");
subcontractorsInformation = (ProjectCostingSheetAddTDS.SubcontractorsInformationDataTable)model.Table;
Session["subcontractorsInformation"] = subcontractorsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdSubcontractors.DataBind();
StepSubcontractorsInformationProcessGrid();
}
break;
}
}
protected void grdMaterials_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Validate general data
Page.Validate("materialsEdit");
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("materialsCadEdit");
}
else
{
Page.Validate("materialsUsdEdit");
}
}
if (Page.IsValid)
{
int costingSheetId = (int)e.Keys["CostingSheetID"];
int materialId = (int)e.Keys["MaterialID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string unitOfMeasurement = ((DropDownList)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitOfMeasurementMaterialsEdit")).SelectedValue;
double quantity = double.Parse(((TextBox)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("tbxQuantityEdit")).Text.Trim());
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("tbxCostCADEdit")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("tbxCostUSDEdit")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
LFSLive.DA.Resources.Materials.MaterialsGateway m = new LiquiForce.LFSLive.DA.Resources.Materials.MaterialsGateway();
m.LoadByMaterialId(materialId, companyId);
string process = m.GetType(materialId);
string description = m.GetDescription(materialId);
DateTime startDate = ((RadDatePicker)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("tkrdpStartDateEdit")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdMaterials.Rows[e.RowIndex].Cells[0].FindControl("tkrdpEndDateEdit")).SelectedDate.Value;
string workFunctionConcat = "Full Length . Install";
string function_ = "Install";
// Update data
ProjectCostingSheetAddMaterialsInformation model = new ProjectCostingSheetAddMaterialsInformation(projectCostingSheetAddTDS);
model.Update(costingSheetId, materialId, refId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, false, companyId, process, description, startDate, endDate, function_, workFunctionConcat);
// Store tables
Session.Remove("materialsInformationDummy");
materialsInformation = (ProjectCostingSheetAddTDS.MaterialsInformationDataTable)model.Table;
Session["materialsInformation"] = materialsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
StepMaterialInformationProcessGrid();
}
else
{
e.Cancel = true;
}
}
protected void grdNavigator_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Normal rows
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(((Label)e.Row.FindControl("lblProjectID")).Text);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
((Label)e.Row.FindControl("lblRateUsd")).Text = ((Label)e.Row.FindControl("lblRateCad")).Text;
((Label)e.Row.FindControl("lblTotalUsd")).Text = ((Label)e.Row.FindControl("lblTotalCad")).Text;
}
else
{
((Label)e.Row.FindControl("lblRateCad")).Text = ((Label)e.Row.FindControl("lblRateUsd")).Text;
((Label)e.Row.FindControl("lblTotalCad")).Text = ((Label)e.Row.FindControl("lblTotalUsd")).Text;
//((Label)e.Row.FindControl("lblRateCad")).Visible = false;
//((Label)e.Row.FindControl("lblTotalCad")).Visible = false;
//((Label)e.Row.FindControl("lblRateUsd")).Visible = true;
//((Label)e.Row.FindControl("lblTotalUsd")).Visible = true;
}
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP6 - MATERIAL INFORMATION
//
// ////////////////////////////////////////////////////////////////////////
// STEP6 - MATERIAL INFORMATION - EVENTS
//
protected void grdMaterials_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Add":
// Materials Gridview, if the gridview is edition mode
if (grdMaterials.EditIndex >= 0)
{
grdMaterials.UpdateRow(grdMaterials.EditIndex, true);
}
// Validate general data
Page.Validate("materialsNew");
ProjectGateway projectGateway = new ProjectGateway();
int projectId = Int32.Parse(hdfProjectId.Value);
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("materialsCadNew");
}
else
{
Page.Validate("materialsUsdNew");
}
}
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
string description = ((DropDownList)grdMaterials.FooterRow.FindControl("ddlDescriptionNew")).SelectedItem.Text;
int materialId = Int32.Parse(((DropDownList)grdMaterials.FooterRow.FindControl("ddlDescriptionNew")).SelectedValue);
string unitOfMeasurement = ((DropDownList)grdMaterials.FooterRow.FindControl("ddlUnitOfMeasurementMaterialsNew")).SelectedValue;
double quantity = double.Parse(((TextBox)grdMaterials.FooterRow.FindControl("tbxQuantityNew")).Text.Trim());
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdMaterials.FooterRow.FindControl("tbxCostCADNew")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdMaterials.FooterRow.FindControl("tbxCostUSDNew")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
LFSLive.DA.Resources.Materials.MaterialsGateway m = new LiquiForce.LFSLive.DA.Resources.Materials.MaterialsGateway();
m.LoadByMaterialId(materialId, companyId);
string process = m.GetType(materialId);
DateTime startDate = ((RadDatePicker)grdMaterials.FooterRow.FindControl("tkrdpStartDateNew")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdMaterials.FooterRow.FindControl("tkrdpEndDateNew")).SelectedDate.Value;
string workFunctionConcat = "Full Length . Install";
string function_ = "Install";
ProjectCostingSheetAddMaterialsInformation model = new ProjectCostingSheetAddMaterialsInformation(projectCostingSheetAddTDS);
model.Insert(0, materialId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, false, companyId, process, description, startDate, endDate, function_, workFunctionConcat);
// Store tables
Session.Remove("materialsInformationDummy");
materialsInformation = (ProjectCostingSheetAddTDS.MaterialsInformationDataTable)model.Table;
Session["materialsInformation"] = materialsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdMaterials.DataBind();
StepMaterialInformationProcessGrid();
}
break;
}
}
protected void grdUnits_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Validate general data
Page.Validate("unitsEdit");
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
if (Page.IsValid)
{
// Validate costs
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
Page.Validate("unitsCadEdit");
}
else
{
Page.Validate("unitsUsdEdit");
}
}
if (Page.IsValid)
{
int costingSheetId = (int)e.Keys["CostingSheetID"];
string work_ = (string)e.Keys["Work_"];
int unitId = (int)e.Keys["UnitID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string unitOfMeasurement = ((DropDownList)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitOfMeasurementUnitsEdit")).SelectedValue;
double quantity = double.Parse(((TextBox)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("tbxQuantityEdit")).Text.Trim());
decimal costCad = 0.0M;
decimal totalCostCad = 0.0M;
decimal costUsd = 0.0M;
decimal totalCostUsd = 0.0M;
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
costCad = Decimal.Parse(((TextBox)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("tbxCostCADEdit")).Text.Trim());
totalCostCad = (costCad * decimal.Parse(quantity.ToString()));
totalCostCad = Decimal.Round(totalCostCad, 2);
}
else
{
costUsd = Decimal.Parse(((TextBox)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("tbxCostUSDEdit")).Text.Trim());
totalCostUsd = (costUsd * decimal.Parse(quantity.ToString()));
totalCostUsd = Decimal.Round(totalCostUsd, 2);
}
LFSLive.DA.FleetManagement.Units.UnitsGateway u = new LiquiForce.LFSLive.DA.FleetManagement.Units.UnitsGateway();
u.LoadByUnitId(unitId, companyId);
string unitDescription = u.GetDescription(unitId);
string unitCode = u.GetUnitCode(unitId);
DateTime startDate = ((RadDatePicker)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("tkrdpStartDateEdit")).SelectedDate.Value;
DateTime endDate = ((RadDatePicker)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("tkrdpEndDateEdit")).SelectedDate.Value;
string workFunctionConcat = "";
string function_ = "";
workFunctionConcat = ((DropDownList)grdUnits.Rows[e.RowIndex].Cells[0].FindControl("ddlWorkFunctionEdit")).SelectedValue;
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
function_ = workFunction[1].Trim();
}
// Update data
ProjectCostingSheetAddUnitsInformation model = new ProjectCostingSheetAddUnitsInformation(projectCostingSheetAddTDS);
model.Update(costingSheetId, work_, unitId, refId, unitOfMeasurement, quantity, costCad, totalCostCad, costUsd, totalCostUsd, false, companyId, unitCode, unitDescription, startDate, endDate, workFunctionConcat, function_);
// Store dataset
unitsInformation = (ProjectCostingSheetAddTDS.UnitsInformationDataTable)model.Table;
Session["unitsInformation"] = unitsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
StepTrucksEquipmentInformationProcessGrid();
}
else
{
e.Cancel = true;
}
}
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 GetRevenueSummary()
{
decimal grandTotalCad = Decimal.Round(decimal.Parse(tbxTeamMembersTotalCostCAD.Text) + decimal.Parse(tbxUnitsTotalCostsCAD.Text) + decimal.Parse(tbxMaterialsTotalCostsCAD.Text) + decimal.Parse(tbxOtherCostsTotalCostsCAD.Text) + decimal.Parse(tbxSubcontractorsTotalCostsCAD.Text) + decimal.Parse(tbxHotelsTotalCostsCAD.Text) + decimal.Parse(tbxBondingsTotalCostsCAD.Text) + decimal.Parse(tbxInsurancesTotalCostsCAD.Text) + decimal.Parse(tbxOtherCategoryTotalCostsCAD.Text), 2);
decimal grandTotalUsd = Decimal.Round(decimal.Parse(tbxTeamMembersTotalCostUSD.Text) + decimal.Parse(tbxUnitsTotalCostsUSD.Text) + decimal.Parse(tbxMaterialsTotalCostsUSD.Text) + decimal.Parse(tbxOtherCostsTotalCostsUSD.Text) + decimal.Parse(tbxSubcontractorsTotalCostsUSD.Text) + decimal.Parse(tbxHotelsTotalCostsCAD.Text) + decimal.Parse(tbxBondingsTotalCostsCAD.Text) + decimal.Parse(tbxInsurancesTotalCostsCAD.Text) + decimal.Parse(tbxOtherCategoryTotalCostsCAD.Text), 2);
decimal grandTotal = 0.0M;
decimal grandRevenue = decimal.Round(decimal.Parse(tbxRevenueTotal.Text),2);
decimal grandProfit = 0.0M;
decimal grandGrossMargin = 0.0M;
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
lblGrandTotal.Text = "Grand Total (CAD)";
grandTotal = grandTotalCad;
}
else
{
lblGrandTotal.Text = "Grand Total (USD)";
grandTotal = grandTotalUsd;
}
grandProfit = grandRevenue - grandTotal;
if (grandRevenue > 0)
{
grandGrossMargin = (grandProfit / grandRevenue) * 100;
}
else
{
grandGrossMargin = 0;
}
tbxGrandTotal.Text = grandTotal.ToString();
tbxGradRevenue.Text = tbxRevenueTotal.Text;
tbxGrandProfit.Text = grandProfit.ToString();
tbxGrandGrossMargin.Text = decimal.Round(grandGrossMargin, 2).ToString();
}
/// <summary>
/// GetSummary.
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments separeted with the enterString</returns>
/// <param name="option">option</param>
public string GetSummary(int companyId, string enterString, string option)
{
string summary = "" + enterString;
if (option == "BySubcontractor")
{
foreach (ActualCostsAddTDS.SubcontractorCostsRow row in (ActualCostsAddTDS.SubcontractorCostsDataTable)Table)
{
if (!row.Deleted)
{
summary = summary + "Date: " + row.Date.Month.ToString() + "/" + row.Date.Day.ToString() + "/" + row.Date.Year.ToString() + enterString;
summary = summary + "Client: " + row.Client + enterString;
summary = summary + "Project: " + row.Project + enterString;
summary = summary + "Quantity: " + row.Quantity + enterString;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(row.ProjectID);
if (projectGateway.GetCountryID(row.ProjectID) == 1) //Canada
{
summary = summary + "Rate: " + row.Rate + " CAD" + enterString;
summary = summary + "Total: " + row.TotalCad + " CAD" + enterString;
}
else
{
summary = summary + "Rate: " + row.Rate + " USD" + enterString;
summary = summary + "Total: " + row.TotalUsd + " CAD" + enterString;
}
if (!row.IsCommentNull())
{
summary = summary + "Comment: " + row.Comment + enterString + enterString;
}
else
{
summary = summary + "Comment: " + enterString + enterString; ;
}
}
}
}
else
{
if (option == "ByClientProject")
{
foreach (ActualCostsAddTDS.SubcontractorCostsRow row in (ActualCostsAddTDS.SubcontractorCostsDataTable)Table)
{
if (!row.Deleted)
{
summary = summary + "Date: " + row.Date.Month.ToString() + "/" + row.Date.Day.ToString() + "/" + row.Date.Year.ToString() + enterString;
summary = summary + "Subcontractor: " + row.Name + enterString;
summary = summary + "Quantity: " + row.Quantity + enterString;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(row.ProjectID);
if (projectGateway.GetCountryID(row.ProjectID) == 1) //Canada
{
summary = summary + "Rate: " + row.Rate + " CAD" + enterString;
summary = summary + "Total: " + row.TotalCad + " CAD" + enterString;
}
else
{
summary = summary + "Rate: " + row.Rate + " USD" + enterString;
summary = summary + "Total: " + row.TotalUsd + " CAD" + enterString;
}
if (!row.IsCommentNull())
{
summary = summary + "Comment: " + row.Comment + enterString + enterString;
}
else
{
summary = summary + "Comment: " + enterString + enterString;
}
}
}
}
}
return (summary);
}
// ////////////////////////////////////////////////////////////////////////
// STEP4 - LABOUR HOUR INFORMATION - METHODS
//
private void StepLabourHourInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please verify Labour Hour information";
// Load
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectCostingSheetAddTDS.LabourHoursInformation.Rows.Count <= 0)
{
ArrayList works = new ArrayList();
if (cbxRehabAssessmentData.Checked) works.Add("Rehab Assessment");
if (cbxFullLengthLiningData.Checked) works.Add("Full Length");
if (cbxPointRepairData.Checked) { works.Add("Point Lining"); works.Add("Grouting"); }
if (cbxJunctionLiningData.Checked) works.Add("Junction Lining");
if (cbxManholeRehabData.Checked) works.Add("MH Rehab");
if (cbxMobilizationData.Checked) works.Add("Mobilization");
if (cbxOtherData.Checked)
{
works.Add("Other");
works.Add("Downtime");
works.Add("Office");
works.Add("Office / Shop");
works.Add("R & D");
works.Add("Special Projects");
works.Add("Subcontractor");
works.Add("Watermain Relining");
works.Add("SOTA");
}
if (!projectGateway.GetFairWageApplies(projectId))
{
model.Load(works, projectId, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), "");
}
else
{
ArrayList jobClassType = new ArrayList();
jobClassType.Add("Laborer Group 2");
jobClassType.Add("Laborer Group 6");
jobClassType.Add("Operator Group 1");
jobClassType.Add("Operator Group 2");
jobClassType.Add("Regular Rate");
model.LoadFairWageProject(works, jobClassType, projectId, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), "");
}
}
// Store tables
Session.Remove("labourHoursInformationDummy");
labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table;
Session["labourHoursInformation"] = labourHoursInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdTeamMembers.Columns[10].Visible = false;
grdTeamMembers.Columns[11].Visible = false;
grdTeamMembers.Columns[12].Visible = false;
grdTeamMembers.Columns[13].Visible = false;
grdTeamMembers.Columns[15].Visible = false;
grdTeamMembers.Columns[16].Visible = false;
grdTeamMembers.Columns[19].Visible = false;
grdTeamMembers.Columns[20].Visible = false;
// Validate grid columns
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Team Members Grid
grdTeamMembers.Columns[14].Visible = true;
grdTeamMembers.Columns[17].Visible = true;
grdTeamMembers.Columns[18].Visible = false;
grdTeamMembers.Columns[21].Visible = false;
// Totals
lblTeamMembersTotalCost.Text = "Total Cost (CAD) : ";
tbxTeamMembersTotalCostCAD.Visible = true;
tbxTeamMembersTotalCostUSD.Visible = false;
}
else
{
if (projectGateway.GetCountryID(projectId) == 2) //USA
{
// Team Members Grid
grdTeamMembers.Columns[14].Visible = false;
grdTeamMembers.Columns[17].Visible = false;
grdTeamMembers.Columns[18].Visible = true;
grdTeamMembers.Columns[21].Visible = true;
// Totals
lblTeamMembersTotalCost.Text = "Total Cost (USD) : ";
tbxTeamMembersTotalCostCAD.Visible = false;
tbxTeamMembersTotalCostUSD.Visible = true;
}
}
grdTeamMembers.DataBind();
StepLabourHoursInformationProcessGrid();
}
private void UpdateDataForNavigator()
{
foreach (SubcontractorHoursNavigatorTDS.SubcontractorHoursNavigatorRow row in (SubcontractorHoursNavigatorTDS.SubcontractorHoursNavigatorDataTable)Table)
{
int projectId = row.ProjectID;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
row.RateUsd = row.RateCad;
row.TotalUsd = row.TotalCad;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP6 - MATERIAL INFORMATION - METHODS
//
private void StepMaterialInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please verify Material information";
// Load
ProjectCostingSheetAddMaterialsInformation model = new ProjectCostingSheetAddMaterialsInformation(projectCostingSheetAddTDS);
if (projectCostingSheetAddTDS.MaterialsInformation.Rows.Count <= 0)
{
ArrayList works = new ArrayList();
if (cbxFullLengthLiningData.Checked) works.Add("Full Length Lining");
if (cbxManholeRehabData.Checked) works.Add("Manhole Rehab");
if (cbxPointRepairData.Checked) works.Add("Point Repairs");
if (cbxJunctionLiningData.Checked) works.Add("Junction Lining");
model.Load(works, int.Parse(hdfProjectId.Value), tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value));
}
// Store tables
Session.Remove("materialsInformationDummy");
materialsInformation = (ProjectCostingSheetAddTDS.MaterialsInformationDataTable)model.Table;
Session["materialsInformation"] = materialsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
// Validate grid columns
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Materials grid
grdMaterials.Columns[9].Visible = true;
grdMaterials.Columns[10].Visible = true;
grdMaterials.Columns[11].Visible = false;
grdMaterials.Columns[12].Visible = false;
lblMaterialsTotalCosts.Text = "Total Cost (CAD) : ";
tbxMaterialsTotalCostsCAD.Visible = true;
tbxMaterialsTotalCostsUSD.Visible = false;
}
else
{
// Materials grid
grdMaterials.Columns[9].Visible = false;
grdMaterials.Columns[10].Visible = false;
grdMaterials.Columns[11].Visible = true;
grdMaterials.Columns[12].Visible = true;
lblMaterialsTotalCosts.Text = "Total Cost (USD) : ";
tbxMaterialsTotalCostsCAD.Visible = false;
tbxMaterialsTotalCostsUSD.Visible = true;
}
grdMaterials.DataBind();
StepMaterialInformationProcessGrid();
}
private void UpdateDatabase()
{
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
Int64 countryId = projectGateway.GetCountryID(projectId);
Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId);
Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId);
Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId);
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int sectionAssetId = Int32.Parse(hdfAssetId.Value);
bool isNewMeasuredFromDsmh = false;
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, sectionAssetId, companyId, projectId);
if (flLateralDetails.Table.Rows.Count == 0)
{
if (ddlM1DataMeasuredFromMh.SelectedValue == "DSMH")
{
isNewMeasuredFromDsmh = true;
FullLengthLiningLateralDetails fllLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fllLateralDetails.ModifyLateralId();
}
}
DB.Open();
DB.BeginTransaction();
try
{
// Save lateral details
// Save lateral details
bool roboticPrepCompleted = ckbxPrepDataRoboticPrepCompleted.Checked;
DateTime? roboticPrepCompletedCompleted = null; if (tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.HasValue) roboticPrepCompletedCompleted = tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.Value;
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.Save(workId, projectId, sectionAssetId, countryId, provinceId, countyId, cityId, tbxVideoLength.Text.Trim(), companyId, isNewMeasuredFromDsmh, roboticPrepCompleted, roboticPrepCompletedCompleted);
// Save catalyst details
string newRunDetails = "";
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
newRunDetails = newRunDetails + lst.Value + ">";
}
}
newRunDetails = newRunDetails.Substring(0, newRunDetails.Length - 1);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.Save(companyId, newRunDetails, projectId);
// Save section details
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId);
// Save work details
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, sectionAssetId, companyId, ckbxWetOutDataIncludeWetOutInformation.Checked, ckbxInversionDataIncludeInversionInformation.Checked);
// Save material details
string newMaterial = ddlM1DataMaterial.SelectedValue;
if (ddlM1DataMaterial.SelectedIndex > 0)
{
LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null);
if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(sectionAssetId, newMaterial, companyId))
{
MaterialInformation materialInformation = new MaterialInformation(materialInformationTDS);
materialInformation.Save(companyId);
}
}
DB.CommitTransaction();
// Store datasets
fullLengthLiningTDS.AcceptChanges();
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
materialInformationTDS.AcceptChanges();
Session["materialInformationTDS"] = materialInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP8 - OTHER COST INFORMATION - METHODS
//
private void StepOtherCostInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please provide other costs to cost sheet";
// Load
ProjectCostingSheetAddOtherCostsInformation model = new ProjectCostingSheetAddOtherCostsInformation(projectCostingSheetAddTDS);
// Store tables
Session.Remove("otherCostsInformationDummy");
otherCostsInformation = (ProjectCostingSheetAddTDS.OtherCostsInformationDataTable)model.Table;
Session["otherCostsInformation"] = otherCostsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
// Validate grid columns
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Other costs
grdOtherCosts.Columns[8].Visible = true;
grdOtherCosts.Columns[9].Visible = true;
grdOtherCosts.Columns[10].Visible = false;
grdOtherCosts.Columns[11].Visible = false;
lblOtherCostsTotalCosts.Text = "Total Cost (CAD) : ";
tbxOtherCostsTotalCostsCAD.Visible = true;
tbxOtherCostsTotalCostsUSD.Visible = false;
}
else
{
// Other costs
grdOtherCosts.Columns[8].Visible = false;
grdOtherCosts.Columns[9].Visible = false;
grdOtherCosts.Columns[10].Visible = true;
grdOtherCosts.Columns[11].Visible = true;
lblOtherCostsTotalCosts.Text = "Total Cost (USD) : ";
tbxOtherCostsTotalCostsCAD.Visible = false;
tbxOtherCostsTotalCostsUSD.Visible = true;
}
grdOtherCosts.DataBind();
StepOtherCostsInformationProcessGrid();
}
private void LoadGeneralData()
{
// ... for geographical location
hdfCountryId.DataBind();
if (hdfCountryId.Value != "")
{
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(Int64.Parse(hdfCountryId.Value));
tbxCountry.Text = countryGateway.GetName(Int64.Parse(hdfCountryId.Value));
}
else
{
tbxCountry.Text = "";
}
hdfProvinceStateId.DataBind();
if (hdfProvinceStateId.Value != "")
{
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(Int64.Parse(hdfProvinceStateId.Value));
tbxProvinceState.Text = provinceGateway.GetName(Int64.Parse(hdfProvinceStateId.Value));
}
else
{
tbxProvinceState.Text = "";
}
hdfCountyId.DataBind();
if (hdfCountyId.Value != "")
{
CountyGateway countyGateway = new CountyGateway();
countyGateway.LoadByCountyId(Int64.Parse(hdfCountyId.Value));
tbxCounty.Text = countyGateway.GetName(Int64.Parse(hdfCountyId.Value));
}
else
{
tbxCounty.Text = "";
}
hdfCityId.DataBind();
if (hdfCityId.Value != "")
{
CityGateway cityGateway = new CityGateway();
cityGateway.LoadByCityId(Int64.Parse(hdfCityId.Value));
tbxCity.Text = cityGateway.GetName(Int64.Parse(hdfCityId.Value));
}
else
{
tbxCity.Text = "";
}
// ... for project
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
int currentCompanyId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString()));
hdfClientId.Value = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value)).ToString();
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(currentCompanyId, companyId);
if (projectTDS.LFS_PROJECT.Rows.Count > 0)
{
tkrdpStartDate.DataBind();
tkrdpEndDate.DataBind();
tkrdpProposalDate.DataBind();
tbxProjectNumber.DataBind();
tbxName.DataBind();
tbxDescription.DataBind();
tbxClientName.Text = companiesGateway.GetName(projectGateway.GetClientID(int.Parse(hdfProjectId.Value)));
tbxClientProjectNumber.DataBind();
// ... ... for primary contact
ContactsList contactList = new ContactsList();
contactList.LoadAllAndAddItemByCompaniesId(-1, " ", projectGateway.GetClientID(int.Parse(hdfProjectId.Value)), companyId);
ddlClientPrimaryContactId.DataSource = contactList.Table;
ddlClientPrimaryContactId.DataValueField = "CONTACTS_ID";
ddlClientPrimaryContactId.DataTextField = "Name";
if (projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
ddlClientPrimaryContactId.SelectedValue = projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).ToString();
}
else
{
ddlClientPrimaryContactId.SelectedValue = "-1";
}
ddlClientPrimaryContactId.DataBind();
// ... ... for secondary contact
ddlClientSecondaryContactId.DataSource = contactList.Table;
ddlClientSecondaryContactId.DataValueField = "CONTACTS_ID";
ddlClientSecondaryContactId.DataTextField = "Name";
if (projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
ddlClientSecondaryContactId.SelectedValue = projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).ToString();
}
else
{
ddlClientSecondaryContactId.SelectedValue = "-1";
}
ddlClientSecondaryContactId.DataBind();
// ... for resources
// ... ... for project lead
EmployeeList employeeList = new EmployeeList();
employeeList.LoadAndAddItem(-1, " ");
ddlProjectLeadId.DataSource = employeeList.Table;
ddlProjectLeadId.DataValueField = "EmployeeID";
ddlProjectLeadId.DataTextField = "FullName";
ddlProjectLeadId.SelectedValue = (projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)).HasValue) ? ((int)projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value))).ToString() : "-1";
ddlProjectLeadId.DataBind();
// ... ... for salesman
SalesmanListGateway salesmanListGateway = new SalesmanListGateway(new DataSet());
salesmanListGateway.Load();
ddlSalesmanId.DataSource = salesmanListGateway.Table;
ddlSalesmanId.DataValueField = "SalesmanID";
ddlSalesmanId.DataTextField = "FullName";
ddlSalesmanId.SelectedValue = ((int)projectGateway.GetSalesmanID(int.Parse(hdfProjectId.Value))).ToString();
ddlSalesmanId.DataBind();
// ... ... for Pricing
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Ballpark")
{
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS);
if (projectSaleBillingPricingGateway.Table.Rows.Count > 0)
{
tbxBillPrice.DataBind();
ddlBillMoney.DataBind();
}
else
{
if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1)
{
ddlBillMoney.SelectedValue = "CAD";
}
else
{
ddlBillMoney.SelectedValue = "USD";
}
}
}
}
cbxFairWageApplies.DataBind();
// Data for unit budget tab
ProjectNavigatorProjectUnitsBudgetGateway projectNavigatorProjectUnitsBudgetGateway = new ProjectNavigatorProjectUnitsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectUnitsBudgetGateway.Table.Rows.Count > 0)
{
tbxUnitsBudget.Text = projectNavigatorProjectUnitsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2");
}
// Data for materials budget tab
ProjectNavigatorProjectMaterialsBudgetGateway projectNavigatorProjectMaterialsBudgetGateway = new ProjectNavigatorProjectMaterialsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectMaterialsBudgetGateway.Table.Rows.Count > 0)
{
tbxMaterialsBudget.Text = projectNavigatorProjectMaterialsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2");
}
// Data for subcontractors budget tab
ProjectNavigatorProjectSubcontractorsBudgetGateway projectNavigatorProjectSubcontractorsBudgetGateway = new ProjectNavigatorProjectSubcontractorsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectSubcontractorsBudgetGateway.Table.Rows.Count > 0)
{
tbxSubcontractorsBudget.Text = projectNavigatorProjectSubcontractorsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for hotels budget tab
ProjectNavigatorProjectHotelsBudgetGateway projectNavigatorProjectHotelsBudgetGateway = new ProjectNavigatorProjectHotelsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectHotelsBudgetGateway.Table.Rows.Count > 0)
{
tbxHotelsBudget.Text = projectNavigatorProjectHotelsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for bondings budget tab
ProjectNavigatorProjectBondingsBudgetGateway projectNavigatorProjectBondingsBudgetGateway = new ProjectNavigatorProjectBondingsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectBondingsBudgetGateway.Table.Rows.Count > 0)
{
tbxBondingsBudget.Text = projectNavigatorProjectBondingsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for insurances budget tab
ProjectNavigatorProjectInsurancesBudgetGateway projectNavigatorProjectInsurancesBudgetGateway = new ProjectNavigatorProjectInsurancesBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectInsurancesBudgetGateway.Table.Rows.Count > 0)
{
tbxInsurancesBudget.Text = projectNavigatorProjectInsurancesBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
CalculateTotalBudget();
}
// ////////////////////////////////////////////////////////////////////////
// STEP7 - SUBCONTRACTOR INFORMATION - METHODS
//
private void StepSubcontractorsInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please verify Subcontractors information";
// Load
ProjectCostingSheetAddSubcontractorsInformation model = new ProjectCostingSheetAddSubcontractorsInformation(projectCostingSheetAddTDS);
if (projectCostingSheetAddTDS.SubcontractorsInformation.Rows.Count <= 0)
{
model.Load(int.Parse(hdfProjectId.Value), tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value));
}
// Store tables
Session.Remove("subcontractorsInformationDummy");
subcontractorsInformation = (ProjectCostingSheetAddTDS.SubcontractorsInformationDataTable)model.Table;
Session["subcontractorsInformation"] = subcontractorsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
// Validate grid columns
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Subcontractors Grid
grdSubcontractors.Columns[8].Visible = true;
grdSubcontractors.Columns[9].Visible = true;
grdSubcontractors.Columns[10].Visible = false;
grdSubcontractors.Columns[11].Visible = false;
lblSubcontractorsTotalCosts.Text = "Total Cost (CAD) : ";
tbxSubcontractorsTotalCostsCAD.Visible = true;
tbxSubcontractorsTotalCostsUSD.Visible = false;
}
else
{
// Subcontractors Grid
grdSubcontractors.Columns[8].Visible = false;
grdSubcontractors.Columns[9].Visible = false;
grdSubcontractors.Columns[10].Visible = true;
grdSubcontractors.Columns[11].Visible = true;
lblSubcontractorsTotalCosts.Text = "Total Cost (USD) : ";
tbxSubcontractorsTotalCostsCAD.Visible = false;
tbxSubcontractorsTotalCostsUSD.Visible = true;
}
grdSubcontractors.DataBind();
StepSubcontractorsInformationProcessGrid();
}
private void PostPageChanges()
{
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
int projectId = int.Parse(hdfProjectId.Value);
// General Data
Int64 countryId = projectGateway.GetCountryID(projectId);
int officeId = projectGateway.GetOfficeID(projectId);
Int64? provinceId = projectGateway.GetProvinceID(projectId);
Int64? cityId = projectGateway.GetCityID(projectId);
Int64? countyId = projectGateway.GetCountyID(projectId);
int? projectLeadId = null; if ((ddlProjectLeadId.SelectedValue != "-1") && (ddlProjectLeadId.SelectedIndex > -1)) projectLeadId = int.Parse(ddlProjectLeadId.SelectedValue);
int salesmanId = int.Parse(ddlSalesmanId.SelectedValue);
string projectType = projectGateway.GetProjectType(projectId);
string projectState = projectGateway.GetProjectState(projectId);
string name = tbxName.Text.Trim();
string description = tbxDescription.Text.Trim();
DateTime? proposalDate = null; if (tkrdpProposalDate.SelectedDate.HasValue) proposalDate = tkrdpProposalDate.SelectedDate.Value;
DateTime? startDate = null; if (tkrdpStartDate.SelectedDate.HasValue) startDate = tkrdpStartDate.SelectedDate.Value;
DateTime? endDate = null; if (tkrdpEndDate.SelectedDate.HasValue) endDate = tkrdpEndDate.SelectedDate.Value;
int clientId = projectGateway.GetClientID(projectId);
string clientProjectNumber = tbxClientProjectNumber.Text.Trim();
int? clientPrimaryContactId = null; if ((ddlClientPrimaryContactId.SelectedValue != "-1") && (ddlClientPrimaryContactId.SelectedIndex > -1)) clientPrimaryContactId = int.Parse(ddlClientPrimaryContactId.SelectedValue);
int? clientSecondaryContactId = null; if ((ddlClientSecondaryContactId.SelectedValue != "-1") && (ddlClientSecondaryContactId.SelectedIndex > -1)) clientSecondaryContactId = int.Parse(ddlClientSecondaryContactId.SelectedValue);
bool deleted = projectGateway.GetDeleted(projectId);
int? libraryCategoriesId = null; if (projectGateway.GetLibraryCategoriesId(projectId).HasValue) libraryCategoriesId = (int)projectGateway.GetLibraryCategoriesId(projectId);
bool fairWageApplies = cbxFairWageApplies.Checked;
// ... Update Project Number
Project project = new Project(projectTDS);
string projectNumber;
if (projectGateway.GetOriginalProjectID(projectId) == null)
{
projectNumber = project.UpdateProjectNumber(projectId, salesmanId);
}
else
{
projectNumber = projectGateway.GetProjectNumber(projectId);
}
// ... Update Project
project.Update(projectId, countryId, officeId, projectLeadId, salesmanId, projectNumber, projectType, projectState, name, description, proposalDate, startDate, endDate, clientId, clientProjectNumber, clientPrimaryContactId, clientSecondaryContactId, deleted, libraryCategoriesId, provinceId, cityId, Int32.Parse(hdfCompanyId.Value.Trim()), countyId, fairWageApplies);
// ... If project type is Ballpark update Bill Price and Bill Money
if (projectType == "Ballpark")
{
ProjectSaleBillingPricing projectSaleBillingPricingForGeneralData = new ProjectSaleBillingPricing(projectTDS);
decimal? billPrice = null; if (tbxBillPrice.Text != "") billPrice = Convert.ToDecimal(tbxBillPrice.Text);
string billMoney = ddlBillMoney.SelectedValue;
projectSaleBillingPricingForGeneralData.UpdateBillPrice(projectId, billPrice, billMoney);
}
if ((projectType != "Ballpark") && (projectType != "Internal"))
{
// Sale/Billing/Pricing
//bool saleBidProject = cbxSaleBidProject.Checked;
//bool saleRFP = cbxSaleRFP.Checked;
//bool saleSoleSource = cbxSaleSoleSource.Checked;
//bool saleTermContract = cbxSaleTermContract.Checked;
//string saleTermContractDetail = tbxSaleTermContractDetail.Text.Trim();
//bool saleOther = cbxSaleOther.Checked;
//string saleOtherDetail = tbxSaleOtherDetail.Text.Trim();
//int? saleGettingJob = null; if (tbxSaleGettingJob.Text.Trim() != "") saleGettingJob = int.Parse(tbxSaleGettingJob.Text.Trim());
decimal? billPriceSaleBillingPricing = null; if (tbxBillPriceSaleBillingPricing.Text.Trim() != "") billPriceSaleBillingPricing = decimal.Parse(tbxBillPriceSaleBillingPricing.Text.Trim());
string billMoneySaleBillingPricing = ddlBillMoneySaleBillingPricing.SelectedValue;
decimal? billSubcontractorAmount = null; if (tbxBillSubcontractorAmount.Text.Trim() != "") billSubcontractorAmount = decimal.Parse(tbxBillSubcontractorAmount.Text.Trim());
//string billBidHardDollar = tbxBillBidHardDollar.Text.Trim();
//bool billPerUnit = cbxBillPerUnit.Checked;
//bool billHourly = cbxBillHourly.Checked;
//string billExpectExtras = tbxBillExpectExtras.Text.Trim();
//bool chargesWater = cbxChargesWater.Checked;
//decimal? chargesWaterAmount = null; if (tbxChargesWaterAmount.Text.Trim() != "") chargesWaterAmount = decimal.Parse(tbxChargesWaterAmount.Text.Trim());
//bool chargesDisposal = cbxChargesDisposal.Checked;
//decimal? chargesDisposalAmount = null; if (tbxChargesDisposalAmount.Text.Trim() != "") chargesDisposalAmount = decimal.Parse(tbxChargesDisposalAmount.Text.Trim());
// ... Update Sale/Billing/Pricing
ProjectSaleBillingPricing projectSaleBillingPricing = new ProjectSaleBillingPricing(projectTDS);
//projectSaleBillingPricing.Update(projectId, saleBidProject, saleRFP, saleSoleSource, saleTermContract, saleTermContractDetail, saleOther, saleOtherDetail, saleGettingJob, billPriceSaleBillingPricing, billMoneySaleBillingPricing, billBidHardDollar, billPerUnit, billHourly, billExpectExtras, billSubcontractorAmount, chargesWater, chargesWaterAmount, chargesDisposal, chargesDisposalAmount, Int32.Parse(hdfCompanyId.Value.Trim()));
projectSaleBillingPricing.Update(projectId, billPriceSaleBillingPricing, billMoneySaleBillingPricing, billSubcontractorAmount, Int32.Parse(hdfCompanyId.Value.Trim()));
// ... Update job info
bool typeOfWorkMhRehab = ckbxMhRehab.Checked;
bool typeOfWorkJunctionLining = ckbxJunctionLining.Checked;
bool typeOfWorkProjectManagement = ckbxProjectManagement.Checked;
bool typeOfWorkFullLenghtLining = ckbxFullLengthLining.Checked;
bool typeOfWorkPointRepairs = ckbxPointRepairs.Checked;
bool typeOfWorkRehabAssessment = ckbxRehabAssessment.Checked;
bool typeOfWorkGrout = ckbxGrout.Checked;
bool typeOfWorkOther = ckbxOther.Checked;
bool agreement = cbxSubcontractorAgreement.Checked;
bool writtenQuote = cbxSubcontractorWrittenQuote.Checked;
string role = tbxSubcontractorRole.Text;
ProjectNavigatorProjectJobInfo projectNavigatorProjectJobInfo = new ProjectNavigatorProjectJobInfo(projectNavigatorTDS);
projectNavigatorProjectJobInfo.Update(projectId, typeOfWorkMhRehab, typeOfWorkJunctionLining, typeOfWorkProjectManagement, typeOfWorkFullLenghtLining, typeOfWorkPointRepairs, typeOfWorkRehabAssessment, typeOfWorkGrout, typeOfWorkOther, agreement, writtenQuote, role);
// Costing Updates
//decimal? extrasToDate = null; if (tbxExtrasToDate.Text.Trim() != "") extrasToDate = decimal.Parse(tbxExtrasToDate.Text.Trim());
//decimal? costsIncurred = null; if (tbxCostsIncurred.Text.Trim() != "") costsIncurred = decimal.Parse(tbxCostsIncurred.Text.Trim());
//decimal? costToComplete = null; if (tbxCostToComplete.Text.Trim() != "") costToComplete = decimal.Parse(tbxCostToComplete.Text.Trim());
//decimal? originalProfitEstimated = null; if (tbxOriginalProfitEstimated.Text.Trim() != "") originalProfitEstimated = decimal.Parse(tbxOriginalProfitEstimated.Text.Trim());
//decimal? invoicedToDate = null; if (tbxInvoicedToDate.Text.Trim() != "") invoicedToDate = decimal.Parse(tbxInvoicedToDate.Text.Trim());
// ... Update Costing Updates
//ProjectCostingUpdates projectCostingUpdates = new ProjectCostingUpdates(projectTDS);
//projectCostingUpdates.Update(projectId, extrasToDate, costsIncurred, costToComplete, originalProfitEstimated, invoicedToDate, Int32.Parse(hdfCompanyId.Value.Trim()));
// Terms/PO
// ... Liquidated Damage
//bool liquidateDamage = cbxLiquidatedDamages.Checked;
//decimal? liquidatedRate = null;
//if (tbxLiquidatedDamagesRate.Text.Trim() != "") { decimal damages = Decimal.Parse(tbxLiquidatedDamagesRate.Text.Trim()); liquidatedRate = Decimal.Round(damages, 2); }
//string liquidatedUnit = null; if (tbxLiquidatedDamagesUnit.Text != "") liquidatedUnit = tbxLiquidatedDamagesUnit.Text.Trim();
//// ... Client LFS Relationship
//bool clientWorkedBefore = cbxWorkedBefore.Checked;
//string clientQuirks = null; if (tbxClientQuirks.Text.Trim() != "") clientQuirks = tbxClientQuirks.Text.Trim();
//bool clientPromises = cbxClientPromises.Checked;
//string clientPromisesNotes = null; if (tbxClientPromises.Text.Trim() != "") clientPromisesNotes = tbxClientPromises.Text.Trim();
//string waterObtain = null; if (tbxWaterObtain.Text.Trim() != "") waterObtain = tbxWaterObtain.Text.Trim();
//string materialDispose = null; if (tbxMaterialDispose.Text.Trim() != "") materialDispose = tbxMaterialDispose.Text.Trim();
//bool requireRPZ = cbxRequireRPZ.Checked;
//string standardHydrantFitting = null; if (tbxStandardHydrantFitting.Text.Trim() != "") standardHydrantFitting = tbxStandardHydrantFitting.Text.Trim();
//bool preconstructionMeeting = cbxPreConstructionMeetingNeed.Checked;
//bool specificMeetingLocation = cbxSpecificMeetingLocation.Checked;
//string specificMeetingLocationNotes = null; if (tbxSpecificMeetingLocation.Text.Trim() != "") specificMeetingLocationNotes = tbxSpecificMeetingLocation.Text.Trim();
//string vehicleAccess = null; if (ddlVehicleAccess.Text.Trim() != "") vehicleAccess = ddlVehicleAccess.Text.Trim();
//string vehicleAccessNotes = null; if (tbxVehicleAccess.Text.Trim() != "") vehicleAccessNotes = tbxVehicleAccess.Text.Trim();
string projectOutcome = null; if (tbxDesireOutcomeOfProject.Text.Trim() != "") projectOutcome = tbxDesireOutcomeOfProject.Text.Trim();
string specificReportingNeeds = null; if (tbxSpecificReportingNeeds.Text.Trim() != "") specificReportingNeeds = tbxSpecificReportingNeeds.Text.Trim();
bool vehicleAccessRoad = ckbxVehicleAccessRoad.Checked;
bool vehicleAccessEasement = ckbxVehicleAccessEasement.Checked;
bool vehicleAccessOther = ckbxVehicleAccessOther.Checked;
//... Purchase Order
//bool orderAttached = cbxPurchaseOrderAttach.Checked;
string orderNumber = null; if (tbxPurchaseOrderNumber.Text.Trim() != "") orderNumber = tbxPurchaseOrderNumber.Text.Trim();
//string orderNotes = null; if (tbxPurchaseOrderWillNotProvided.Text.Trim() != "") orderNotes = tbxPurchaseOrderWillNotProvided.Text.Trim();
// ... Update Term/PO
ProjectTermsPO projectTermsPO = new ProjectTermsPO(projectTDS);
//projectTermsPO.Update(projectId, liquidateDamage, liquidatedRate, liquidatedUnit, clientWorkedBefore, clientQuirks, clientPromises, clientPromisesNotes, waterObtain, materialDispose, requireRPZ, standardHydrantFitting, preconstructionMeeting, specificMeetingLocation, specificMeetingLocationNotes, vehicleAccess, vehicleAccessNotes, projectOutcome, specificReportingNeeds, orderNumber, orderAttached, orderNotes, Int32.Parse(hdfCompanyId.Value.Trim()));
projectTermsPO.Update(projectId, projectOutcome, specificReportingNeeds, orderNumber, Int32.Parse(hdfCompanyId.Value.Trim()), vehicleAccessRoad, vehicleAccessEasement, vehicleAccessOther);
// Technical
bool availableDrawings = cbxAvailableDrawings.Checked;
bool availableVideo = cbxAvailableVideo.Checked;
//bool groundConditions = cbxGroundConditions.Checked;
//string groundConditionNotes = null; if (tbxGroundCondition.Text != "") groundConditionNotes = tbxGroundCondition.Text.Trim();
//bool reviewVideoInspections = cbxReviewVideoInspections.Checked;
//bool strangeConfigurations = cbxStrangeConfigurations.Checked;
//string strangeConfigurationsNotes = null; if (tbxStrangeConfigurations.Text != "") strangeConfigurationsNotes = tbxStrangeConfigurations.Text.Trim();
//string furtherObservations = null; if (tbxFurtherObservations.Text != "") furtherObservations = tbxFurtherObservations.Text.Trim();
//string restrictiveFactors = null; if (tbxRestrictiveFactors.Text != "") restrictiveFactors = tbxRestrictiveFactors.Text.Trim();
// ... Update Technical
ProjectTechnical projectTechnical = new ProjectTechnical(projectTDS);
//projectTechnical.Update(projectId, availableDrawings, availableVideo, groundConditions, groundConditionNotes, reviewVideoInspections, strangeConfigurations, strangeConfigurationsNotes, furtherObservations, restrictiveFactors, Int32.Parse(hdfCompanyId.Value.Trim()));
projectTechnical.Update(projectId, availableDrawings, availableVideo, Int32.Parse(hdfCompanyId.Value.Trim()));
// Engineer/Subcontractors
bool generalContractor = cbxGeneralContractor.Checked;
bool generalWSIB = cbxGeneralWSIB.Checked;
bool generalInsuranceCertificate = cbxGeneralInsuranceCertificate.Checked;
string generalBondingSupplied = ddlGeneralBondingSupplied.SelectedValue;
//string generalMOLForm = ddlGeneralMOLForm.SelectedValue;
//bool generalNoticeProject = rbtnGeneralNoticeProject.Checked;
//bool generalForm1000 = rbtnGeneralForm1000.Checked;
//int? engineeringFirmId = null; if (ddlEngineeringFirmId.SelectedValue != "") engineeringFirmId = int.Parse(ddlEngineeringFirmId.SelectedValue);
//int? engineerId = null; if (ddlEngineerId.SelectedValue != "") engineerId = int.Parse(ddlEngineerId.SelectedValue);
//string engineerNumber = tbxEngineerNumber.Text.Trim();
bool subcontractorUsed = cbxSubcontractorUsed.Checked;
string bondNumber = tbxBondNumber.Text.Trim();
// ... Update Engineer/Subcontractors
ProjectEngineerSubcontractors projectEngineerSubcontractors = new ProjectEngineerSubcontractors(projectTDS);
//projectEngineerSubcontractors.Update(projectId, generalContractor, generalWSIB, generalInsuranceCertificate, generalBondingSupplied, generalMOLForm, generalNoticeProject, generalForm1000, engineeringFirmId, engineerId, engineerNumber, subcontractorUsed, Int32.Parse(hdfCompanyId.Value.Trim()), bondNumber);
projectEngineerSubcontractors.Update(projectId, generalContractor, generalWSIB, generalInsuranceCertificate, generalBondingSupplied, subcontractorUsed, Int32.Parse(hdfCompanyId.Value.Trim()), bondNumber);
// ... Update subcontractors
//ProjectSubcontractor projectSubcontractor = new ProjectSubcontractor(projectTDS);
//bool subcontractorWrittenQuote = ((CheckBox)row.FindControl("cbxSubcontractorWrittenQuote")).Checked;
//bool subcontractorAgreement = ((CheckBox)row.FindControl("cbxSubcontractorAgreement")).Checked;
////foreach (GridViewRow row in grdvSubcontractors.Rows)
//{
// int subcontractorRefId = int.Parse(((HiddenField)row.FindControl("hdfRefId")).Value);
// int subcontractorId = int.Parse(((DropDownList)row.FindControl("ddlSubcontractorId")).SelectedValue);
// bool subcontractorSurveyedSite = ((CheckBox)row.FindControl("cbxSubcontractorSurveyedSite")).Checked;
// bool subcontractorWorkedBefore = ((CheckBox)row.FindControl("cbxSubcontractorWorkedBefore")).Checked;
// string subcontractorRole = ((TextBox)row.FindControl("tbxSubcontractorRole")).Text.Trim();
// string subcontractorIssues = ((TextBox)row.FindControl("tbxSubcontractorIssues")).Text.Trim();
// bool subcontractorPurchaseOrder = ((CheckBox)row.FindControl("cbxSubcontractorPurchaseOrder")).Checked;
// bool subcontractorInsuranceCertificate = ((CheckBox)row.FindControl("cbxSubcontractorInsuranceCertificate")).Checked;
// bool subcontractorWSIB = ((CheckBox)row.FindControl("cbxSubcontractorWSIB")).Checked;
// string subcontractorMOLForm1000 = ((DropDownList)row.FindControl("ddlSubcontractorMolForm1000")).SelectedValue;
// int? royalties = null;
// if (((TextBox)row.FindControl("tbxRoyalties")).Text != "")
// {
// royalties = Int32.Parse(((TextBox)row.FindControl("tbxRoyalties")).Text);
// }
//projectSubcontractor.Update(projectId, subcontractorRefId, subcontractorId, subcontractorWrittenQuote, subcontractorSurveyedSite, subcontractorWorkedBefore, subcontractorRole, subcontractorAgreement, subcontractorIssues, subcontractorPurchaseOrder, subcontractorInsuranceCertificate, subcontractorWSIB, subcontractorMOLForm1000, false, Int32.Parse(hdfCompanyId.Value.Trim()), royalties);
//projectSubcontractor.Update(projectId, 1, subcontractorWrittenQuote, subcontractorAgreement, Int32.Parse(hdfCompanyId.Value.Trim()));
//}
decimal unitsBudget = 0M; if (tbxUnitsBudget.Text.Trim() != "") unitsBudget = decimal.Parse(tbxUnitsBudget.Text);
decimal materialsBudget = 0M; if (tbxMaterialsBudget.Text.Trim() != "") materialsBudget = decimal.Parse(tbxMaterialsBudget.Text);
decimal subcontractorsBudget = 0M; if (tbxSubcontractorsBudget.Text.Trim() != "") subcontractorsBudget = decimal.Parse(tbxSubcontractorsBudget.Text);
decimal hotelsBudget = 0M; if (tbxHotelsBudget.Text.Trim() != "") hotelsBudget = decimal.Parse(tbxHotelsBudget.Text);
decimal bondingsBudget = 0M; if (tbxBondingsBudget.Text.Trim() != "") bondingsBudget = decimal.Parse(tbxBondingsBudget.Text);
decimal insurancesBudget = 0M; if (tbxInsurancesBudget.Text.Trim() != "") insurancesBudget = decimal.Parse(tbxInsurancesBudget.Text);
ProjectNavigatorProjectUnitsBudget projectNavigatorProjectUnitsBudget = new ProjectNavigatorProjectUnitsBudget(projectNavigatorTDS);
if (projectNavigatorProjectUnitsBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectUnitsBudget.Update(projectId, unitsBudget);
}
else
{
projectNavigatorProjectUnitsBudget.Insert(projectId, unitsBudget, false, Int32.Parse(hdfCompanyId.Value), false);
}
ProjectNavigatorProjectMaterialsBudget projectNavigatorProjectMaterialsBudget = new ProjectNavigatorProjectMaterialsBudget(projectNavigatorTDS);
if (projectNavigatorProjectMaterialsBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectMaterialsBudget.Update(projectId, materialsBudget);
}
else
{
projectNavigatorProjectMaterialsBudget.Insert(projectId, materialsBudget, false, Int32.Parse(hdfCompanyId.Value), false);
}
ProjectNavigatorProjectSubcontractorsBudget projectNavigatorProjectSubcontractorsBudget = new ProjectNavigatorProjectSubcontractorsBudget(projectNavigatorTDS);
if (projectNavigatorProjectSubcontractorsBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectSubcontractorsBudget.Update(projectId, 1, 1, subcontractorsBudget, false, Int32.Parse(hdfCompanyId.Value));
}
else
{
projectNavigatorProjectSubcontractorsBudget.Insert(projectId, 1, subcontractorsBudget, false, Int32.Parse(hdfCompanyId.Value), false, "");
}
ProjectNavigatorProjectHotelsBudget projectNavigatorProjectHotelsBudget = new ProjectNavigatorProjectHotelsBudget(projectNavigatorTDS);
if (projectNavigatorProjectHotelsBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectHotelsBudget.Update(projectId, 1, 1, hotelsBudget, false, Int32.Parse(hdfCompanyId.Value));
}
else
{
projectNavigatorProjectHotelsBudget.Insert(projectId, 1, hotelsBudget, false, Int32.Parse(hdfCompanyId.Value), false, "");
}
ProjectNavigatorProjectBondingsBudget projectNavigatorProjectBondingsBudget = new ProjectNavigatorProjectBondingsBudget(projectNavigatorTDS);
if (projectNavigatorProjectBondingsBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectBondingsBudget.Update(projectId, 1, 1, bondingsBudget, false, Int32.Parse(hdfCompanyId.Value));
}
else
{
projectNavigatorProjectBondingsBudget.Insert(projectId, 1, bondingsBudget, false, Int32.Parse(hdfCompanyId.Value), false, "");
}
ProjectNavigatorProjectInsurancesBudget projectNavigatorProjectInsurancesBudget = new ProjectNavigatorProjectInsurancesBudget(projectNavigatorTDS);
if (projectNavigatorProjectInsurancesBudget.Table.Rows.Count > 0)
{
projectNavigatorProjectInsurancesBudget.Update(projectId, 1, 1, insurancesBudget, false, Int32.Parse(hdfCompanyId.Value));
}
else
{
projectNavigatorProjectInsurancesBudget.Insert(projectId, 1, insurancesBudget, false, Int32.Parse(hdfCompanyId.Value), false, "");
}
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP5 - TRUCKS EQUIPMENT INFORMATION - METHODS
//
private void StepTrucksEquipmentInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please verify Truck / Equipment information";
// Load
ProjectCostingSheetAddUnitsInformation model = new ProjectCostingSheetAddUnitsInformation(projectCostingSheetAddTDS);
if (projectCostingSheetAddTDS.UnitsInformation.Rows.Count <= 0)
{
ArrayList works = new ArrayList();
if (cbxRehabAssessmentData.Checked) works.Add("Rehab Assessment");
if (cbxFullLengthLiningData.Checked) works.Add("Full Length");
if (cbxPointRepairData.Checked) { works.Add("Point Lining"); works.Add("Grouting"); }
if (cbxJunctionLiningData.Checked) works.Add("Junction Lining");
if (cbxManholeRehabData.Checked) works.Add("MH Rehab");
if (cbxMobilizationData.Checked) works.Add("Mobilization");
if (cbxOtherData.Checked)
{
works.Add("Other");
works.Add("Downtime");
works.Add("Office");
works.Add("Office / Shop");
works.Add("R & D");
works.Add("Special Projects");
works.Add("Subcontractor");
works.Add("Watermain Relining");
works.Add("SOTA");
}
model.Load(works, int.Parse(hdfProjectId.Value), tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value));
}
// Store tables
Session.Remove("unitsInformationDummy");
unitsInformation = (ProjectCostingSheetAddTDS.UnitsInformationDataTable)model.Table;
Session["unitsInformation"] = unitsInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
// Validate grid columns
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Units Grid
grdUnits.Columns[11].Visible = true;
grdUnits.Columns[12].Visible = true;
grdUnits.Columns[13].Visible = false;
grdUnits.Columns[14].Visible = false;
lblUnitsTotalCosts.Text = "Total Cost (CAD) : ";
tbxUnitsTotalCostsCAD.Visible = true;
tbxUnitsTotalCostsUSD.Visible = false;
}
else
{
// Units Grid
grdUnits.Columns[11].Visible = false;
grdUnits.Columns[12].Visible = false;
grdUnits.Columns[13].Visible = true;
grdUnits.Columns[14].Visible = true;
lblUnitsTotalCosts.Text = "Total Cost (USD) : ";
tbxUnitsTotalCostsCAD.Visible = false;
tbxUnitsTotalCostsUSD.Visible = true;
}
grdUnits.DataBind();
StepTrucksEquipmentInformationProcessGrid();
}
private void TagPage()
{
hdfWorkType.Value = Request.QueryString["work_type"].ToString();
hdfCompanyId.Value = Session["companyID"].ToString();
hdfProjectId.Value = Request.QueryString["project_id"].ToString();
// Get ids & location
int projectId = Int32.Parse(hdfProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
// ... Get ids
Int64 currentCountry = projectGateway.GetCountryID(projectId);
Int64? currentProvince = null; if (projectGateway.GetProvinceID(projectId).HasValue) currentProvince = (Int64)projectGateway.GetProvinceID(projectId);
Int64? currentCounty = null; if (projectGateway.GetCountyID(projectId).HasValue) currentCounty = (Int64)projectGateway.GetCountyID(projectId);
Int64? currentCity = null; if (projectGateway.GetCityID(projectId).HasValue) currentCity = (Int64)projectGateway.GetCityID(projectId);
hdfCountryId.Value = currentCountry.ToString();
hdfProvinceId.Value = currentProvince.ToString();
hdfCountyId.Value = currentCounty.ToString();
hdfCityId.Value = currentCity.ToString();
// .. Get location
string projectLocation = "";
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(currentCountry);
projectLocation = projectLocation + countryGateway.GetName(currentCountry);
if (currentProvince.HasValue)
{
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId((Int64)currentProvince);
projectLocation = projectLocation + ", " + provinceGateway.GetName((Int64)currentProvince);
}
if (currentCounty.HasValue)
{
CountyGateway countyGateway = new CountyGateway();
countyGateway.LoadByCountyId((Int64)currentCounty);
projectLocation = projectLocation + ", " + countyGateway.GetName((Int64)currentCounty);
}
if (currentCity.HasValue)
{
CityGateway cityGateway = new CityGateway();
cityGateway.LoadByCityId((Int64)currentCity);
projectLocation = projectLocation + ", " + cityGateway.GetName((Int64)currentCity);
}
hdfSearchTitle.Value = projectLocation;
}
private void TagPage()
{
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfWorkType.Value = "Manhole Rehabilitation";
hdfAssetId.Value = Request.QueryString["asset_id"].ToString();
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfInProject.Value = Request.QueryString["in_project"].ToString();
hdfExistBatchId.Value = "False";
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.Table.Rows.Count > 0)
{
// ... Get ids
Int64 currentCountry = projectGateway.GetCountryID(projectId);
Int64? currentProvince = null; if (projectGateway.GetProvinceID(projectId).HasValue) currentProvince = (Int64)projectGateway.GetProvinceID(projectId);
Int64? currentCounty = null; if (projectGateway.GetCountyID(projectId).HasValue) currentCounty = (Int64)projectGateway.GetCountyID(projectId);
Int64? currentCity = null; if (projectGateway.GetCityID(projectId).HasValue) currentCity = (Int64)projectGateway.GetCityID(projectId);
hdfCountryId.Value = currentCountry.ToString();
hdfProvinceId.Value = currentProvince.ToString();
hdfCountyId.Value = currentCounty.ToString();
hdfCityId.Value = currentCity.ToString();
}
else
{
hdfCountryId.Value = "";
hdfProvinceId.Value = "";
hdfCountyId.Value = "";
hdfCityId.Value = "";
}
// Get workId
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
string workType = hdfWorkType.Value;
WorkGateway workGateway = new WorkGateway();
hdfWorkId.Value = "0";
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, workType, companyId);
if (workGateway.Table.Rows.Count > 0)
{
hdfWorkId.Value = workGateway.GetWorkId(assetId, workType, projectId).ToString();
}
}