/// <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);
}
}
