/// <summary>
/// Adds the RSS request parameters.
/// </summary>
/// <param name="sri">
/// The service request info.
/// </param>
/// <returns>
/// A string value...
/// </returns>
public static string AddRSSRequestParameters(ServiceRequestInfo sri)
{
var sb = new StringBuilder();
sb.Append("?LT=" + sri.ListType);
if (sri.PortalAlias.Length != 0)
{
sb.Append("&PA=" + sri.PortalAlias);
}
if (sri.UserName.Length != 0)
{
sb.Append("&UN=" + sri.UserName);
}
if (sri.UserPassword.Length != 0)
{
sb.Append("&UP=" + sri.UserPassword);
}
if (sri.ModuleType.Length != 0)
{
sb.Append("&MT=" + sri.ModuleType);
}
sb.Append("&MH=" + sri.MaxHits);
sb.Append("&SID=" + sri.ShowID);
if (sri.SearchString.Length != 0)
{
sb.Append("&SS=" + sri.SearchString);
}
if (sri.SearchField.Length != 0)
{
sb.Append("&SF=" + sri.SearchField);
}
if (sri.SortField.Length != 0)
{
sb.Append("&SoF=" + sri.SortField);
}
if (sri.SortDirection.Length != 0)
{
sb.Append("&SD=" + sri.SortDirection);
}
sb.Append("&RLO=" + sri.RootLevelOnly);
sb.Append("&MO=" + sri.MobileOnly);
if (sri.IDList.Length != 0)
{
sb.Append("&IDL=" + sri.IDList);
}
sb.Append("&IDLT=" + sri.IDListType);
return sb.ToString();
}
/// <summary>
/// Gets a list of items as described in requestInfo
/// </summary>
/// <param name="portalId">
/// Only items for portalID is returned
/// </param>
/// <param name="userId">
/// User ID. If -1 the user is Annonymous/Guest
/// </param>
/// <param name="applicationFullPath">
/// Full URL path to Appleseed site
/// </param>
/// <param name="requestInfo">
/// a filled ServiceRequestInfo class
/// </param>
/// <returns>
/// ArrayList
/// </returns>
public static List<ServiceResponseInfoItem> GetResponseItemList(
int portalId, Guid userId, string applicationFullPath, ref ServiceRequestInfo requestInfo)
{
var colItems = new List<ServiceResponseInfoItem>();
ServiceResponseInfoItem responseItem;
var moduleType = requestInfo.ModuleType;
// JLH!! We really should lookup complete ModuleName in db...
if (moduleType.ToUpper() == "ALL")
{
moduleType = string.Empty;
}
else
{
moduleType = string.Format("Appleseed.DLL;Appleseed.DesktopModules.{0}", moduleType);
}
var select = new StringBuilder(string.Empty, 1000);
if (requestInfo.IDList.Length != 0)
{
if (requestInfo.IDListType == ServiceListType.Tab)
{
select.AppendFormat(" AND tab.PageID IN ({0})", requestInfo.IDList);
}
if (requestInfo.IDListType == ServiceListType.Module)
{
select.AppendFormat(" AND mod.ModuleID IN ({0})", requestInfo.IDList);
}
}
// We can not add this code - original search sql not ready for this!
// if (requestInfo.RootLevelOnly)
// select.Append(" AND tab.ParentPageID IS NULL");
if (requestInfo.MobileOnly)
{
select.Append(" AND mod.ShowMobile=1");
}
var dr = SearchHelper.SearchPortal(
portalId,
userId,
moduleType,
requestInfo.SearchString,
requestInfo.SearchField,
requestInfo.SortField,
requestInfo.SortDirection,
string.Empty,
select.ToString());
var hits = 1;
try
{
while (dr.Read() && hits <= requestInfo.MaxHits)
{
responseItem = new ServiceResponseInfoItem();
if (!dr.IsDBNull(0))
{
responseItem.FriendlyName = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
responseItem.Title = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
HTMLText html = SearchHelper.DeleteBeforeBody(HttpUtility.HtmlDecode(dr.GetString(2)));
responseItem.Description = html.InnerText;
}
if (!dr.IsDBNull(3))
{
responseItem.ModuleID = dr.GetInt32(3);
}
if (!dr.IsDBNull(4))
{
responseItem.ItemID = dr.GetInt32(4);
if (requestInfo.ShowID)
{
responseItem.Title += string.Format(" (ItemID={0})", responseItem.ItemID);
}
}
if (!dr.IsDBNull(5))
{
responseItem.CreatedByUser = dr.GetString(5);
}
if (!dr.IsDBNull(6))
{
try
{
responseItem.CreatedDate = dr.GetDateTime(6);
}
catch
{
// Modules like HtmlModule has not field CreatedDate
}
}
if (!dr.IsDBNull(7))
{
responseItem.PageID = dr.GetInt32(7);
if (requestInfo.ShowID)
{
responseItem.Description += string.Format(
" (PageID={0}, ModuleID={1})", responseItem.PageID, responseItem.ModuleID);
}
}
if (!dr.IsDBNull(8))
{
responseItem.PageName = dr.GetString(8);
}
if (!dr.IsDBNull(9))
{
responseItem.GeneralModDefID = dr.GetGuid(9).ToString().ToUpper();
}
if (!dr.IsDBNull(10))
{
responseItem.ModuleTitle = dr.GetString(10);
}
if (responseItem.GeneralModDefID == "0B113F51-FEA3-499A-98E7-7B83C192FDBB" || // Html Document
responseItem.GeneralModDefID == "2B113F51-FEA3-499A-98E7-7B83C192FDBB")
{
// Html WYSIWYG Edit (V2)
// We use the database field [rb.Modules].[ModuleTitle]:
responseItem.Title = responseItem.ModuleTitle;
}
responseItem.Link = string.Format(
"{0}/DesktopDefault.aspx?tabID={1}", applicationFullPath, responseItem.PageID);
if (requestInfo.PortalAlias.Length != 0)
{
responseItem.Link += string.Format("&Alias={0}", requestInfo.PortalAlias);
}
colItems.Add(responseItem);
hits++;
}
}
finally
{
dr.Close(); // by Manu, fixed bug 807858
}
return colItems;
}
/// <summary>
/// This function return's true if no problem reading ServiceRequestInfo parameters
/// </summary>
/// <param name="parameters">
/// The page Request.Params
/// </param>
/// <param name="parameterError">
/// out: all param that were bad
/// </param>
/// <param name="requestInfo">
/// out: a filled ServiceRequestInfo class
/// </param>
/// <returns>
/// bool
/// </returns>
public static bool FillRSSServiceRequestInfo(
NameValueCollection parameters, ref string parameterError, ref ServiceRequestInfo requestInfo)
{
var retValue = true;
string par;
parameterError = string.Empty;
requestInfo.Type = ServiceType.CommunityRSSService;
requestInfo.LocalMode = true;
if (parameters["PortalAlias"] != null)
{
requestInfo.PortalAlias = parameters["PortalAlias"];
}
if (parameters["PA"] != null)
{
requestInfo.PortalAlias = parameters["PA"];
}
if (parameters["UserName"] != null)
{
requestInfo.UserName = parameters["UserName"];
}
if (parameters["UN"] != null)
{
requestInfo.UserName = parameters["UN"];
}
if (parameters["UserPassword"] != null)
{
requestInfo.UserPassword = parameters["UserPassword"];
}
if (parameters["UP"] != null)
{
requestInfo.UserPassword = parameters["UP"];
}
par = string.Empty;
if (parameters["ListType"] != null)
{
par = parameters["ListType"].ToUpper();
}
if (parameters["LT"] != null)
{
par = parameters["LT"].ToUpper();
}
if (par.Length != 0)
{
if (!(par == "ITEM" || par == "MODULE" || par == "TAB"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "ListType";
}
else
{
if (par == ServiceListType.Item.ToString().ToUpper())
{
requestInfo.ListType = ServiceListType.Item;
}
if (par == ServiceListType.Module.ToString().ToUpper())
{
requestInfo.ListType = ServiceListType.Module;
}
if (par == ServiceListType.Tab.ToString().ToUpper())
{
requestInfo.ListType = ServiceListType.Tab;
}
}
}
par = string.Empty;
if (parameters["ModuleType"] != null)
{
par = parameters["ModuleType"];
}
if (parameters["MT"] != null)
{
par = parameters["MT"];
}
if (par.Length != 0)
{
if (
!(par == "All" || par == "Announcements" || par == "Contacts" || par == "Discussion" ||
par == "Events" || par == "HtmlModule" || par == "Documents" || par == "Pictures" ||
par == "Articles" || par == "Tasks" || par == "FAQs" || par == "ComponentModule"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "ModuleType";
}
else
{
requestInfo.ModuleType = par;
}
}
par = string.Empty;
if (parameters["MaxHits"] != null)
{
par = parameters["MaxHits"];
}
if (parameters["MH"] != null)
{
par = parameters["MH"];
}
if (par.Length != 0)
{
try
{
requestInfo.MaxHits = int.Parse(par);
}
catch
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "MaxHits";
}
}
par = string.Empty;
if (parameters["ShowID"] != null)
{
par = parameters["ShowID"];
}
if (parameters["SID"] != null)
{
par = parameters["SID"];
}
if (par.Length != 0)
{
try
{
if (par == "0" || par == "1")
{
requestInfo.ShowID = par == "1";
}
else
{
requestInfo.ShowID = bool.Parse(par);
}
}
catch
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "ShowID";
}
}
if (parameters["SearchString"] != null)
{
requestInfo.SearchString = parameters["SearchString"];
}
if (parameters["SS"] != null)
{
requestInfo.SearchString = parameters["SS"];
}
if (parameters["SearchField"] != null)
{
requestInfo.SearchField = parameters["SearchField"];
}
if (parameters["SF"] != null)
{
requestInfo.SearchField = parameters["SF"];
}
par = string.Empty;
if (parameters["SortField"] != null)
{
par = parameters["SortField"].ToUpper();
}
if (parameters["SoF"] != null)
{
par = parameters["SoF"].ToUpper();
}
if (par.Length != 0)
{
switch (requestInfo.ListType)
{
case ServiceListType.Item:
if (
!(par == "MODULENAME" || par == "TITLE" || par == "CREATEDBYUSER" || par == "CREATEDDATE" ||
par == "PAGENAME"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "SortField";
}
else
{
requestInfo.SortField = par;
}
break;
case ServiceListType.Module:
if (!(par == "FRIENDLYNAME" || par == "TITLE"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "SortField";
}
else
{
requestInfo.SortField = par;
}
break;
}
}
par = string.Empty;
if (parameters["SortDirection"] != null)
{
par = parameters["SortDirection"].ToUpper();
}
if (parameters["SD"] != null)
{
par = parameters["SD"].ToUpper();
}
if (par.Length != 0)
{
if (!(par == "ASC" || par == "DESC"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "SortDirection";
}
else
{
requestInfo.SortDirection = par;
}
}
par = string.Empty;
if (parameters["RootLevelOnly"] != null)
{
par = parameters["RootLevelOnly"];
}
if (parameters["RLO"] != null)
{
par = parameters["RLO"];
}
if (par.Length != 0)
{
try
{
if (par == "0" || par == "1")
{
requestInfo.RootLevelOnly = par == "1";
}
else
{
requestInfo.RootLevelOnly = bool.Parse(par);
}
}
catch
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "RootLevelOnly";
}
}
par = string.Empty;
if (parameters["MobileOnly"] != null)
{
par = parameters["MobileOnly"];
}
if (parameters["MO"] != null)
{
par = parameters["MO"];
}
if (par.Length != 0)
{
try
{
if (par == "0" || par == "1")
{
requestInfo.MobileOnly = par == "1";
}
else
{
requestInfo.MobileOnly = bool.Parse(par);
}
}
catch
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "MobileOnly";
}
}
if (parameters["IDList"] != null)
{
requestInfo.IDList = parameters["IDList"];
}
if (parameters["IDL"] != null)
{
requestInfo.IDList = parameters["IDL"];
}
par = string.Empty;
if (parameters["IDListType"] != null)
{
par = parameters["IDListType"].ToUpper();
}
if (parameters["IDLT"] != null)
{
par = parameters["IDLT"].ToUpper();
}
if (par.Length != 0)
{
if (!(par == "ITEM" || par == "MODULE" || par == "TAB"))
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "ListType";
}
else
{
if (par == ServiceListType.Item.ToString().ToUpper())
{
requestInfo.IDListType = ServiceListType.Item;
}
if (par == ServiceListType.Module.ToString().ToUpper())
{
requestInfo.IDListType = ServiceListType.Module;
}
if (par == ServiceListType.Tab.ToString().ToUpper())
{
requestInfo.IDListType = ServiceListType.Tab;
}
}
}
par = string.Empty;
if (parameters["Tag"] != null)
{
par = parameters["Tag"];
}
if (parameters["T"] != null)
{
par = parameters["T"];
}
if (par.Length != 0)
{
try
{
requestInfo.Tag = int.Parse(par);
}
catch
{
retValue = false;
if (parameterError.Length != 0)
{
parameterError += ", ";
}
parameterError += "Tag";
}
}
return retValue;
}
/// <summary>
/// Calls an RSS service and returns the service response.
/// This method goes crazy with the Regex class to parse the response
/// from an RSS service. After testing, I discovered that most
/// RSS services do not return a valid XML response. That requires
/// parsing through possibly faulty XML (missing end tags, etc.)
/// </summary>
/// <param name="requestInfo">
/// a filled ServiceRequestInfo class
/// </param>
/// <returns>
/// The Service Response Info
/// </returns>
private static ServiceResponseInfo CallRssService(ServiceRequestInfo requestInfo)
{
var responseInfo = new ServiceResponseInfo();
// Grab the page
var rawResponse = GetWebPage(requestInfo.Url);
if (rawResponse == string.Empty)
{
responseInfo.ServiceStatus = "No reply from URL (could be timeout)";
return responseInfo;
}
// Get Channel
var channel = Regex.Match(rawResponse, @"<channel>(.*?)</channel>", RegexOptions.Singleline);
if (channel.Success)
{
// Get Service title
var serviceTitle = Regex.Match(
channel.Result("$1"), @"<title>(.*?)</title>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (serviceTitle.Success)
{
responseInfo.ServiceTitle = serviceTitle.Result("$1");
}
// Get Service Link
var serviceLink = Regex.Match(
channel.Result("$1"), @"<link>(.*?)</link>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (serviceLink.Success)
{
responseInfo.ServiceLink = serviceLink.Result("$1");
}
// Get Service Description
var serviceDescription = Regex.Match(
channel.Result("$1"),
@"<description>(.*?)</description>",
RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (serviceDescription.Success)
{
responseInfo.ServiceDescription = serviceDescription.Result("$1");
}
// Get Service Copyright
var serviceCopyright = Regex.Match(
channel.Result("$1"),
@"<copyright>(.*?)</copyright>",
RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (serviceCopyright.Success)
{
responseInfo.ServiceCopyright = serviceCopyright.Result("$1");
}
}
// Get Image
var image = Regex.Match(rawResponse, @"<image>(.*?)</image>", RegexOptions.Singleline);
if (image.Success)
{
// Get Image title
var imageTitle = Regex.Match(
image.Result("$1"), @"<title>(.*?)</title>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (imageTitle.Success)
{
responseInfo.ServiceImageTitle = imageTitle.Result("$1");
}
// Get Image Url
var imageUrl = Regex.Match(
image.Result("$1"), @"<url>(.*?)</url>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (imageUrl.Success)
{
responseInfo.ServiceImageUrl = imageUrl.Result("$1");
}
// Get Image Link
var imageLink = Regex.Match(
image.Result("$1"), @"<link>(.*?)</link>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (imageLink.Success)
{
responseInfo.ServiceImageLink = imageLink.Result("$1");
}
}
// Get Items
var items = Regex.Matches(rawResponse, @"<item>(.*?)</item>", RegexOptions.Singleline);
var counter = 0;
foreach (Match item in items)
{
counter++;
if (counter > requestInfo.MaxHits)
{
break;
}
var responseInfoItem = new ServiceResponseInfoItem();
// Get Item title
var itemTitle = Regex.Match(
item.Result("$1"), @"<title>(.*?)</title>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (itemTitle.Success)
{
responseInfoItem.Title = itemTitle.Result("$1");
}
// Get Item Link
var itemLink = Regex.Match(
item.Result("$1"), @"<link>(.*?)</link>", RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (itemLink.Success)
{
responseInfoItem.Link = itemLink.Result("$1");
}
// Get Item Description
var itemDescription = Regex.Match(
item.Result("$1"),
@"<description>(.*?)</description>",
RegexOptions.Singleline | RegexOptions.IgnoreCase);
if (itemDescription.Success)
{
responseInfoItem.Description = itemDescription.Result("$1");
}
// Add new item to Response Info
responseInfo.Items.Add(responseInfoItem);
}
return responseInfo;
}
/// <summary>
/// Calls a community Web service. This method uses a Web service
/// proxy class to call a community service from (possibly) another
/// community Web site.
/// </summary>
/// <param name="requestInfo">
/// The request info.
/// </param>
/// <param name="servicefile">
/// The servicefile.
/// </param>
/// <returns>
/// </returns>
private static ServiceResponseInfo CallCommunityService(ServiceRequestInfo requestInfo, string servicefile)
{
// instantiate the community web service proxy class
using (var objService = new communityService())
{
// Set the URL
objService.Url = requestInfo.Url;
if (!objService.Url.EndsWith("/"))
{
objService.Url += "/";
}
objService.Url += servicefile;
// return result
var responseInfo = objService.GetCommunityContent(requestInfo);
return responseInfo;
}
}
/// <summary>
/// Gets a list of tabs as described in requestInfo
/// </summary>
/// <param name="portalId">
/// Only tabs for portalID is returned
/// </param>
/// <param name="userId">
/// User ID. If -1 the user is Anonymous/Guest
/// </param>
/// <param name="applicationFullPath">
/// Full URL path to Appleseed site
/// </param>
/// <param name="requestInfo">
/// a filled ServiceRequestInfo class
/// </param>
/// <returns>
/// ArrayList
/// </returns>
public static List<ServiceResponseInfoItem> GetResponseTabList(
int portalId, Guid userId, string applicationFullPath, ref ServiceRequestInfo requestInfo)
{
var colItems = new List<ServiceResponseInfoItem>();
ServiceResponseInfoItem responseItem = null;
var select = new StringBuilder(string.Empty, 1000);
select.Append(" SELECT");
if (requestInfo.MaxHits > 0)
{
select.AppendFormat(" TOP {0}", requestInfo.MaxHits);
}
select.Append(" Tab.*");
select.Append(" ,ISNULL(ParTab.PageName,'') AS ParentTabName");
select.Append(" ,ParTab.PageID AS ParentPageID");
select.Append(" ,Mod.ModuleID AS ModuleID");
select.Append(" ,Mod.ModuleTitle AS ModuleTitle");
select.Append(
" FROM rb_Pages Tab, rb_Pages ParTab, rb_Modules Mod, rb_ModuleDefinitions ModDef, rb_GeneralModuleDefinitions GenModDef");
select.Append(" WHERE");
select.Append(" Tab.AuthorizedRoles like '%All Users%'");
select.Append(" AND Tab.ParentPageID *= ParTab.PageID");
// Jakob: I just luv this outer join! (It's so easy!)
select.Append(" AND Tab.PageID = Mod.TabID");
select.Append(" AND Mod.ModuleDefID = ModDef.ModuleDefID");
select.Append(" AND ModDef.GeneralModDefID = GenModDef.GeneralModDefID");
select.Append(" AND Mod.AuthorizedViewRoles like '%All Users%'");
select.AppendFormat(" AND Tab.PortalID = {0}", portalId);
if (requestInfo.IDList.Length != 0)
{
if (requestInfo.IDList.Length != 0)
{
select.AppendFormat(" AND Tab.PageID IN ({0})", requestInfo.IDList);
}
if (requestInfo.IDListType == ServiceListType.Module)
{
select.AppendFormat(" AND Mod.ModuleID IN ({0})", requestInfo.IDList);
}
}
if (requestInfo.ModuleType != "All")
{
select.AppendFormat(" AND GenModDef.ClassName = 'Appleseed.DesktopModules.{0}'", requestInfo.ModuleType);
}
if (requestInfo.RootLevelOnly)
{
select.Append(" AND Tab.ParentPageID IS NULL");
}
if (requestInfo.MobileOnly)
{
select.Append(" AND Tab.ShowMobile=1");
}
if (requestInfo.SearchString.Length != 0)
{
select.AppendFormat(" AND Tab.PageName like '%{0}%'", requestInfo.SearchString);
}
select.AppendFormat(
" ORDER BY Tab.PageOrder {0}, Tab.ParentPageID, Mod.ModuleOrder ", requestInfo.SortDirection);
var pageIdPrev = -1;
var dr = DBHelper.GetDataReader(select.ToString());
try
{
while (dr.Read())
{
var pageId = (int)dr["PageID"];
var moduleId = (int)dr["ModuleID"];
if (pageId != pageIdPrev)
{
if (pageIdPrev != -1)
{
colItems.Add(responseItem);
}
responseItem = new ServiceResponseInfoItem();
if (requestInfo.ShowID)
{
responseItem.Title = string.Format("{0} (PageID={1})", dr["PageName"], pageId);
}
else
{
responseItem.Title = (string)dr["PageName"];
}
if (requestInfo.ShowID)
{
responseItem.Description = string.Format("{0} (ModuleID={1})", dr["ModuleTitle"], moduleId);
}
else
{
responseItem.Description = (string)dr["ModuleTitle"];
}
responseItem.Link = string.Format(
"{0}/DesktopDefault.aspx?tabID={1}", applicationFullPath, pageId);
if (requestInfo.PortalAlias.Length != 0)
{
responseItem.Link += string.Format("&Alias={0}", requestInfo.PortalAlias);
}
}
else
{
if (requestInfo.ShowID)
{
if (responseItem != null)
{
responseItem.Description += string.Format(
", {0} (ModuleID={1})", dr["ModuleTitle"], moduleId);
}
}
else
{
if (responseItem != null)
{
responseItem.Description += string.Format(", {0}", dr["ModuleTitle"]);
}
}
}
pageIdPrev = pageId;
}
}
finally
{
dr.Close(); // by Manu, fixed bug 807858
}
if (pageIdPrev != -1)
{
colItems.Add(responseItem);
}
return colItems;
}
/// <summary>
/// Call local or external service
/// </summary>
/// <param name="portalId">
/// The portal ID.
/// </param>
/// <param name="userId">
/// The user ID.
/// </param>
/// <param name="applicationFullPath">
/// The application full path.
/// </param>
/// <param name="requestInfo">
/// a filled ServiceRequestInfo class
/// </param>
/// <param name="appleseedPage">
/// The Appleseed page.
/// </param>
/// <returns>
/// ServiceResponseInfo
/// </returns>
public static ServiceResponseInfo CallService(
int portalId,
Guid userId,
string applicationFullPath,
ref ServiceRequestInfo requestInfo,
Page appleseedPage)
{
var responseInfo = new ServiceResponseInfo { ServiceStatus = string.Empty };
if (requestInfo.Type != ServiceType.RSSService)
{
if (portalId < 0)
{
if (!GetPortalIDViaAlias(requestInfo.PortalAlias, ref portalId, appleseedPage))
{
responseInfo.ServiceStatus += "WARNING! Unknown PortalAlias";
}
}
if (userId != Guid.Empty)
{
// TBD!!
// Note: should be controlled by key in appSettings:
// <add key="AllowRSSServiceSignin" value="false" />
// <add key="AllowWebServiceSignin" value="false" />
// userID = GetUserID(requestInfo.UserName, requestInfo.UserPassword);
/* Jakob says: later
if (requestInfo.UserName == string.Empty)
userID = -1;
else
{
Appleseed.Framework.Security.User user;
UsersDB usersDB = new UsersDB();
user = usersDB.Login(requestInfo.UserName, requestInfo.UserPassword, portalID);
if (user != null)
userID = int.Parse(user.ID.ToString());
else
userID = -1;
}
*/
}
if (requestInfo.LocalMode)
{
if (appleseedPage != null)
{
responseInfo.ServiceTitle = appleseedPage.PortalSettings.PortalName;
responseInfo.ServiceLink = Path.ApplicationFullPath;
responseInfo.ServiceDescription = appleseedPage.PortalSettings.PortalTitle;
responseInfo.ServiceImageTitle = appleseedPage.PortalSettings.PortalTitle;
responseInfo.ServiceImageUrl = Path.ApplicationFullPath +
appleseedPage.PortalSettings.PortalPath + "/logo.gif";
responseInfo.ServiceImageLink = Path.ApplicationFullPath;
}
else
{
responseInfo.ServiceTitle = "ServiceTitle TBD!"; // JLH!!
responseInfo.ServiceLink = Path.ApplicationFullPath;
responseInfo.ServiceDescription = "ServiceDescription TBD!";
responseInfo.ServiceImageTitle = "ImageTitle TBD!";
responseInfo.ServiceImageUrl = Path.ApplicationFullPath + "_Appleseed/logo.gif"; // JLH!! TBD!
responseInfo.ServiceImageLink = Path.ApplicationFullPath;
}
}
}
// For test
// responseInfo.ServiceStatus = "TEST: UserID=" + userID + " PortalID=" + portalID + " LocalMode=" + requestInfo.LocalMode;
try
{
switch (requestInfo.Type)
{
case ServiceType.CommunityWebService:
if (requestInfo.LocalMode)
{
// Run local code (not calling service via http/soap)
responseInfo.Items = GetResponseItemList(
portalId, userId, applicationFullPath, ref requestInfo);
if (responseInfo.ServiceStatus == string.Empty)
{
responseInfo.ServiceStatus = "OK";
}
}
else
{
responseInfo = CallCommunityService(requestInfo, "CommunityService.asmx");
}
responseInfo.ServiceDescription += " (" + requestInfo.ListType + "List WebService)";
break;
case ServiceType.CommunityRSSService:
if (requestInfo.LocalMode)
{
switch (requestInfo.ListType)
{
case ServiceListType.Tab:
responseInfo.Items = GetResponseTabList(
portalId, userId, Path.ApplicationFullPath, ref requestInfo);
break;
case ServiceListType.Module:
responseInfo.Items = GetResponseModuleList(
portalId, userId, Path.ApplicationFullPath, ref requestInfo);
break;
case ServiceListType.Item:
responseInfo.Items = GetResponseItemList(
portalId, userId, Path.ApplicationFullPath, ref requestInfo);
break;
}
if (responseInfo.ServiceStatus == string.Empty)
{
responseInfo.ServiceStatus = "OK";
}
}
else
{
var oldUrl = requestInfo.Url;
if (!requestInfo.Url.EndsWith("/"))
{
requestInfo.Url += "/";
}
requestInfo.Url += "CommunityRSS.aspx" + AddRSSRequestParameters(requestInfo);
responseInfo = CallRssService(requestInfo);
requestInfo.Url = oldUrl;
}
responseInfo.ServiceDescription += " (RSS " + requestInfo.ListType + "List Service)";
break;
case ServiceType.RSSService:
responseInfo = CallRssService(requestInfo);
if (responseInfo.ServiceStatus == string.Empty)
{
responseInfo.ServiceStatus = "OK";
}
break;
default:
responseInfo.ServiceStatus = "ERROR! The requested service type is not supported";
break;
}
}
catch (Exception ex)
{
responseInfo.ServiceStatus = "FATAL ERROR! Can not call service. Problem: " + ex.Message;
}
return responseInfo;
}
/// <summary>
/// Gets a list of modules as described in requestInfo
/// </summary>
/// <param name="portalId">
/// Only modules for portalID is returned
/// </param>
/// <param name="userId">
/// User ID. If -1 the user is Anonymous/Guest
/// </param>
/// <param name="applicationFullPath">
/// Full URL path to Appleseed site
/// </param>
/// <param name="requestInfo">
/// a filled ServiceRequestInfo class
/// </param>
/// <returns>
/// ArrayList
/// </returns>
public static List<ServiceResponseInfoItem> GetResponseModuleList(
int portalId, Guid userId, string applicationFullPath, ref ServiceRequestInfo requestInfo)
{
var colItems = new List<ServiceResponseInfoItem>();
ServiceResponseInfoItem responseItem = null;
var select = new StringBuilder(string.Empty, 1000);
select.Append(" SELECT");
if (requestInfo.MaxHits > 0)
{
select.AppendFormat(" TOP {0}", requestInfo.MaxHits);
}
select.Append(" Mod.ModuleID, Mod.ModuleTitle, Mod.ModuleDefID, Mod.ShowMobile, Mod.WorkflowState");
select.Append(" ,Tab.PageID AS PageID");
select.Append(" ,Tab.PageName AS TabName");
select.Append(" ,Tab.ParentPageID AS ParentPageID");
select.Append(" ,GenModDef.GeneralModDefID AS GeneralModDefID");
select.Append(" ,GenModDef.FriendlyName AS FriendlyName");
select.Append(
" FROM rb_Modules Mod, rb_Pages Tab, rb_ModuleDefinitions ModDef, rb_GeneralModuleDefinitions GenModDef");
select.Append(" WHERE");
select.Append(" Tab.AuthorizedRoles like '%All Users%'");
select.Append(" AND Tab.PageID = Mod.PageID");
select.Append(" AND Mod.ModuleDefID = ModDef.ModuleDefID");
select.Append(" AND ModDef.GeneralModDefID = GenModDef.GeneralModDefID");
select.Append(" AND Mod.AuthorizedViewRoles like '%All Users%'");
select.Append(" AND ModDef.PortalID = Tab.PortalID");
select.AppendFormat(" AND Tab.PortalID = {0}", portalId);
if (requestInfo.IDList.Length != 0)
{
if (requestInfo.IDListType == ServiceListType.Tab)
{
select.AppendFormat(" AND Tab.PageID IN ({0})", requestInfo.IDList);
}
if (requestInfo.IDListType == ServiceListType.Module)
{
select.AppendFormat(" AND Mod.ModuleID IN ({0})", requestInfo.IDList);
}
}
if (requestInfo.ModuleType != "All")
{
select.AppendFormat(" AND GenModDef.ClassName = 'Appleseed.DesktopModules.{0}'", requestInfo.ModuleType);
}
if (requestInfo.RootLevelOnly)
{
select.Append(" AND Tab.ParentPageID IS NULL");
}
if (requestInfo.MobileOnly)
{
select.Append(" AND Mod.ShowMobile=1");
}
if (requestInfo.SearchString.Length != 0)
{
select.AppendFormat(" AND Mod.ModuleTitle like '%{0}%'", requestInfo.SearchString);
}
var sortField = "GenModDef.FriendlyName";
if (requestInfo.SortField == "TITLE")
{
sortField = "Mod.ModuleTitle";
}
select.AppendFormat(" ORDER BY {0}", sortField);
select.Append(" ");
select.Append(requestInfo.SortDirection);
var dr = DBHelper.GetDataReader(select.ToString());
try
{
while (dr.Read())
{
responseItem = new ServiceResponseInfoItem();
var pageId = (int)dr["PageID"];
var moduleId = (int)dr["ModuleID"];
if (requestInfo.ShowID)
{
responseItem.Title = string.Format("{0} (ModuleID={1})", dr["ModuleTitle"], moduleId);
responseItem.Description = string.Format(
"Type: {0}, Page: {1} (PageID={2})", dr["FriendlyName"], dr["PageName"], pageId);
}
else
{
responseItem.Title = string.Format("{0} (ModuleID={1})", dr["ModuleTitle"], moduleId);
responseItem.Description = string.Format(
"Type: {0}, Page: {1}", dr["FriendlyName"], dr["PageName"]);
}
responseItem.Link = string.Format("{0}/DesktopDefault.aspx?tabID={1}", applicationFullPath, pageId);
if (requestInfo.PortalAlias.Length != 0)
{
responseItem.Link += string.Format("&Alias={0}", requestInfo.PortalAlias);
}
colItems.Add(responseItem);
}
}
finally
{
dr.Close(); // by Manu, fixed bug 807858
}
return colItems;
}