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 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()));
}
}