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