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[] {}); }