public static ArrayList GetWebFiles(string serverPath, string clientId, MySqlWrapper dbConn) { ArrayList WebFiles = new ArrayList(); try { string sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads where uploads_ownerid= " + clientId; ArrayList recordset = dbConn.Execute(sql); foreach (ArrayList record in recordset) { WebUploadedFiles file = new WebUploadedFiles((string)record[1], serverPath + record[0]); WebFiles.Add(file); } sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads,ctool_uploadstouser where uploads_id = uploadstouser_uploads_id AND uploadstouser_mid = " + clientId; recordset = dbConn.Execute(sql); foreach (ArrayList record in recordset) { WebUploadedFiles file = new WebUploadedFiles((string)record[1], serverPath + record[0]); WebFiles.Add(file); } } catch (Exception ee) { // MessageBox.Show("We Integration " + ee.Message); } return(WebFiles); }
public static ArrayList GetWebFiles(string serverPath,string clientId,MySqlWrapper dbConn) { ArrayList WebFiles = new ArrayList(); try { string sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads where uploads_ownerid= " + clientId; ArrayList recordset = dbConn.Execute(sql); foreach(ArrayList record in recordset) { WebUploadedFiles file = new WebUploadedFiles((string)record[1],serverPath + record[0]); WebFiles.Add(file); } sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads,ctool_uploadstouser where uploads_id = uploadstouser_uploads_id AND uploadstouser_mid = " + clientId; recordset = dbConn.Execute(sql); foreach(ArrayList record in recordset) { WebUploadedFiles file = new WebUploadedFiles((string)record[1],serverPath + record[0]); WebFiles.Add(file); } } catch(Exception ee) { // MessageBox.Show("We Integration " + ee.Message); } return WebFiles; }