protected void cvLateralsMaxNumber_ServerValidate(object source, ServerValidateEventArgs args) { // Get Measured From Mh value int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); string measuredFromMh = ""; FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails(); flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId); if (flLateralDetails.Table.Rows.Count > 0) { measuredFromMh = "USMH"; } else { measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue; } // Generate increment FullLengthLiningLateralDetails fullLengthLiningLateraldetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS); if (measuredFromMh == "USMH" || measuredFromMh == "") { if (fullLengthLiningLateraldetails.GetMaxLateralId2() == "A[") args.IsValid = false; else args.IsValid = true; } else { if (measuredFromMh == "DSMH") { if (fullLengthLiningLateraldetails.GetMinLateralId2() == "@") args.IsValid = false; else args.IsValid = true; } } }
private string GetLateralIdIncrement() { // Get Measured From Mh value int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); string measuredFromMh = ""; FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails(); flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId); if (flLateralDetails.Table.Rows.Count > 0) { measuredFromMh = "USMH"; } else { measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue; } // Generate increment string lateralIdIncrement = ""; FullLengthLiningLateralDetails fullLengthLiningLateraldetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS); if (measuredFromMh == "USMH" || measuredFromMh == "") { lateralIdIncrement = fullLengthLiningLateraldetails.GetMaxLateralId2(); } else { if (measuredFromMh == "DSMH") { lateralIdIncrement = fullLengthLiningLateraldetails.GetMinLateralId2(); } } return "FL-"+lateralIdIncrement; }
/// <summary> /// Save /// </summary> /// <param name="projectId">projectId</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="loginId">loginId</param> public void Save(int projectId, Int64 countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId, int loginId) { FullLengthLiningTDS fullLengthLiningTDS = new FullLengthLiningTDS(); foreach (WincapBulkUploadTDS.WincapBulkUploadRow row in (WincapBulkUploadTDS.WincapBulkUploadDataTable)Table) { string state = ""; if (!row.IsStateNull()) state = row.State; string direction = ""; if (!row.IsDirectionNull()) direction = row.Direction; string distance = ""; if (!row.IsDistanceNull()) distance = row.Distance; string videoDistance = ""; if (!row.IsVideoDistanceNull()) videoDistance = row.VideoDistance; string clockPosition = ""; if (!row.IsClockPositionNull()) clockPosition = row.ClockPosition; string distanceToCentre = ""; if (!row.IsDistanceToCentreNull()) distanceToCentre = row.DistanceToCentre; string reverseSetup = ""; if (!row.IsReverseSetupNull()) reverseSetup = row.ReverseSetup; string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments; string measuredFromMh = "USMH"; if (row.Direction.Contains("D")) { measuredFromMh = "DSMH"; } int section_assetId = SaveSection(row.SectionID, projectId, countryId, provinceId, countyId, cityId, companyId); WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null); int workId = workFullLengthLining.InsertDirectEmptyWorks(projectId, section_assetId, null, "", null, null, null, null, null, null, null, false, false, false, false, false, false, false, companyId, false, "", ""); FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails(); flLateralDetails.LoadForEdit(workId, section_assetId, companyId, projectId); // Generate increment string lateralIdIncrement = ""; if (measuredFromMh == "USMH" || measuredFromMh == "") { lateralIdIncrement = flLateralDetails.GetMaxLateralId2(); } else { if (measuredFromMh == "DSMH") { lateralIdIncrement = flLateralDetails.GetMinLateralId2(); } } string videoLength = ""; string lateralId = "FL-" + lateralIdIncrement; FullLengthLiningLateralDetails model = new FullLengthLiningLateralDetails(fullLengthLiningTDS); model.Insert(videoDistance, clockPosition, distanceToCentre, "", reverseSetup, null, comments, lateralId, "", "", false, companyId, true, state, "", "", "", "", null, false, null, false, false, false, "", false, false, null); model.Save(workId, projectId, section_assetId, countryId, provinceId, countyId, cityId, videoLength, companyId, false, false, null); } }