private DataTable GetInstalledSitesListTable(TDBTransaction AReadTransaction, string ATableName) { // Used eg. in New Partner Dialog. StringCollection RequiredColumns = new StringCollection(); RequiredColumns.Add(PPartnerLedgerTable.GetPartnerKeyDBName()); PPartnerLedgerTable TmpInstalledSitesDT = PPartnerLedgerAccess.LoadAll(RequiredColumns, AReadTransaction, null, 0, 0); if (TmpInstalledSitesDT.Rows.Count != 0) { TmpInstalledSitesDT.Columns.Remove(PPartnerLedgerTable.GetLastPartnerIdDBName()); TmpInstalledSitesDT.Columns.Add(PPartnerTable.GetPartnerShortNameDBName(), System.Type.GetType("System.String")); RequiredColumns = new StringCollection(); RequiredColumns.Add(PPartnerTable.GetPartnerShortNameDBName()); for (int Counter = 0; Counter <= TmpInstalledSitesDT.Rows.Count - 1; Counter += 1) { PPartnerTable PartnerDT = PPartnerAccess.LoadByPrimaryKey( TmpInstalledSitesDT[Counter].PartnerKey, RequiredColumns, AReadTransaction, null, 0, 0); TmpInstalledSitesDT[Counter][PPartnerTable.GetPartnerShortNameDBName()] = PartnerDT[0].PartnerShortName; } } return(TmpInstalledSitesDT); }
private DataTable GetInstalledSitesListTable(TDBTransaction AReadTransaction, string ATableName) { // Used eg. in New Partner Dialog. StringCollection RequiredColumns = new StringCollection(); RequiredColumns.Add(PPartnerLedgerTable.GetPartnerKeyDBName()); PPartnerLedgerTable TmpInstalledSitesDT = PPartnerLedgerAccess.LoadAll(RequiredColumns, AReadTransaction, null, 0, 0); if (TmpInstalledSitesDT.Rows.Count != 0) { TmpInstalledSitesDT.Columns.Remove(PPartnerLedgerTable.GetLastPartnerIdDBName()); TmpInstalledSitesDT.Columns.Add(PPartnerTable.GetPartnerShortNameDBName(), System.Type.GetType("System.String")); RequiredColumns = new StringCollection(); RequiredColumns.Add(PPartnerTable.GetPartnerShortNameDBName()); for (int Counter = 0; Counter <= TmpInstalledSitesDT.Rows.Count - 1; Counter += 1) { PPartnerTable PartnerDT = PPartnerAccess.LoadByPrimaryKey( TmpInstalledSitesDT[Counter].PartnerKey, RequiredColumns, AReadTransaction, null, 0, 0); TmpInstalledSitesDT[Counter][PPartnerTable.GetPartnerShortNameDBName()] = PartnerDT[0].PartnerShortName; } } // As part of bug 5556 testing, checked if this DataTable contained any Added rows. It didn't, so there isn't an issue here. // Findings: DataTable summary: 1 rows; 0 Added, 0 deleted, 0 detached, 1 modified, 0 unchanged. Table name PPartnerLedger return(TmpInstalledSitesDT); }