public static String getProjectFilePath(String sProjectName)
{
//o2.datalayer.mysql.OunceMySql.
DataTable dtResults =
OunceMySql.getDataTableFromSqlQuery(getSqlQueryForRetrivingProjectFilePath(sProjectName), false);
if (dtResults.Rows.Count == 1)
{
var sProjectFile = (String)dtResults.Rows[0].ItemArray[0];
return(Path.GetDirectoryName(sProjectFile));
}
return("");
}
public static String[] getApplications()
{
String sSql = "SELECT File_Path FROM prexis.application";
DataTable dtResult = OunceMySql.getDataTableFromSqlQuery(sSql, false);
if (dtResult != null)
{
var lsApplications = new List <string>();
foreach (DataRow drRow in dtResult.Rows)
{
lsApplications.Add(drRow["File_Path"].ToString());
}
return(lsApplications.ToArray());
}
return(new String[] {});
}
