/// <summary> /// This function returns all the application ids from the source table /// </summary> /// <returns></returns> private string GetAllApplicationId() { try { string lSourceConnString = ReadConfigFile("SourceConnectionString"); string lQuery = string.Empty; string lApplicationId = "'"; lQuery = " SELECT APPLICATION_ID FROM SOURCEDB.T_EXT_APPLICATION ORDER BY APPLICATION_ID "; OracleProvider lProvider = new OracleProvider(); DataTable lRecords = lProvider.FetchDataFromDB(lQuery, lSourceConnString); foreach (DataRow ldr in lRecords.Rows) { lApplicationId = lApplicationId + ldr["APPLICATION_ID"].ToString() + "','"; } if (lApplicationId.Length > 1) { lApplicationId = lApplicationId.Remove(lApplicationId.Length - 2, 2); } else { lApplicationId = string.Empty; } return(lApplicationId); } catch (Exception ex) { MessageBox.Show("Exception: " + ex.Message); return(string.Empty); } }
/// <summary> /// This function fetches all the application id's from source based on a condition /// </summary> /// <returns>comma separated application_id</returns> private string FetchAllAppIDFromSource() { try { string lSourceConnString = ReadConfigFile("SourceConnectionString"); string lQuery = string.Empty; string lApplicationId = "'"; lQuery = " SELECT APPLICATION_ID "; lQuery = lQuery + " FROM " + ReadConfigFile("SourceUser") + ".T_EXT_APPLICATION "; lQuery = lQuery + " WHERE SUBMIT_DATE IS NOT NULL "; lQuery = lQuery + " AND SUBMIT_DATE > "; lQuery = lQuery + " (SELECT MAX (SUBMIT_DATE) FROM " + ReadConfigFile("DestUser") + ".T_APPLICATION) "; lQuery = lQuery + "ORDER BY SUBMIT_DATE ASC "; OracleProvider lProvider = new OracleProvider(); DataTable lRecords = lProvider.FetchDataFromDB(lQuery, lSourceConnString); foreach (DataRow ldr in lRecords.Rows) { lApplicationId = lApplicationId + ldr["APPLICATION_ID"].ToString() + "','"; } if (lApplicationId.Length > 1) { lApplicationId = lApplicationId.Remove(lApplicationId.Length - 2, 2); } else { lApplicationId = string.Empty; } return(lApplicationId); } catch (Exception ex) { MessageBox.Show("Exception: " + ex.Message); return(string.Empty); } }