// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAndAddItem
/// </summary>
/// <param name="name">name</param>
/// <param name="abbreviation">abbreviation</param>
/// <param name="companyId">companyId</param>
/// <returns>Data</returns>
public DataSet LoadAndAddItem(string name, string abbreviation, int companyId)
{
// Add item
CreateTableStructure();
Insert(name, abbreviation);
// Load Co Pit Location list
WorkJunctionLiningCoPitLocationListGateway workJunctionLiningCoPitLocationListGateway = new WorkJunctionLiningCoPitLocationListGateway(Data);
workJunctionLiningCoPitLocationListGateway.ClearBeforeFill = false;
workJunctionLiningCoPitLocationListGateway.Load(companyId);
workJunctionLiningCoPitLocationListGateway.ClearBeforeFill = true;
return Data;
}
// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// UpdateForProcess
/// </summary>
/// <param name="companyId">companyId</param>
private void UpdateForReport(int companyId)
{
WorkJunctionLiningCoPitLocationListGateway workJunctionLiningCoPitLocationListGateway = new WorkJunctionLiningCoPitLocationListGateway();
foreach (JlOverviewReportTDS.JlOverviewRow row in (JlOverviewReportTDS.JlOverviewDataTable)Table)
{
if (!row.IsCoPitLocationNull())
{
row.Abbreviation = workJunctionLiningCoPitLocationListGateway.GetAbbreviation(row.CoPitLocation, companyId);
}
if (!row.IsCommentsNull())
{
row.Comments = row.Comments.Replace("<br>", "\n");
}
int workIdFll = GetWorkId(row.ProjectID, row.AssetID, "Full Length Lining", companyId);
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, row.AssetID, companyId);
if (fullLengthLiningWorkDetailsGateway.Table.Rows.Count > 0)
{
string measurementFromMH = "USMH"; if (fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll) != "") measurementFromMH = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll);
if (measurementFromMH == "DSMH")
{
string auxDistanceFromUSMH = row.DistanceFromUSMH;
row.DistanceFromUSMH = row.DistanceFromDSMH;
row.DistanceFromDSMH = auxDistanceFromUSMH;
}
}
}
}