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