// //////////////////////////////////////////////////////////////////////// // PRIVATE METHODS // /// <summary> /// UpdateForReport /// </summary> /// <param name="unitType">unitType</param> private void UpdateForReport(string unitType) { // Load comments foreach (FlM1ReportTDS.M1ReportByClientRow row in (FlM1ReportTDS.M1ReportByClientDataTable)Table) { WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(row.WorkID, row.COMPANY_ID); row.M1Comments = workGateway.GetComments(row.WorkID); } // Update for unit type FlM1LateralReportGateway flM1LateralReportGateway = new FlM1LateralReportGateway(Data); flM1LateralReportGateway.ClearBeforeFill = false; FlM1LateralReport flM1LateralReport = new FlM1LateralReport(Data); foreach (FlM1ReportTDS.M1ReportByClientRow row in (FlM1ReportTDS.M1ReportByClientDataTable)Table) { if (!row.IsM1CommentsNull()) { row.M1Comments = row.M1Comments.Replace("<br>", "\n"); } Distance d; if (unitType == "Metric") { if (!row.IsSize_Null()) { if (Distance.IsValidDistance(row.Size_)) { d = new Distance(row.Size_); row.Size_ = d.ToStringInMil2(); } } if (!row.IsLengthNull()) { if (Distance.IsValidDistance(row.Length)) { d = new Distance(row.Length); row.Length = d.ToStringInMet2(); } } if (!row.IsUSMHDepthNull()) { if (Distance.IsValidDistance(row.USMHDepth)) { d = new Distance(row.USMHDepth); row.USMHDepth = d.ToStringInMet2(); } } if (!row.IsDSMHDepthNull()) { if (Distance.IsValidDistance(row.DSMHDepth)) { d = new Distance(row.DSMHDepth); row.DSMHDepth = d.ToStringInMet2(); } } if (!row.IsUSMHMouth12Null()) { if (Distance.IsValidDistance(row.USMHMouth12)) { d = new Distance(row.USMHMouth12); row.USMHMouth12 = d.ToStringInMil2(); } } if (!row.IsUSMHMouth1Null()) { if (Distance.IsValidDistance(row.USMHMouth1)) { d = new Distance(row.USMHMouth1); row.USMHMouth1 = d.ToStringInMil2(); } } if (!row.IsUSMHMouth2Null()) { if (Distance.IsValidDistance(row.USMHMouth2)) { d = new Distance(row.USMHMouth2); row.USMHMouth2 = d.ToStringInMil2(); } } if (!row.IsUSMHMouth3Null()) { if (Distance.IsValidDistance(row.USMHMouth3)) { d = new Distance(row.USMHMouth3); row.USMHMouth3 = d.ToStringInMil2(); } } if (!row.IsUSMHMouth4Null()) { if (Distance.IsValidDistance(row.USMHMouth4)) { d = new Distance(row.USMHMouth4); row.USMHMouth4 = d.ToStringInMil2(); } } if (!row.IsUSMHMouth5Null()) { if (Distance.IsValidDistance(row.USMHMouth5)) { d = new Distance(row.USMHMouth5); row.USMHMouth5 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth12Null()) { if (Distance.IsValidDistance(row.DSMHMouth12)) { d = new Distance(row.DSMHMouth12); row.DSMHMouth12 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth1Null()) { if (Distance.IsValidDistance(row.DSMHMouth1)) { d = new Distance(row.DSMHMouth1); row.DSMHMouth1 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth2Null()) { if (Distance.IsValidDistance(row.DSMHMouth2)) { d = new Distance(row.DSMHMouth2); row.DSMHMouth2 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth3Null()) { if (Distance.IsValidDistance(row.DSMHMouth3)) { d = new Distance(row.DSMHMouth3); row.DSMHMouth3 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth4Null()) { if (Distance.IsValidDistance(row.DSMHMouth4)) { d = new Distance(row.DSMHMouth4); row.DSMHMouth4 = d.ToStringInMil2(); } } if (!row.IsDSMHMouth5Null()) { if (Distance.IsValidDistance(row.DSMHMouth5)) { d = new Distance(row.DSMHMouth5); row.DSMHMouth5 = d.ToStringInMil2(); } } } if (unitType == "Imperial") { if (!row.IsSize_Null()) { if (Distance.IsValidDistance(row.Size_)) { Distance distance = new Distance(row.Size_); switch (distance.DistanceType) { case 2: row.Size_ = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.Size_) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.Size_) * 0.03937; row.Size_ = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.Size_ = row.Size_ + "\""; } } catch { } break; case 4: row.Size_ = distance.ToStringInEng1(); break; case 5: row.Size_ = distance.ToStringInEng1(); break; } } } if (!row.IsLengthNull()) { d = new Distance(row.Length); row.Length = d.ToStringInEng1(); } if (!row.IsUSMHDepthNull()) { if (Distance.IsValidDistance(row.USMHDepth)) { Distance distance = new Distance(row.USMHDepth); switch (distance.DistanceType) { case 2: row.USMHDepth = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.Size_) > 99) { double newUSMHDepth = 0; newUSMHDepth = Convert.ToDouble(row.Size_) * 0.03937; row.USMHDepth = Convert.ToString(Math.Ceiling(newUSMHDepth)) + "\""; } else { row.USMHDepth = row.USMHDepth + "\""; } } catch { } break; case 4: row.USMHDepth = distance.ToStringInEng1(); break; case 5: row.USMHDepth = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHDepthNull()) { if (Distance.IsValidDistance(row.DSMHDepth)) { Distance distance = new Distance(row.DSMHDepth); switch (distance.DistanceType) { case 2: row.DSMHDepth = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.Size_) > 99) { double newDSMHDepth = 0; newDSMHDepth = Convert.ToDouble(row.Size_) * 0.03937; row.DSMHDepth = Convert.ToString(Math.Ceiling(newDSMHDepth)) + "\""; } else { row.DSMHDepth = row.USMHDepth + "\""; } } catch { } break; case 4: row.DSMHDepth = distance.ToStringInEng1(); break; case 5: row.DSMHDepth = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth12Null()) { if (Distance.IsValidDistance(row.USMHMouth12)) { Distance distance = new Distance(row.USMHMouth12); switch (distance.DistanceType) { case 2: row.USMHMouth12 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth12) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth12) * 0.03937; row.USMHMouth12 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth12 = row.USMHMouth12 + "\""; } } catch { } break; case 4: row.USMHMouth12 = distance.ToStringInEng1(); break; case 5: row.USMHMouth12 = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth1Null()) { if (Distance.IsValidDistance(row.USMHMouth1)) { Distance distance = new Distance(row.USMHMouth1); switch (distance.DistanceType) { case 2: row.USMHMouth1 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth1) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth1) * 0.03937; row.USMHMouth1 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth1 = row.USMHMouth1 + "\""; } } catch { } break; case 4: row.USMHMouth1 = distance.ToStringInEng1(); break; case 5: row.USMHMouth1 = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth2Null()) { if (Distance.IsValidDistance(row.USMHMouth2)) { Distance distance = new Distance(row.USMHMouth2); switch (distance.DistanceType) { case 2: row.USMHMouth2 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth2) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth2) * 0.03937; row.USMHMouth2 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth2 = row.USMHMouth2 + "\""; } } catch { } break; case 4: row.USMHMouth2 = distance.ToStringInEng1(); break; case 5: row.USMHMouth2 = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth3Null()) { if (Distance.IsValidDistance(row.USMHMouth3)) { Distance distance = new Distance(row.USMHMouth3); switch (distance.DistanceType) { case 2: row.USMHMouth3 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth3) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth3) * 0.03937; row.USMHMouth3 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth3 = row.USMHMouth3 + "\""; } } catch { } break; case 4: row.USMHMouth3 = distance.ToStringInEng1(); break; case 5: row.USMHMouth3 = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth4Null()) { if (Distance.IsValidDistance(row.USMHMouth4)) { Distance distance = new Distance(row.USMHMouth4); switch (distance.DistanceType) { case 2: row.USMHMouth4 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth4) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth4) * 0.03937; row.USMHMouth4 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth4 = row.USMHMouth4 + "\""; } } catch { } break; case 4: row.USMHMouth4 = distance.ToStringInEng1(); break; case 5: row.USMHMouth4 = distance.ToStringInEng1(); break; } } } if (!row.IsUSMHMouth5Null()) { if (Distance.IsValidDistance(row.USMHMouth5)) { Distance distance = new Distance(row.USMHMouth5); switch (distance.DistanceType) { case 2: row.USMHMouth5 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.USMHMouth5) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.USMHMouth5) * 0.03937; row.USMHMouth5 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.USMHMouth5 = row.USMHMouth5 + "\""; } } catch { } break; case 4: row.USMHMouth5 = distance.ToStringInEng1(); break; case 5: row.USMHMouth5 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth12Null()) { if (Distance.IsValidDistance(row.DSMHMouth12)) { Distance distance = new Distance(row.DSMHMouth12); switch (distance.DistanceType) { case 2: row.DSMHMouth12 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth12) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth12) * 0.03937; row.DSMHMouth12 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth12 = row.DSMHMouth12 + "\""; } } catch { } break; case 4: row.DSMHMouth12 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth12 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth1Null()) { if (Distance.IsValidDistance(row.DSMHMouth1)) { Distance distance = new Distance(row.DSMHMouth1); switch (distance.DistanceType) { case 2: row.DSMHMouth1 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth1) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth1) * 0.03937; row.DSMHMouth1 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth1 = row.DSMHMouth1 + "\""; } } catch { } break; case 4: row.DSMHMouth1 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth1 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth2Null()) { if (Distance.IsValidDistance(row.DSMHMouth2)) { Distance distance = new Distance(row.DSMHMouth2); switch (distance.DistanceType) { case 2: row.DSMHMouth2 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth2) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth2) * 0.03937; row.DSMHMouth2 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth2 = row.DSMHMouth2 + "\""; } } catch { } break; case 4: row.DSMHMouth2 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth2 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth3Null()) { if (Distance.IsValidDistance(row.DSMHMouth3)) { Distance distance = new Distance(row.DSMHMouth3); switch (distance.DistanceType) { case 2: row.DSMHMouth3 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth3) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth3) * 0.03937; row.DSMHMouth3 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth3 = row.DSMHMouth3 + "\""; } } catch { } break; case 4: row.DSMHMouth3 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth3 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth4Null()) { if (Distance.IsValidDistance(row.DSMHMouth4)) { Distance distance = new Distance(row.DSMHMouth4); switch (distance.DistanceType) { case 2: row.DSMHMouth4 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth4) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth4) * 0.03937; row.DSMHMouth4 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth4 = row.DSMHMouth4 + "\""; } } catch { } break; case 4: row.DSMHMouth4 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth4 = distance.ToStringInEng1(); break; } } } if (!row.IsDSMHMouth5Null()) { if (Distance.IsValidDistance(row.DSMHMouth5)) { Distance distance = new Distance(row.DSMHMouth5); switch (distance.DistanceType) { case 2: row.DSMHMouth5 = distance.ToStringInEng1(); break; case 3: try { if (Convert.ToDouble(row.DSMHMouth5) > 99) { double newSize_ = 0; newSize_ = Convert.ToDouble(row.DSMHMouth5) * 0.03937; row.DSMHMouth5 = Convert.ToString(Math.Ceiling(newSize_)) + "\""; } else { row.DSMHMouth5 = row.DSMHMouth5 + "\""; } } catch { } break; case 4: row.DSMHMouth5 = distance.ToStringInEng1(); break; case 5: row.DSMHMouth5 = distance.ToStringInEng1(); break; } } } } flM1LateralReportGateway.LoadByAssetId(row.AssetID, row.COMPANY_ID); flM1LateralReport.UpdateForReport(row.FlowOrderID, unitType); } }