public static List <BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
private void GetWidgets() { try { short sState = -1; if (!short.TryParse(Request["state"], out sState)) { sState = -1; } bool bVisible = sState == 1; if (sState == 1 || sState == 0) { gvWidgets.DataSource = BSWidget.GetWidgets(bVisible); } else { gvWidgets.DataSource = BSWidget.GetWidgets(); } gvWidgets.DataBind(); } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
protected void lbDelete_Click(object sender, EventArgs e) { try { bool bRemove = false; for (int i = 0; i < gvWidgets.Rows.Count; i++) { CheckBox cb = gvWidgets.Rows[i].FindControl("cb") as CheckBox; if (cb.Checked) { Literal literal = gvWidgets.Rows[i].FindControl("WidgetID") as Literal; if (literal != null) { int iWidgetID = Convert.ToInt32(literal.Text); BSWidget bsWidget = BSWidget.GetWidget(iWidgetID); bRemove = bsWidget != null && bsWidget.Remove(); } } } if (bRemove) { MessageBox1.Message = Language.Admin["WidgetDeleted"]; MessageBox1.Type = MessageBox.ShowType.Information; MessageBox1.Visible = true; } GetWidgets(); GetAllWidgets(); } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
public static List <BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static void OnSaved(BSWidget bsWidget, EventArgs e) { if (Saved != null) { Saved(bsWidget, e); } }
public static List <BSWidget> GetWidgetsBySorted() { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static void OnSaving(BSWidget bsWidget, CancelEventArgs e) { if (Saving != null) { Saving(bsWidget, e); } }
public static void OnDeleting(BSWidget bsWidget, CancelEventArgs e) { if (Deleting != null) { Deleting(bsWidget, e); } }
public static void OnDeleted(BSWidget bsWidget, EventArgs e) { if (Deleted != null) { Deleted(bsWidget, e); } }
protected override void OnInit(EventArgs e) { //Widget Preview if (HttpContext.Current.Request["widget"] != null && this.ID.Equals("Default")) { using (PlaceHolder ph = (PlaceHolder)BSHelper.FindChildControl(Page, "Default")) ph.Controls.Add(Page.LoadControl("~/Widgets/" + BSHelper.CreateCode(HttpContext.Current.Request["widget"]) + "/" + "Widget.ascx")); } List <BSWidget> widgets = BSWidget.GetWidgetsByPlaceHolder(this.ID, true); if (widgets.Count > 0) { foreach (BSWidget widget in widgets) { PlaceHolder ph = (PlaceHolder)BSHelper.FindChildControl(Page, widget.PlaceHolder); if (ph != null) { WidgetBase wb = (WidgetBase)Page.LoadControl(Templates.Widget); wb.Widget = widget; wb.DataBind(); ph.Controls.Add(wb); } } } base.OnInit(e); }
protected void rpAllWidgets_ItemCommand(object source, RepeaterCommandEventArgs e) { try { if (e.CommandName == "Add") { Hashtable hT = new Hashtable(); string folderName = e.CommandArgument.ToString(); XmlDocument xDoc = new XmlDocument(); xDoc.Load(Server.MapPath("~/Widgets/" + folderName + "/Widget.xml")); XmlNode node = xDoc.SelectSingleNode("//widget/title"); if (node != null) { string title = node.InnerText; XmlNode xnType = xDoc.SelectSingleNode("//widget/type"); string strError = string.Empty; bool bSaved = false; if (xnType == null || (!xnType.InnerText.ToLower().Equals("page"))) { BSWidget bsWidget = new BSWidget(); bsWidget.Title = title; bsWidget.FolderName = folderName; bsWidget.Type = 0; bsWidget.Sort = (short)(gvWidgets.Rows.Count + 1); bsWidget.PlaceHolder = "Default"; bsWidget.Visible = true; bSaved = bsWidget.Save(); } else if (xnType.InnerText.ToLower().Equals("page")) { strError = Language.Admin["NotSideBarWidget"]; } if (bSaved) { MessageBox1.Message = Language.Admin["WidgetAdded"]; MessageBox1.Type = MessageBox.ShowType.Information; } else { MessageBox1.Message = strError; MessageBox1.Type = MessageBox.ShowType.Error; } } GetWidgets(); GetAllWidgets(); } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
private static void FillWidget(IDataReader dr, BSWidget bsWidget) { bsWidget.WidgetID = Convert.ToInt32(dr["WidgetID"]); bsWidget.PlaceHolder = dr["PlaceHolder"].ToString(); bsWidget.FolderName = dr["FolderName"].ToString(); bsWidget.Title = dr["Title"].ToString(); bsWidget.Description = dr["Description"].ToString(); bsWidget.Type = (WidgetTypes)(short)dr["Type"]; bsWidget.Sort = Convert.ToInt16(dr["Sort"]); bsWidget.Visible = Convert.ToBoolean(dr["Visible"]); bsWidget.SiteID = Convert.ToInt32(dr["SiteID"]); bsWidget.LanguageCode = Convert.ToString(dr["LanguageCode"]); }
protected void btnSaveWidget_Click(object sender, EventArgs e) { try { BSWidget bsWidget = new BSWidget(); bsWidget.Title = txtTitle.Text; bsWidget.Description = tmceDescription.Content; bsWidget.Visible = Convert.ToBoolean(ddlVisible.SelectedValue); bsWidget.PlaceHolder = ddlPlace.SelectedValue; MessageBox1.Type = MessageBox.ShowType.Error; if (Request["p"] != null && Request["p"] == "AddWidget") { bsWidget.Type = WidgetTypes.Page; if (bsWidget.Save()) { Response.Redirect("Widgets.aspx?Message=1"); } else { MessageBox1.Message = "Error"; } } else { bsWidget = BSWidget.GetWidget(Convert.ToInt32(Request["WidgetID"])); if (!divWidgetContent.Visible) { bsWidget.Description = string.Empty; } if (bsWidget.Save()) { Response.Redirect("Widgets.aspx?Message=1"); } else { MessageBox1.Message = "Error"; } } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
public static string GetWidgets() { string value = ""; List <BSWidget> widgets = BSWidget.GetWidgetsBySorted(); if (widgets != null && widgets.Count > 0) { foreach (BSWidget widget in widgets) { value += "<li id='" + widget.WidgetID + "'>" + widget.Title + "</li>"; } } return(value); }
protected void btnSaveWidget_Click(object sender, EventArgs e) { try { BSWidget bsWidget; MessageBox1.Type = MessageBox.ShowType.Error; if ("AddWidget".Equals(Request["p"])) { bsWidget = new BSWidget(); bsWidget.Title = txtTitle.Text; bsWidget.Description = tmceDescription.Content; bsWidget.Visible = Convert.ToBoolean(ddlVisible.SelectedValue); bsWidget.PlaceHolder = ddlPlace.SelectedValue; bsWidget.LanguageCode = Blogsa.CurrentBlogLanguage; bsWidget.Type = WidgetTypes.Page; if (bsWidget.Save()) Response.Redirect("Widgets.aspx?Message=1"); else MessageBox1.Message = "Error"; } else { bsWidget = BSWidget.GetWidget(Convert.ToInt32(Request["WidgetID"])); if (!divWidgetContent.Visible) bsWidget.Description = string.Empty; else { bsWidget.Title = txtTitle.Text; bsWidget.Description = tmceDescription.Content; } if (bsWidget.Save()) Response.Redirect("Widgets.aspx?Message=1"); else MessageBox1.Message = "Error"; } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
protected void Page_Load(object sender, EventArgs e) { string widget = Request["w"]; if (!string.IsNullOrEmpty(widget)) { widget = BSHelper.CreateCode(widget); BSWidget bsWidget = BSWidget.GetWidget(widget); if (bsWidget != null) { phWidget.Controls.Add(LoadControl("~/Widgets/" + bsWidget.FolderName + "/View.ascx")); } else if (BSTheme.Current.Widgets[widget] != null) { BSWidget w = BSTheme.Current.Widgets[widget]; phWidget.Controls.Add(LoadControl(String.Format("~/Themes/{0}/Widgets/{1}/View.ascx", Blogsa.ActiveTheme, w.FolderName))); } } }
public static BSWidget GetWidget(string folderName) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("FolderName", folderName); dp.ExecuteReader("SELECT * FROM Widgets WHERE [FolderName]=@FolderName"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); return(bsWidget); } } } } return(null); }
private void VisibleUnVisible(bool bVisible) { try { bool bDone = false; for (int i = 0; i < gvWidgets.Rows.Count; i++) { CheckBox cb = gvWidgets.Rows[i].FindControl("cb") as CheckBox; if (cb.Checked) { Literal literal = gvWidgets.Rows[i].FindControl("WidgetID") as Literal; if (literal != null) { int iWidgetID = Convert.ToInt32(literal.Text); BSWidget bsWidget = BSWidget.GetWidget(iWidgetID); if (bsWidget != null) { bsWidget.Visible = bVisible; bDone = bsWidget.Save(); } } } } if (bDone) { MessageBox1.Message = bVisible ? Language.Admin["BeActive"] : Language.Admin["BePassive"]; MessageBox1.Type = MessageBox.ShowType.Information; MessageBox1.Visible = true; } GetWidgets(); } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
public static List <BSWidget> GetWidgets() { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.ExecuteReader("SELECT * FROM [Widgets] ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
protected void gvWidgets_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "UD") { string[] values = e.CommandArgument.ToString().Split('|'); int val = -1; if (values[0] == "U") { val = -1; } else { val = +1; } int iWidgetID = Convert.ToInt32(values[1]); BSWidget bsWidget = BSWidget.GetWidget(iWidgetID); bsWidget.Sort += (short)val; if (bsWidget.Save()) { MessageBox1.Type = MessageBox.ShowType.Error; MessageBox1.Message = "Error"; } GetWidgets(); } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
protected void Page_Load(object sender, EventArgs e) { try { GenerateHeaderButtons(); if (!Page.IsPostBack) { GetWidgets(); GetAllWidgets(); ddlVisible.Items.Add(new ListItem(Language.Admin["Active"], "True")); ddlVisible.Items.Add(new ListItem(Language.Admin["Passive"], "False")); string fileName = Server.MapPath("~/Themes/" + Blogsa.Settings["theme"] + "/Settings.xml"); string temp = BSHelper.GetXmlSingleNodeValue(fileName, "//theme//places"); if (temp.Trim() != "") { string[] strPlaceHolders = temp.Split(','); foreach (string t in strPlaceHolders) { ddlPlace.Items.Add(t); } } else { ddlPlace.Items.Add("Default"); } if (Request["WidgetID"] != null) { divEditWidget.Visible = true; divEditWidgetSide.Visible = true; int iWidgetID = 0; int.TryParse(Request["WidgetID"], out iWidgetID); BSWidget bsWidget = BSWidget.GetWidget(iWidgetID); if (bsWidget != null) { txtTitle.Text = bsWidget.Title; tmceDescription.Content = bsWidget.Description; if (bsWidget.Type == WidgetTypes.Page) { divWidgetContent.Visible = true; } ddlVisible.SelectedValue = bsWidget.Visible.ToString(); ddlPlace.SelectedValue = bsWidget.PlaceHolder; } else { Response.Redirect("Widgets.aspx"); } } else if (Request["p"] != null && Request["p"] == "AddWidget") { divEditWidget.Visible = true; divEditWidgetSide.Visible = true; divWidgetContent.Visible = true; } else { divWidgets.Visible = true; divWidgetsSide.Visible = true; } } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
protected void rpAllWidgets_ItemCommand(object source, RepeaterCommandEventArgs e) { try { if (e.CommandName == "Add") { Hashtable hT = new Hashtable(); string folderName = e.CommandArgument.ToString(); XmlDocument xDoc = new XmlDocument(); xDoc.Load(Server.MapPath("~/Widgets/" + folderName + "/Widget.xml")); XmlNode node = xDoc.SelectSingleNode("//widget/title"); if (node != null) { string title = node.InnerText; XmlNode xnType = xDoc.SelectSingleNode("//widget/type"); string strError = string.Empty; bool bSaved = false; if (xnType == null || (!xnType.InnerText.ToLower().Equals("page"))) { BSWidget bsWidget = new BSWidget(); bsWidget.Title = title; bsWidget.FolderName = folderName; bsWidget.Type = 0; bsWidget.Sort = (short)(gvWidgets.Rows.Count + 1); bsWidget.PlaceHolder = "Default"; bsWidget.Visible = true; bSaved = bsWidget.Save(); } else if (xnType.InnerText.ToLower().Equals("page")) strError = Language.Admin["NotSideBarWidget"]; if (bSaved) { MessageBox1.Message = Language.Admin["WidgetAdded"]; MessageBox1.Type = MessageBox.ShowType.Information; } else { MessageBox1.Message = strError; MessageBox1.Type = MessageBox.ShowType.Error; } } GetWidgets(); GetAllWidgets(); } } catch (Exception ex) { MessageBox1.Message = ex.Message; MessageBox1.Type = MessageBox.ShowType.Error; } }
public static BSWidget GetWidget(string folderName) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("FolderName", folderName); dp.ExecuteReader("SELECT * FROM Widgets WHERE [FolderName]=@FolderName"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); return bsWidget; } } } } return null; }
public static List<BSWidget> GetWidgets() { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.ExecuteReader("SELECT * FROM [Widgets] ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSWidget> GetWidgetsBySorted() { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }