public static void ImportPartner(PartnerEditTDS AMainDS) { TDBTransaction ReadTransaction = null; TDBTransaction SubmitChangesTransaction = null; bool SubmissionOK = false; bool ImportDefaultAcquCodeExists = false; DBAccess.GDBAccessObj.BeginAutoReadTransaction(IsolationLevel.ReadCommitted, ref ReadTransaction, delegate { ImportDefaultAcquCodeExists = PAcquisitionAccess.Exists(MPartnerConstants.PARTNERIMPORT_AQUISITION_DEFAULT, ReadTransaction); }); if (!ImportDefaultAcquCodeExists) { PAcquisitionTable AcqTable = new PAcquisitionTable(); PAcquisitionRow row = AcqTable.NewRowTyped(); row.AcquisitionCode = MPartnerConstants.PARTNERIMPORT_AQUISITION_DEFAULT; row.AcquisitionDescription = Catalog.GetString("Imported Data"); AcqTable.Rows.Add(row); DBAccess.GDBAccessObj.BeginAutoTransaction(IsolationLevel.Serializable, ref SubmitChangesTransaction, ref SubmissionOK, delegate { PAcquisitionAccess.SubmitChanges(AcqTable, SubmitChangesTransaction); SubmissionOK = true; }); } PartnerEditTDSAccess.SubmitChanges(AMainDS); }
private void ValidateDataDetailsManual(PAcquisitionRow ARow) { TVerificationResultCollection VerificationResultCollection = FPetraUtilsObject.VerificationResultCollection; TSharedValidation_CacheableDataTables.ValidateAcquisitionCodeSetup(this, ARow, ref VerificationResultCollection, FPetraUtilsObject.ValidationControlsDict); }
private void ValidateDataDetailsManual(PAcquisitionRow ARow) { TVerificationResultCollection VerificationResultCollection = FPetraUtilsObject.VerificationResultCollection; TSharedValidation_CacheableDataTables.ValidateAcquisitionCodeSetup(this, ARow, ref VerificationResultCollection, FPetraUtilsObject.ValidationControlsDict); }
private void NewRowManual(ref PAcquisitionRow ARow) { string newName = Catalog.GetString("NEWCODE"); Int32 countNewDetail = 0; if (FMainDS.PAcquisition.Rows.Find(new object[] { newName }) != null) { while (FMainDS.PAcquisition.Rows.Find(new object[] { newName + countNewDetail.ToString() }) != null) { countNewDetail++; } newName += countNewDetail.ToString(); } ARow.AcquisitionCode = newName; }
private void NewRowManual(ref PAcquisitionRow ARow) { string newName = Catalog.GetString("NEWCODE"); Int32 countNewDetail = 0; if (FMainDS.PAcquisition.Rows.Find(new object[] { newName }) != null) { while (FMainDS.PAcquisition.Rows.Find(new object[] { newName + countNewDetail.ToString() }) != null) { countNewDetail++; } newName += countNewDetail.ToString(); } ARow.AcquisitionCode = newName; }
/// <summary> /// Validates the Setup Partner Acquisition Code screen data. /// </summary> /// <param name="AContext">Context that describes where the data validation failed.</param> /// <param name="ARow">The <see cref="DataRow" /> which holds the the data against which the validation is run.</param> /// <param name="AVerificationResultCollection">Will be filled with any <see cref="TVerificationResult" /> items if /// data validation errors occur.</param> /// <param name="AValidationControlsDict">A <see cref="TValidationControlsDict" /> containing the Controls that /// display data that is about to be validated.</param> public static void ValidateAcquisitionCodeSetup(object AContext, PAcquisitionRow ARow, ref TVerificationResultCollection AVerificationResultCollection, TValidationControlsDict AValidationControlsDict) { DataColumn ValidationColumn; TValidationControlsData ValidationControlsData; TVerificationResult VerificationResult; // Don't validate deleted DataRows if (ARow.RowState == DataRowState.Deleted) { return; } // 'AcquisitionDescription' must have a value ValidationColumn = ARow.Table.Columns[PAcquisitionTable.ColumnAcquisitionDescriptionId]; if (AValidationControlsDict.TryGetValue(ValidationColumn, out ValidationControlsData)) { VerificationResult = TStringChecks.StringMustNotBeEmpty(ARow.AcquisitionDescription, ValidationControlsData.ValidationControlLabel, AContext, ValidationColumn, ValidationControlsData.ValidationControl); // Handle addition to/removal from TVerificationResultCollection AVerificationResultCollection.Auto_Add_Or_AddOrRemove(AContext, VerificationResult, ValidationColumn); } }