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;
}
public static void OnDeleted(BSWidget bsWidget, EventArgs e)
{
if (Deleted != null)
{
Deleted(bsWidget, e);
}
}
public static void OnDeleting(BSWidget bsWidget, CancelEventArgs e)
{
if (Deleting != null)
{
Deleting(bsWidget, e);
}
}
public static void OnSaved(BSWidget bsWidget, EventArgs e)
{
if (Saved != null)
{
Saved(bsWidget, e);
}
}
public static void OnSaving(BSWidget bsWidget, CancelEventArgs e)
{
if (Saving != null)
{
Saving(bsWidget, e);
}
}
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"]);
}
