private void LoadData(int projectId, int refId) { // Load Data SubcontractorHoursInformationBasicInformationGateway subcontractorHoursInformationBasicInformationGateway = new SubcontractorHoursInformationBasicInformationGateway(subcontractorHoursInformationTDS); if (subcontractorHoursInformationBasicInformationGateway.Table.Rows.Count > 0) { // Load subcontractor basic data tbxSubcontractor.Text = subcontractorHoursInformationBasicInformationGateway.GetSubcontractor(projectId, refId); if (subcontractorHoursInformationBasicInformationGateway.GetActive(projectId, refId)) { tbxState.Text = "Active"; } else { tbxState.Text = "Inactive"; } tbxClient.Text = subcontractorHoursInformationBasicInformationGateway.GetClient(projectId, refId); tbxProject.Text = subcontractorHoursInformationBasicInformationGateway.GetProject(projectId, refId); hdfClientId.Value = subcontractorHoursInformationBasicInformationGateway.GetClientID(projectId, refId).ToString(); tkrdpDate_.SelectedDate = (DateTime)(subcontractorHoursInformationBasicInformationGateway.GetDate(projectId, refId)); decimal quantity = decimal.Parse(subcontractorHoursInformationBasicInformationGateway.GetQuantity(projectId, refId).ToString()); tbxQuantity.Text = decimal.Round(quantity,1).ToString(); if (subcontractorHoursInformationBasicInformationGateway.GetCountryId(projectId, refId) == 1) // Canada { decimal rate = decimal.Parse(subcontractorHoursInformationBasicInformationGateway.GetRateCad(projectId, refId).ToString()); tbxRate.Text = decimal.Round(rate,2).ToString(); decimal total = decimal.Parse(subcontractorHoursInformationBasicInformationGateway.GetTotalCad(projectId, refId).ToString()); tbxTotal.Text = decimal.Round(total,2).ToString(); } else // Usa { decimal rate = decimal.Parse(subcontractorHoursInformationBasicInformationGateway.GetRateUsd(projectId, refId).ToString()); tbxRate.Text = decimal.Round(rate, 2).ToString(); decimal total = decimal.Parse(subcontractorHoursInformationBasicInformationGateway.GetTotalUsd(projectId, refId).ToString()); tbxTotal.Text = decimal.Round(total, 2).ToString(); } hdfCountryId.Value = subcontractorHoursInformationBasicInformationGateway.GetCountryId(projectId, refId).ToString(); tbxComments.Text = subcontractorHoursInformationBasicInformationGateway.GetComment(projectId, refId); } }