public string ReadSQLFile(string tempUnzippedPath, string sqlProvidername)
{
string exceptions = string.Empty;
try
{
StreamReader objReader = new StreamReader(tempUnzippedPath + '\\' + sqlProvidername);
string sLine = "";
string scriptDetails = "";
ArrayList arrText = new ArrayList();
while (sLine != null)
{
sLine = objReader.ReadLine();
if (sLine != null)
{
arrText.Add(sLine);
}
}
objReader.Close();
foreach (string sOutput in arrText)
{
scriptDetails += sOutput + "\r\n";
}
OracleHandler sqlHandler = new OracleHandler();
exceptions = sqlHandler.ExecuteScript(scriptDetails, true);
}
catch (Exception ex)
{
exceptions += ex.Message.ToString();
}
return(exceptions);
}