public static string LoadWidgetTitle(Guid instanceId)
{
CSBooster_DataContext dataContext = new CSBooster_DataContext();
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstanceText_WITs.Where(x => x.INS_ID == instanceId) select widgInstances).FirstOrDefault();
return(widgetInstance.WIT_Title);
}
public static bool SaveWidgetInstanceSettings(Guid instanceId, XmlDocument xmlDocument)
{
CSBooster_DataContext wdc = new CSBooster_DataContext();
int status = wdc.hisp_Widget_SaveInstanceData(instanceId, xmlDocument.OuterXml);
return(status == 0 ? true : false);
}
private void HandleFacebookLogin()
{
var cookie = Authentication.GetSignedCookie("fbs_" + ConfigurationManager.AppSettings["FacebookApplicationId"], ConfigurationManager.AppSettings["FacebookApplicationSecret"]);
if (cookie != null)
{
string jsonProfile = Http.DownloadContent((HttpWebRequest)WebRequest.Create("https://graph.facebook.com/me?locale=en_US&access_token=" + cookie["access_token"]), null);
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var profile = (Dictionary <string, object>)serializer.DeserializeObject(jsonProfile);
string facebookUserId = profile["id"].ToString();
CSBooster_DataContext csb = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var user = csb.hisp_DataObject_GetUserIDByFacebookUserId(facebookUserId).ElementAtOrDefault(0);
if (user != null) // User exists
{
MembershipUser membershipUser = Membership.GetUser(user.USR_ID);
if (membershipUser != null)
{
PerformLogin(membershipUser.UserName);
}
}
else // User doesn't exist
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "LinkFacebookAccount", string.Format("$telerik.$(function() {{ radWinOpen('/Pages/Popups/LinkFacebookAccount.aspx', '{0}', 420, 100, false, null, 'settingsWin') }} );", GuiLanguage.GetGuiLanguage("Shared").GetString("CommandCreateProfile")), true);
}
}
else
{
litLogin.Text = "<fb:login-button perms=\"email\"></fb:login-button>";
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
try
{
this.Rpb.Items[0].Text = GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("TitlePanelHeader");
this.Rpb.Items[1].Text = GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("TitlePanelContent");
this.Rpb.Items[2].Text = GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("TitlePanelFooter");
this.Rpb.Items[3].Text = GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("TitlePanelEditStyle");
}
catch { }
var panelItems = this.Rpb.GetAllItems();
TextBox customStyle = (TextBox)panelItems.ToList().Find(x => x.Value == "CustomStyle").FindControl("TxtStyle");
StylesId = customStyle.ClientID;
LoadTemplates();
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from instances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select instances).FirstOrDefault();
if (!IsPostBack)
{
if (widgetInstance.WTP_ID.HasValue)
{
LoadTemplate(widgetTemplates.Find(x => x.WTP_ID == widgetInstance.WTP_ID.Value));
}
else
{
LoadTemplate(widgetTemplates.Find(x => x.WTP_ID == Constants.DEFAULT_LAYOUTID.ToGuid()));
}
}
}
public bool Save()
{
try
{
string roles = string.Empty;
for (int i = 0; i < RcbVisRoles.Items.Count; i++)
{
string checkboxId = RcbVisRoles.UniqueID + "$i" + i + "$Checkbox";
if (Request.Form[checkboxId] != null)
{
roles += RcbVisRoles.Items[i].Text + Constants.TAG_DELIMITER;
}
}
roles = roles.TrimEnd(Constants.TAG_DELIMITER);
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select widgInstances).FirstOrDefault();
if (!string.IsNullOrEmpty(RblHeadingTag.SelectedValue))
{
widgetInstance.INS_HeadingTag = int.Parse(RblHeadingTag.SelectedValue);
}
else
{
widgetInstance.INS_HeadingTag = null;
}
widgetInstance.INS_IsFixed = CbFixed.Checked;
widgetInstance.INS_ViewRoles = roles;
dataContext.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public static Guid GetCommunityIdFromPage(Guid pageId)
{
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
Guid communityId = (from widgetPage in dataContext.hitbl_Page_PAGs where widgetPage.PAG_ID == pageId select widgetPage.CTY_ID).SingleOrDefault();
return(communityId);
}
private string GetNavigationValue(bool ignoreCache)
{
CSBooster_DataContext csb = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
string CacheKey = string.Format("{0}_{1}_{2}_{3}", NavigationID, CultureHandler.GetCurrentNeutralLanguageCode().ToLower(), udc.UserRole.ToLower(), (int)NavType);
string navXml = Cache[CacheKey] as string;
if (navXml == null || ignoreCache)
{
navXml = "<Tree/>";
var Navi = csb.hisp_Navigation_GetPreChache(NavigationID.ToGuid(), CultureHandler.GetCurrentNeutralLanguageCode(), udc.UserRole).FirstOrDefault();
if (Navi != null)
{
navXml = Navi.NPC_PreCacheXML;
}
navXml = DataAccess.Business.Navigation.TranformXML(navXml, NavType);
Cache.Insert(CacheKey, navXml);
}
UserDataInfo udi = Cache["UID_" + udc.UserID] as UserDataInfo;
if (udi == null || ignoreCache)
{
udi = new UserDataInfo(udc.UserID);
Cache.Insert("UID_" + udc.UserID, udi, null, DateTime.Now.AddMinutes(5), System.Web.Caching.Cache.NoSlidingExpiration);
}
navXml = navXml.Replace("##NEW_MAIL_COUNT##", udi.UnreadMessagesCount.ToString()).Replace("##FRIEND_REQUEST_COUNT##", udi.FriendRequestCount.ToString()).Replace("##ALERT_COUNT##", udi.AlertCount.ToString());
navXml = navXml.Replace("##CURRENT_PAGE##", Server.UrlEncode(Request.Url.PathAndQuery));
return(navXml);
}
public void Reload()
{
CSBooster_DataContext csbDC = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
RepFilterWords.DataSource = csbDC.hitbl_FilterBadWords_FBWs;
RepFilterWords.DataBind();
}
private void LoadCurrent()
{
CSBooster_DataContext csb = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
XElement xmlLanguageNode = null;
litCurrLang.Text = ci.NativeName;
var navStructureRecord = csb.hisp_Navigation_GetNavigationStructureXML(navId).SingleOrDefault();
var navLanguageRecord = csb.hisp_Navigation_GetNavigationLanguageXML(navId, CultureHandler.GetCurrentNeutralLanguageCode()).SingleOrDefault();
XElement xmlStruct = XElement.Parse(navStructureRecord.NST_XMLStruct);
XElement xmlStructNode = (from xmlStructNodes in xmlStruct.Descendants("Node").Where(x => x.Attribute("Value").Value == nodeValue)
select xmlStructNodes).SingleOrDefault();
if (navLanguageRecord != null)
{
XElement xmlLanguage = XElement.Parse(navLanguageRecord.NAV_XMLNames);
xmlLanguageNode = (from xmlLanguageNodes in xmlLanguage.Descendants("Node").Where(x => x.Attribute("Value").Value == nodeValue)
select xmlLanguageNodes).SingleOrDefault();
}
if (xmlLanguageNode != null)
{
litText.Text = xmlLanguageNode.Attribute("Text") != null?xmlLanguageNode.Attribute("Text").Value : string.Empty;
litTooltip.Text = xmlLanguageNode.Attribute("Tooltip") != null?xmlLanguageNode.Attribute("Tooltip").Value : string.Empty;
if (xmlStructNode.Attribute("PredefinedUrl") == null || string.IsNullOrEmpty(xmlStructNode.Attribute("PredefinedUrl").Value))
{
litLink.Text = xmlLanguageNode.Attribute("NavigateUrl") != null?xmlLanguageNode.Attribute("NavigateUrl").Value : string.Empty;
}
else
{
litLink.Text = " Vordefiniert ";
}
}
}
public bool SaveInstanceData(Guid instanceID, string xml)
{
CSBooster_DataContext wdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
int status = wdc.hisp_Widget_SaveInstanceData(instanceID, xml);
return(status == 0 ? true : false);
}
public void OnDeleteClick(object sender, EventArgs e, hitbl_FilterBadWords_FBW WordFilterObject)
{
CSBooster_DataContext csbDC = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
csbDC.hitbl_FilterBadWords_FBWs.Attach(WordFilterObject);
csbDC.hitbl_FilterBadWords_FBWs.DeleteOnSubmit(WordFilterObject);
csbDC.SubmitChanges();
((IReloadable)this.Page).Reload();
}
public static Guid GetCommunityIdFromWidgetInstance(Guid widgetInstanceId)
{
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
Guid communityId = (from widgetInstance in dataContext.hitbl_WidgetInstance_INs
join widgetPage in dataContext.hitbl_Page_PAGs on widgetInstance.INS_PAG_ID equals widgetPage.PAG_ID
where widgetInstance.INS_ID == widgetInstanceId
select widgetPage.CTY_ID).SingleOrDefault();
return(communityId);
}
public bool Save()
{
_4screen.CSB.DataAccess.Business.StyleSettingsWidget styleSettingsWidget = GetStyleSettings();
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from instances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select instances).FirstOrDefault();
if (RcbTemplates.SelectedValue != Constants.DEFAULT_LAYOUTID)
{
dataContext.hisp_WidgetTemplates_ReduceCount(widgetInstance.INS_PAG_ID, widgetInstance.WTP_ID);
var widgetTemplate = (from templates in dataContext.hitbl_WidgetTemplates_WTPs.Where(x => x.WTP_ID == widgetInstance.WTP_ID) select templates).FirstOrDefault();
if (RcbTemplates.SelectedValue != "Custom")
{
if (widgetTemplate != null && !widgetTemplate.WTP_ExplicitInserted)
{
dataContext.hitbl_WidgetTemplates_WTPs.DeleteOnSubmit(widgetTemplate);
}
widgetInstance.WTP_ID = RcbTemplates.SelectedValue.ToGuid();
}
else
{
if (widgetTemplate == null || widgetTemplate.WTP_ExplicitInserted)
{
widgetTemplate = new hitbl_WidgetTemplates_WTP();
widgetTemplate.WTP_ID = Guid.NewGuid();
widgetTemplate.UserID = UserProfile.Current.UserId;
widgetTemplate.WTP_Name = GetRandomName();
widgetTemplate.WTP_ExplicitInserted = false;
widgetTemplate.WTP_Template = styleSettingsWidget.CustomStyle.Replace("widget", "widget_" + widgetTemplate.WTP_Name);
widgetTemplate.WTP_XMLTemplate = styleSettingsWidget.GetXml();
dataContext.hitbl_WidgetTemplates_WTPs.InsertOnSubmit(widgetTemplate);
widgetInstance.WTP_ID = widgetTemplate.WTP_ID;
}
else
{
widgetTemplate.WTP_Template = styleSettingsWidget.CustomStyle.Replace("widget", "widget_" + widgetTemplate.WTP_Name);
widgetTemplate.WTP_XMLTemplate = styleSettingsWidget.GetXml();
}
}
dataContext.SubmitChanges();
dataContext.hisp_WidgetTemplates_IncreaseCount(widgetInstance.INS_PAG_ID, widgetInstance.WTP_ID);
}
else
{
widgetInstance.WTP_ID = Constants.DEFAULT_LAYOUTID.ToGuid();
dataContext.SubmitChanges();
}
return(true);
}
public void Save()
{
CSBooster_DataContext wdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
System.Xml.Linq.XElement xmlData = null;
if (!string.IsNullOrEmpty(_XMLData))
{
xmlData = System.Xml.Linq.XElement.Parse(_XMLData);
}
wdc.hisp_UserMessages_SaveMessage(_MsgID, _UserId, _FromUserID, _TypOfMessage, _Subject, _MsgText, Convert.ToInt32(_IsRead), _ShowInInbox, ShowInOutbox, xmlData);
}
private Dictionary <string, string> LoadFromDB()
{
CSBooster_DataContext cdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
Dictionary <string, string> settings = new Dictionary <string, string>();
foreach (var settingsEntry in cdc.hitbl_Settings_SETs)
{
settings.Add(settingsEntry.SET_Key, settingsEntry.SET_Value);
}
return(settings);
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select widgInstances).FirstOrDefault();
foreach (ListItem item in RblHeadingTag.Items)
{
if (string.IsNullOrEmpty(item.Value))
{
item.Text = GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("LabelWidgetHeadingNo");
break;
}
}
if (widgetInstance.INS_HeadingTag.HasValue)
{
this.RblHeadingTag.SelectedValue = widgetInstance.INS_HeadingTag.ToString();
}
string currentRole = widgetInstance.INS_ViewRoles;
RcbVisRoles.Items.Clear();
RcbVisRoles.AllowCustomText = true;
RcbVisRoles.Text = string.Empty;
RcbVisRoles.Attributes.Add("OnChange", "setComboboxText('" + RcbVisRoles.ClientID + "')");
List <string> roles = new List <string>();
roles.AddRange(Roles.GetAllRoles());
roles.Add("Anonymous");
roles.Sort();
foreach (string role in roles)
{
RadComboBoxItem item = new RadComboBoxItem(role, role);
CheckBox checkbox = new CheckBox();
checkbox.ID = "CheckBox";
checkbox.Text = role;
checkbox.Attributes.Add("onClick", "setComboboxText('" + RcbVisRoles.ClientID + "');StopPropagation(event);");
item.Controls.Add(checkbox);
checkbox.Checked = string.IsNullOrEmpty(currentRole) || currentRole.ToLower().Contains(role.ToLower() + Constants.TAG_DELIMITER) || currentRole.ToLower().EndsWith(role.ToLower());
if (checkbox.Checked)
{
RcbVisRoles.Text += item.Text + ",";
}
RcbVisRoles.Items.Add(item);
}
RcbVisRoles.Text = RcbVisRoles.Text.TrimEnd(new char[] { ',' });
CbFixed.Checked = widgetInstance.INS_IsFixed;
}
public static int GetAlertsUnreadCount(Guid userId)
{
int numberMessages = 0;
CSBooster_DataContext wdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var result = wdc.hisp_UserMessages_GetAlertsUnreadCount(userId).ElementAtOrDefault(0);
if (result != null)
{
numberMessages = result.NumberMessages ?? 0;
}
return(numberMessages);
}
public static int GetInboxUnreadCount(Guid userId, int?groupID)
{
int numberMessages = 0;
CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
var result = wdc.hisp_UserMessages_GetMessagesUnreadCount(userId, groupID).ElementAtOrDefault(0);
if (result != null)
{
numberMessages = result.NumberMessages ?? 0;
}
return(numberMessages);
}
public static bool SaveWidgetTitle(Guid instanceId, string title)
{
try
{
CSBooster_DataContext dataContext = new CSBooster_DataContext();
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstanceText_WITs.Where(x => x.INS_ID == instanceId) select widgInstances).FirstOrDefault();
widgetInstance.WIT_Title = title;
dataContext.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool Save()
{
try
{
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select widgInstances).FirstOrDefault();
widgetInstance.INS_OutputTemplate = HfTemplate.Value.ToNullableGuid();
dataContext.SubmitChanges();
return(true);
}
catch { }
return(false);
}
private void AddNavNode(string nodeText, string nodeValue, string parentNodeValue)
{
Guid currentNavId = new Guid(hidCurrNavID.Value);
CSBooster_DataContext csb = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
hidParentNodeId.Value = parentNodeValue;
//Savte the Current Node in the struct XML
var navStructureRecord = csb.hisp_Navigation_GetNavigationStructureXML(currentNavId).SingleOrDefault();
if (navStructureRecord != null)
{
XElement xmlStruct = XElement.Parse(navStructureRecord.NST_XMLStruct);
var parentNode = (from theNodes in xmlStruct.Descendants("Node").Where(x => x.Attribute("Value").Value == parentNodeValue)
select theNodes).SingleOrDefault();
if (parentNode != null)
{
parentNode.Add(new XElement("Node", new XAttribute("Text", nodeText), new XAttribute("Value", nodeValue)));
}
else
{
//The Parent Node is the Root... add it to the Tree
xmlStruct.Add(new XElement("Node", new XAttribute("Text", nodeText), new XAttribute("Value", nodeValue)));
}
csb.hisp_Navigation_SaveNavigationStructure(currentNavId, null, xmlStruct.ToString());
lbtnG.Text = language.GetString("TooltipNotSynchronized");
lbtnG.CssClass = "icon navnotsynchro";
var navLanguageRecord = csb.hisp_Navigation_GetNavigationLanguageXML(currentNavId, CultureHandler.GetCurrentNeutralLanguageCode()).SingleOrDefault();
if (navLanguageRecord != null)
{
XElement xmlLanguage = XElement.Parse(navLanguageRecord.NAV_XMLNames);
var langNode = (from theLangNodes in xmlLanguage.Descendants("Node").Where(x => x.Attribute("Value").Value == nodeValue)
select theLangNodes).SingleOrDefault();
if (langNode == null)
{
xmlLanguage.Add(new XElement(new XElement("Node", new XAttribute("Text", nodeText), new XAttribute("Value", nodeValue))));
}
else
{
//Should never happen...
langNode.Attribute("Text").Value = nodeText;
}
csb.hisp_Navigation_SaveNavigationLanguage(currentNavId, CultureHandler.GetCurrentNeutralLanguageCode(), xmlLanguage.ToString(), string.Empty);
}
else
{
csb.hisp_Navigation_SaveNavigationLanguage(currentNavId, CultureHandler.GetCurrentNeutralLanguageCode(), "<Tree/>", string.Empty);
}
}
}
public void SetValue(string key, object value)
{
CSBooster_DataContext cdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
cdc.hitbl_Settings_SETs.Single(x => x.SET_Key == key).SET_Value = value.ToString();
cdc.SubmitChanges();
Dictionary <string, string> settings = (Dictionary <string, string>)HttpRuntime.Cache["CSBoosterSettings"];
if (settings != null)
{
settings[key] = value.ToString();
}
}
protected void OnSaveClick(object sender, EventArgs e, hitbl_FilterBadWords_FBW WordFilterObject)
{
if (!string.IsNullOrEmpty(this.TxtWord.Text))
{
CSBooster_DataContext csbDC = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
csbDC.hitbl_FilterBadWords_FBWs.Attach(WordFilterObject);
WordFilterObject.FBW_Word = this.TxtWord.Text;
WordFilterObject.FBW_IsExactMatch = this.CBExact.Checked;
WordFilterObject.FBW_Action = this.DDLAction.SelectedValue;
csbDC.SubmitChanges();
}
}
protected void OnTemplateSaveClick(object sender, EventArgs e)
{
string templateName = RcbTemplates2.Text;
_4screen.CSB.DataAccess.Business.StyleSettingsWidget styleSettingsWidget = GetStyleSettings();
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetTemplate = (from templates in dataContext.hitbl_WidgetTemplates_WTPs.Where(x => x.WTP_Name.ToLower() == templateName.ToLower()) select templates).FirstOrDefault();
if (widgetTemplate == null)
{
widgetTemplate = new hitbl_WidgetTemplates_WTP();
widgetTemplate.WTP_ID = Guid.NewGuid();
if (ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("Page") || ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("ProfileCommunity"))
{
widgetTemplate.UserID = UserProfile.Current.UserId;
}
else if (ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("Community"))
{
widgetTemplate.UserID = ParentDataObject.ObjectID;
}
widgetTemplate.WTP_Name = templateName;
widgetTemplate.WTP_ExplicitInserted = true;
widgetTemplate.WTP_Template = styleSettingsWidget.CustomStyle.Replace("widget", "widget_" + widgetTemplate.WTP_Name);
widgetTemplate.WTP_XMLTemplate = styleSettingsWidget.GetXml();
dataContext.hitbl_WidgetTemplates_WTPs.InsertOnSubmit(widgetTemplate);
dataContext.SubmitChanges();
//this.LitStatus.Text = string.Format("<div class=\"CSB_wiz_msg\">{0}</div>", GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("MessageStyleSaved"));
LoadTemplates();
LoadTemplate(widgetTemplate);
}
else
{
if (((ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("Page") || ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("ProfileCommunity")) && widgetTemplate.UserID == UserProfile.Current.UserId) ||
(ParentDataObject.ObjectType == Helper.GetObjectTypeNumericID("Community")) && widgetTemplate.UserID == ParentDataObject.ObjectID ||
UserDataContext.GetUserDataContext().IsAdmin)
{
widgetTemplate.WTP_Template = styleSettingsWidget.CustomStyle.Replace("widget", "widget_" + widgetTemplate.WTP_Name);
widgetTemplate.WTP_XMLTemplate = styleSettingsWidget.GetXml();
dataContext.SubmitChanges();
//this.LitStatus.Text = string.Format("<div class=\"CSB_wiz_msg\">{0}</div>", GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("MessageStyleSaved"));
LoadTemplates();
LoadTemplate(widgetTemplate);
}
else
{
//this.LitStatus.Text = string.Format("<div class=\"CSB_wiz_msg\">{0}</div>", GuiLanguage.GetGuiLanguage("UserControls.WebUI.Base").GetString("ErrorMessageStyleNotSaved"));
}
}
}
public static XmlDocument LoadWidgetInstanceSettings(Guid instanceId)
{
CSBooster_DataContext wdc = new CSBooster_DataContext();
string xml = wdc.hisp_Widget_LoadInstanceData(instanceId).ElementAtOrDefault(0).INS_XmlStateData;
XmlDocument xmlDocument = new XmlDocument();
if (!string.IsNullOrEmpty(xml))
{
xmlDocument.LoadXml(xml);
}
else
{
XmlHelper.CreateRoot(xmlDocument, "root");
}
return(xmlDocument);
}
public void Load(Guid msgId)
{
try
{
CSBooster_DataContext wdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var result = wdc.hisp_UserMessages_GetMessage(msgId).ElementAtOrDefault(0);
if (result != null)
{
FillMessage(this, result);
}
}
catch
{
}
}
public static List <Message> GetAlerts(Guid userId, DateTime?dateSentFrom, DateTime?dateSentTo, bool?flagged, bool?isRead, string generalSearchParam, string fromUserName, string subject, string message, int?pageNum, int?pageSize, string sortAttr, string sortDir, out int numberMessages, SiteContext siteContext)
{
List <Message> listMsg = new List <Message>();
int? NumberMessages = null;
CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
var results = wdc.hisp_UserMessages_GetAlerts(userId, dateSentFrom, dateSentTo, flagged, isRead, "%" + fromUserName + "%", "%" + subject + "%", "%" + message + "%", "%" + generalSearchParam + "%", pageNum ?? 1, pageSize ?? 10, sortAttr, sortDir, ref NumberMessages);
foreach (MessageResult result in results)
{
Message newMessage = new Message(siteContext);
Message.FillMessage(newMessage, result);
listMsg.Add(newMessage);
}
numberMessages = NumberMessages ?? 0;
return(listMsg);
}
public static List <Message> GetRequestOutbox(Guid userId, int?pageNum, int?pageSize, out int numberItems, SiteContext siteContext)
{
List <Message> listMsg = new List <Message>();
int? NumberMessages = null;
CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
var results = wdc.hisp_UserMessages_GetRequestUserOutbox(userId, pageNum ?? 1, pageSize ?? 10, ref NumberMessages);
foreach (MessageResult result in results)
{
Message newMessage = new Message(siteContext);
Message.FillMessage(newMessage, result);
listMsg.Add(newMessage);
}
numberItems = NumberMessages ?? 0;
return(listMsg);
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
CSBooster_DataContext dataContext = new CSBooster_DataContext(Helper.GetSiemeConnectionString());
var widgetInstance = (from widgInstances in dataContext.hitbl_WidgetInstance_INs.Where(x => x.INS_ID == InstanceId) select widgInstances).FirstOrDefault();
currentTemplateId = widgetInstance.INS_OutputTemplate;
HfTemplate.Value = currentTemplateId.ToString();
List <Guid> outputTemplateIds = WidgetSection.CachedInstance.Widgets[widgetInstance.WDG_ID].OutputTemplates.Split(';').ToList().ConvertAll(value => new Guid(value));
var outputTemplates = OutputTemplatesSection.CachedInstance.Templates.LINQEnumarable.Where(x => outputTemplateIds.Contains(x.Id));
RepTemplates.DataSource = outputTemplates;
RepTemplates.DataBind();
}
public void Load(Guid msgId)
{
try
{
CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
var result = wdc.hisp_UserMessages_GetMessage(msgId).ElementAtOrDefault(0);
if (result != null)
{
FillMessage(this, result);
}
}
catch
{
}
}
