/// <summary> /// Retrieve a data table containing the application specified. /// </summary> /// <param name="appcode">string: Application code.</param> /// <returns>iCampaign.TACS.Data.ApplicationsDs.ApplicationsDataTable</returns> internal iCampaign.TACS.Data.ApplicationsDs.ApplicationsDataTable GetApplication(string appcode) { // Instantiate the database objects ApplicationsDs.ApplicationsDataTable dataTable = new ApplicationsDs.ApplicationsDataTable(); iCampaign.TACS.Data.ApplicationsDsTableAdapters.ApplicationsTableAdapter tableAdapter = new iCampaign.TACS.Data.ApplicationsDsTableAdapters.ApplicationsTableAdapter(); tableAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); // Try and get the data from the TACS.NET database try { tableAdapter.Connection.Open(); tableAdapter.FillByAppCode(dataTable, appcode); } catch (Exception ex) { throw ex; } finally { tableAdapter.Connection.Close(); } return dataTable; }
/// <summary> /// Get the request application row from the database. /// </summary> /// <param name="appcode">string: Application code.</param> /// <returns>iCampaign.TACS.Data.ApplicationsDs.ApplicationsRow: object.</returns> private Data.ApplicationsDs.ApplicationsRow GetApplicationRow(string appcode) { // Initialize ADO.NET objects Data.ApplicationsDs.ApplicationsDataTable appTable = new ApplicationsDs.ApplicationsDataTable(); Data.ApplicationsDsTableAdapters.ApplicationsTableAdapter tableAdapter = new iCampaign.TACS.Data.ApplicationsDsTableAdapters.ApplicationsTableAdapter(); Data.ApplicationsDs.ApplicationsRow appRow = null; tableAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); // Fetch the application information try { tableAdapter.Connection.Open(); tableAdapter.FillByAppCode(appTable, appcode); if (appTable.Count != 0) appRow = appTable[0]; } catch (Exception ex) { throw ex; } finally { tableAdapter.Connection.Close(); } return appRow; }