/// <summary> /// Save a lateral /// </summary> /// <param name="row">row</param> /// <param name="projectId">projectId</param> /// <param name="sectionAssetId">sectionAssetId</param> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="companyId">companyId</param> /// <param name="isNewMeasuredFromDsmh">isNewMeasuredFromDsmh</param> /// <returns>lateral_assetId</returns> private int SaveLateral(RehabAssessmentTDS.LateralDetailsRow row, int projectId, int sectionAssetId, Int64 countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId, bool isNewMeasuredFromDsmh) { int section_ = sectionAssetId; string lateralID = row.LateralID; if (!isNewMeasuredFromDsmh) { lateralID = lateralID.Substring(3, lateralID.Length - 3); } string address = ""; if (!row.IsMnNull()) address = row.Mn; string size_ = ""; if (!row.IsSize_Null()) size_ = row.Size_; string live = ""; if (!row.IsLiveNull()) live = row.Live; string distanceFromUSMH = ""; if (!row.IsDistanceFromUSMHNull()) distanceFromUSMH = row.DistanceFromUSMH; string distanceFromDSMH = ""; if (!row.IsDistanceFromDSMHNull()) distanceFromDSMH = row.DistanceFromDSMH; string connectionType = ""; if (!row.IsConnectionTypeNull()) connectionType = row.ConnectionType; LfsAssetSewerLateral lfsAssetSewerLateral = new LfsAssetSewerLateral(null); int lateral_assetId = lfsAssetSewerLateral.InsertDirect(countryId, provinceId, countyId, cityId, section_, address, lateralID, "", "", "", "", live, size_, distanceFromUSMH, distanceFromDSMH, "", false, companyId, connectionType); return lateral_assetId; }