// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAllByProjectId
/// </summary>
/// <param name="projectId">projectId</param>
public void LoadAllByProjectId(int projectId)
{
ProjectServiceGateway projectServiceGateway = new ProjectServiceGateway(Data);
projectServiceGateway.LoadAllByProjectId(projectId);
foreach (ProjectTDS.LFS_PROJECT_SERVICERow lfsProjectServiceRow in (ProjectTDS.LFS_PROJECT_SERVICEDataTable)Table)
{
if (lfsProjectServiceRow.IsNull("AveragePrice"))
{
lfsProjectServiceRow.Total = 0;
}
else
{
lfsProjectServiceRow.Total = lfsProjectServiceRow.AveragePrice * lfsProjectServiceRow.Quantity;
}
}
Table.AcceptChanges();
}
private void InsertProjectService(int originalProjectId)
{
// ... Data for current project
ProjectTDS projectTDSTemp = new ProjectTDS();
ProjectServiceGateway projectServiceGatewayTemp = new ProjectServiceGateway(projectTDSTemp);
projectServiceGatewayTemp.LoadAllByProjectId(originalProjectId);
ProjectServiceGateway projectServiceGateway = new ProjectServiceGateway(projectTDS);
projectServiceGateway.LoadAllByProjectId(originalProjectId);
// ... Definition of general variables
int refId;
int? serviceId = null;
string description;
string averageSize;
decimal? averagePrice = null;
int quantity;
bool deleted;
decimal total;
foreach (ProjectTDS.LFS_PROJECT_SERVICERow row in projectTDSTemp.Tables["LFS_PROJECT_SERVICE"].Rows)
{
refId = row.RefID;
try { serviceId = row.ServiceID; }
catch { serviceId = null; }
try { description = row.Description; }
catch { description = ""; }
try { averageSize = row.AverageSize; }
catch { averageSize = ""; }
try { averagePrice = row.AveragePrice; }
catch { averagePrice = null; }
quantity = row.Quantity;
deleted = row.Deleted;
try { total = row.AveragePrice * row.Quantity; }
catch { total = 0; }
// ... Insert Service
ProjectService projectService = new ProjectService(projectTDS);
projectService.Insert(0, refId, serviceId, description, averageSize, averagePrice, quantity, deleted, total, Int32.Parse(hdfCompanyId.Value.Trim()));
}
}