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