private void InsertProjectSaleBillingPricing(int originalProjectId) { // ... Data for current project ProjectTDS projectTDSTemp = new ProjectTDS(); ProjectSaleBillingPricingGateway projectSaleBillingPricingGatewayTemp = new ProjectSaleBillingPricingGateway(projectTDSTemp); projectSaleBillingPricingGatewayTemp.LoadAllByProjectId(originalProjectId); ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS); projectSaleBillingPricingGateway.LoadAllByProjectId(originalProjectId); if (projectSaleBillingPricingGateway.Table.Rows.Count > 0) { // ... Definition of general variables bool saleBidProject = projectSaleBillingPricingGateway.GetSaleBidProject(originalProjectId); bool saleRFP = projectSaleBillingPricingGateway.GetSaleRFP(originalProjectId); bool saleSoleSource = projectSaleBillingPricingGateway.GetSaleSoleSource(originalProjectId); bool saleTermContract = projectSaleBillingPricingGateway.GetSaleTermContract(originalProjectId); string saleTermContractDetail = projectSaleBillingPricingGateway.GetSaleTermContractDetail(originalProjectId); bool saleOther = projectSaleBillingPricingGateway.GetSaleOther(originalProjectId); string saleOtherDetail = projectSaleBillingPricingGateway.GetSaleOtherDetail(originalProjectId); int? saleGettingJob = null; if (projectSaleBillingPricingGateway.GetSaleGettingJob(originalProjectId).HasValue) saleGettingJob = (int)projectSaleBillingPricingGateway.GetSaleGettingJob(originalProjectId); decimal? billPrice = null; if (projectSaleBillingPricingGateway.GetBillPrice(originalProjectId).HasValue) billPrice = (decimal)projectSaleBillingPricingGateway.GetBillPrice(originalProjectId); string billMoney = projectSaleBillingPricingGateway.GetBillMoney(originalProjectId); decimal? billSubcontractorAmount = null; if (projectSaleBillingPricingGateway.GetBillSubcontractorAmount(originalProjectId).HasValue) billSubcontractorAmount = (decimal)projectSaleBillingPricingGateway.GetBillSubcontractorAmount(originalProjectId); string billBidHardDollar = projectSaleBillingPricingGateway.GetBillBidHardDollar(originalProjectId); bool billPerUnit = projectSaleBillingPricingGateway.GetBillPerUnit(originalProjectId); bool billHourly = projectSaleBillingPricingGateway.GetBillHourly(originalProjectId); string billExpectExtras = projectSaleBillingPricingGateway.GetBillExpectExtras(originalProjectId); bool chargesWater = projectSaleBillingPricingGateway.GetChargesWater(originalProjectId); decimal? chargesWaterAmount = null; if (projectSaleBillingPricingGateway.GetChargesWaterAmount(originalProjectId).HasValue) chargesWaterAmount = (decimal)projectSaleBillingPricingGateway.GetChargesWaterAmount(originalProjectId); bool chargesDisposal = projectSaleBillingPricingGateway.GetChargesDisposal(originalProjectId); decimal? chargesDisposalAmount = null; if (projectSaleBillingPricingGateway.GetChargesDisposalAmount(originalProjectId).HasValue) chargesDisposalAmount = (decimal)projectSaleBillingPricingGateway.GetChargesDisposalAmount(originalProjectId); // ... Insert Sale/Billing/Pricing ProjectSaleBillingPricing projectSaleBillingPricing = new ProjectSaleBillingPricing(projectTDS); projectSaleBillingPricing.Insert(0, saleBidProject, saleRFP, saleSoleSource, saleTermContract, saleTermContractDetail, saleOther, saleOtherDetail, saleGettingJob, billPrice, billMoney, billBidHardDollar, billPerUnit, billHourly, billExpectExtras, billSubcontractorAmount, chargesWater, chargesWaterAmount, chargesDisposal, chargesDisposalAmount, Int32.Parse(hdfCompanyId.Value.Trim())); } }
private void LoadSaleBillingPricing() { // Data for Sale/Billing/Pricing tab ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS); if (projectSaleBillingPricingGateway.Table.Rows.Count > 0) { //cbxSaleBidProject.Checked = projectSaleBillingPricingGateway.GetSaleBidProject(int.Parse(hdfProjectId.Value)); //cbxSaleRFP.Checked = projectSaleBillingPricingGateway.GetSaleRFP(int.Parse(hdfProjectId.Value)); //cbxSaleSoleSource.Checked = projectSaleBillingPricingGateway.GetSaleSoleSource(int.Parse(hdfProjectId.Value)); //cbxSaleTermContract.Checked = projectSaleBillingPricingGateway.GetSaleTermContract(int.Parse(hdfProjectId.Value)); //tbxSaleTermContractDetail.Text = projectSaleBillingPricingGateway.GetSaleTermContractDetail(int.Parse(hdfProjectId.Value)); //cbxSaleOther.Checked = projectSaleBillingPricingGateway.GetSaleOther(int.Parse(hdfProjectId.Value)); //tbxSaleOtherDetail.Text = projectSaleBillingPricingGateway.GetSaleOtherDetail(int.Parse(hdfProjectId.Value)); //if (projectSaleBillingPricingGateway.GetSaleGettingJob(int.Parse(hdfProjectId.Value)).HasValue) tbxSaleGettingJob.Text = ((int)projectSaleBillingPricingGateway.GetSaleGettingJob(int.Parse(hdfProjectId.Value))).ToString(); if (projectSaleBillingPricingGateway.GetBillPrice(int.Parse(hdfProjectId.Value)).HasValue) tbxBillPriceSaleBillingPricing.Text = ((decimal)projectSaleBillingPricingGateway.GetBillPrice(int.Parse(hdfProjectId.Value))).ToString("n2"); tbxBillMoneySaleBillingPricing.Text = projectSaleBillingPricingGateway.GetBillMoney(int.Parse(hdfProjectId.Value)); if (projectSaleBillingPricingGateway.GetBillSubcontractorAmount(int.Parse(hdfProjectId.Value)).HasValue) tbxBillSubcontractorAmount.Text = ((decimal)projectSaleBillingPricingGateway.GetBillSubcontractorAmount(int.Parse(hdfProjectId.Value))).ToString("n2"); //tbxBillBidHardDollar.Text = projectSaleBillingPricingGateway.GetBillBidHardDollar(int.Parse(hdfProjectId.Value)); //cbxBillPerUnit.Checked = projectSaleBillingPricingGateway.GetBillPerUnit(int.Parse(hdfProjectId.Value)); //cbxBillHourly.Checked = projectSaleBillingPricingGateway.GetBillHourly(int.Parse(hdfProjectId.Value)); //tbxBillExpectExtras.Text = projectSaleBillingPricingGateway.GetBillExpectExtras(int.Parse(hdfProjectId.Value)); //cbxChargesWater.Checked = projectSaleBillingPricingGateway.GetChargesWater(int.Parse(hdfProjectId.Value)); //if (projectSaleBillingPricingGateway.GetChargesWaterAmount(int.Parse(hdfProjectId.Value)).HasValue) tbxChargesWaterAmount.Text = ((decimal)projectSaleBillingPricingGateway.GetChargesWaterAmount(int.Parse(hdfProjectId.Value))).ToString("n2"); //cbxChargesDisposal.Checked = projectSaleBillingPricingGateway.GetChargesDisposal(int.Parse(hdfProjectId.Value)); //if (projectSaleBillingPricingGateway.GetChargesDisposalAmount(int.Parse(hdfProjectId.Value)).HasValue) tbxChargesDisposalAmount.Text = ((decimal)projectSaleBillingPricingGateway.GetChargesDisposalAmount(int.Parse(hdfProjectId.Value))).ToString("n2"); } else { // ... for project ProjectGateway projectGateway = new ProjectGateway(projectTDS); if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1) { tbxBillMoneySaleBillingPricing.Text = "CAD"; } else { tbxBillMoneySaleBillingPricing.Text = "USD"; } } // Databind Grid for Services //grdServices.DataBind(); }