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