public static ArrayList GetWebBookMarks(string serverPath,string clientID, MySqlWrapper dbConn)
{
ArrayList webBookmarks = new ArrayList();
try
{
string sql = "select bookmark_title,bookmark_url from ctool_bookmark where bookmark_ownerid = " + clientID;
ArrayList recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
webBookmarks.Add(entry);
}
sql = "select bookmark_title,bookmark_url from ctool_bookmark,ctool_bmtouser where bookmark_id = bmtouser_bookmark_id AND bmtouser_mid = " + clientID;
recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
webBookmarks.Add(entry);
}
}
catch(Exception ee)
{
// MessageBox.Show(ee.Message);
}
return webBookmarks;
}
public static ArrayList GetWebPresentations(string serverPath,string clientID, MySqlWrapper dbConn)
{
ArrayList WebPresentations = new ArrayList();
try
{
string sql = "select presentation_title,Concat(presentation_id,presentation_url) from ctool_presentation where presentation_ownerid = " + clientID;
ArrayList recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebPresentationEntry entry = new WebPresentationEntry((string)record[0],serverPath + record[1]);
WebPresentations.Add(entry);
}
sql = "select presentation_title,Concat(presentation_id,presentation_url),pretouser_presentation_id from ctool_presentation,ctool_pretouser WHERE presentation_id = pretouser_presentation_id AND pretouser_mid = " + clientID;
recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebPresentationEntry entry = new WebPresentationEntry((string)record[0],serverPath + record[1]);
WebPresentations.Add(entry);
}
}
catch(Exception ee)
{
// MessageBox.Show(ee.Message);
}
return WebPresentations;
}
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;
}