/// <summary>
/// This is the event, which will be raised when the binding happens.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tb1_DataBinding(object sender, EventArgs e)
{
Label txtdata = (Label)sender;
((TableCell)txtdata.Parent).CssClass = "resizeable cell" + _columnName.Replace("`", "");
txtdata.CssClass = "cellLbl cellLbl" + _columnName.Replace("`", "").Trim();
txtdata.Style["display"] = "block";
txtdata.Style["overflow"] = "hidden";
GridViewRow container = (GridViewRow)txtdata.NamingContainer;
if (DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")) != DBNull.Value)
{
txtdata.Text = DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")).ToString().Replace(" 00:00:00", "");
}
//Shortens the text in the case maxLength was set, and shows the full text in a tooltip
if (_maxTextLength != 0 && txtdata.Text.Length > _maxTextLength)
{
if (customField == "" && !txtdata.Text.StartsWith("<"))
{
txtdata.ToolTip = txtdata.Text.Replace("'", """);
//txtdata.Text = txtdata.Text.Substring(0, _maxTextLength) + "...";
}
}
//makes the adjustment if this field should be customized
if (customField != "")
{
txtdata.Text = string.Format(customField, txtdata.Text);
}
if (replaceField != "")
{
string[] replaceList = replaceField.Split('|');
foreach (string rep in replaceList)
{
string repSource = "";
string repTarget = "";
repSource = rep.Substring(0, rep.IndexOf('='));
repTarget = rep.Substring(rep.IndexOf('=') + 1);
if (repTarget.Contains("Languages2:"))
{
repTarget = Languages2.MyText(repTarget.Replace("Languages2:", ""));
}
if (txtdata.Text == repSource)
{
txtdata.Text = repTarget;
}
}
}
else
{
txtdata.Text = txtdata.Text;
}
}
/// <summary>
/// This is the event that will be raised when the binding to the del button happens.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void DelBtn_DataBinding(object sender, EventArgs e)
{
LinkButton txtdata = (LinkButton)sender;
GridViewRow container = (GridViewRow)txtdata.NamingContainer;
if (DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")) != DBNull.Value)
{
txtdata.CommandArgument = _TblName + "_" + _columnName + "_" + DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")).ToString() + "_" + DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")).ToString();
txtdata.Command += DelBtnDn_Click;
if (replaceField != "")
{
txtdata.OnClientClick = "javascript:return confirm('" + replaceField + "')";
}
else
{
txtdata.OnClientClick = "javascript:return confirm('" + Languages2.MyText("general_Are you sure you want to delete this entry?") + "')";
}
txtdata.ID = "del" + DataBinder.Eval(container.DataItem, _columnName.Replace("`", "")).ToString();
}
}
void ITemplate.InstantiateIn(System.Web.UI.Control container)
{
switch (_templateType)
{
case "TextAreaItem":
Label tb1 = new Label(); //Allocates the new text box object.
tb1.DataBinding += new EventHandler(tb1_DataBinding); //Attaches the data binding event.
container.Controls.Add(tb1); //Adds the newly created textbox to the container.
break;
case "OrderItem":
ImageButton orderBtnUp = new ImageButton();
orderBtnUp.ImageUrl = "images/up.gif";
orderBtnUp.DataBinding += new EventHandler(orderBtnUp_DataBinding);
container.Controls.Add(orderBtnUp);
ImageButton orderBtnDn = new ImageButton();
orderBtnDn.ImageUrl = "images/dn.gif";
orderBtnDn.DataBinding += new EventHandler(orderBtnDn_DataBinding);
container.Controls.Add(orderBtnDn);
Label OrderNum = new Label();
OrderNum.DataBinding += new EventHandler(orderNum_DataBinding);
break;
case "ShowItem":
Literal showShowItem = new Literal();
showShowItem.ID = "ShowLiteral";
container.Controls.Add(showShowItem);
break;
case "DelItem":
LinkButton DelBtn = new LinkButton();
if (customField != "")
{
DelBtn.Text = "<img src=\"" + customField + "\" style=\"border:none;\">";
}
else
{
DelBtn.Text = "<img src=\"images/DelOn.png\" style=\"border:none;\" alt=\"" + Languages2.MyText("general_Delete") + "\" title=\"" + Languages2.MyText("general_Delete") + "\" >";
}
DelBtn.DataBinding += new EventHandler(DelBtn_DataBinding);
container.Controls.Add(DelBtn);
break;
case "EditItem":
HyperLink EditBtn = new HyperLink();
EditBtn.CssClass = "EditUserFancyClass";
if (_title != "")
{
}
else
{
_title = Languages2.MyText("general_Edit");
}
EditBtn.Text = "<img src=\"images/EditOff.png\" style=\"border:none; margin-right:10px;\" onmouseover=\"$(this).parent().parent().prev().children('.hideshowdivclass').show();this.src='images/EditOn.png'\" onmouseout=\"$(this).parent().parent().prev().children('.hideshowdivclass').hide();this.src='images/EditOff.png'\" alt=\"" + Languages2.MyText("general_Edit") + "\" title=\"" + _title + "\">";
EditBtn.DataBinding += new EventHandler(EditBtn_DataBinding);
((TableCell)container).Style["width"] = "30px";
container.Controls.Add(EditBtn);
break;
case "CheckBox":
GraphicalCheckBox CheckBox = new GraphicalCheckBox();
Panel checkPanel = new Panel();
if (replaceField != "")
{
CheckBox.CheckedImg = replaceField;
}
else
{
CheckBox.CheckedImg = "images/SelectOn.png";
}
CheckBox.UncheckedImg = "images/SelectOff.png";
CheckBox.Font.Size = FontUnit.Parse("100%");
CheckBox.Title = Languages2.MyText("general_Select");
CheckBox.DataBinding += new EventHandler(CheckBox_DataBinding);
checkPanel.PreRender += checkPanel_PreRender;
checkPanel.Controls.Add(CheckBox);
container.Controls.Add(checkPanel);
break;
case "CheckFooter":
Label CheckAllLbl = new Label();
string CheckImg = "images/SelectOn.png";
if (replaceField != "")
{
CheckImg = replaceField;
}
CheckAllLbl.Text = "<img src=\"" + CheckImg + "\" style=\"vertical-align:middle\" alt=\"" + Languages2.MyText("general_Select All") + "\" onclick=\"javascript:checkAll()\"> " + Languages2.MyText("general_Select All") + "";
container.Controls.Add(CheckAllLbl);
Label unCheckAllLbl = new Label();
unCheckAllLbl.Text = " <img src=\"images/SelectOff.png\" style=\"vertical-align:middle\" alt=\"" + Languages2.MyText("general_Clear All") + "\" onclick=\"javascript:uncheckAll()\"> " + Languages2.MyText("general_Clear All") + "";
container.Controls.Add(unCheckAllLbl);
break;
case "Header":
LinkButton HeaderBtn = new LinkButton();
TextBox WidthHid = new TextBox();
WidthHid.CssClass = "tableHid tableHid" + customField.Replace("`", "");
WidthHid.Style["display"] = "none";
container.Controls.Add(WidthHid);
HeaderBtn.Font.Underline = false;
HeaderBtn.ForeColor = System.Drawing.Color.White;
HeaderBtn.CommandArgument = customField;
HeaderBtn.Command += HeaderBtn_Click;
HeaderBtn.Text = " " + _columnName + " ";
((TableCell)container).CssClass = "resizeable cell" + customField.Replace("`", "");
HeaderBtn.CssClass = "cellLbl cellLbl" + customField.Replace("`", "").Trim();
HeaderBtn.Style["display"] = "block";
HeaderBtn.Style["overflow"] = "hidden";
container.Controls.Add(HeaderBtn);
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = Languages2.MyText("General_Manage System_מערכת ניהול") + "-" + siteDefaults.SiteName;
bannerRow.CssClass = "bannerRow";
TableCell bannerRowRight = new TableCell();
TableCell bannerRowLeft = new TableCell();
bannerRowRight.CssClass = "bannerRowRight";
bannerRowLeft.CssClass = "bannerRowLeft";
bannerRowRight.Text = " ";
bannerRowLeft.Text = " ";
bannerRow.Cells.Add(bannerRowRight);
if (Request.QueryString["cat"] != null)
{
cat = Request.QueryString["cat"].Replace("'", "''");
}
else
{
Response.Redirect("./");
}
if (Session["SiteID"] == null)
{
Response.Redirect("./");
}
List <adminpages> Getadminpages = adminpages.AdminPagesList.Where(m => m.catParent == int.Parse(cat) && m.secLevel >= int.Parse(Session["secLevel"].ToString())).ToList();
Getadminpages.OrderBy(m => m.catOrder);
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
string sql = "SELECT * FROM adminpages where catparent=" + cat + " AND secLevel>=" + Session["secLevel"] + " ORDER BY catOrder";
MySqlCommand cmd = new MySqlCommand(sql, con);
#region set cat sub of pages links
for (int i = 0; i < Getadminpages.Count; i++)
{
TableCell rightCell = new TableCell();
TableRow rightRow = new TableRow();
rightCell.Text = Getadminpages[i].catText; // MyReader["catText" + langtext].ToString();
if (Getadminpages[i].isHeader == true)
{
rightCell.CssClass = "rightCellHeader";
rightRow.Cells.Add(rightCell);
rightTable.Rows.Add(rightRow);
List <adminpages> Getadminpages2 = adminpages.AdminPagesList.Where(m => m.catParent == Getadminpages[i].catID && m.secLevel >= int.Parse(Session["secLevel"].ToString())).ToList();
Getadminpages2.OrderBy(m => m.catOrder);
for (int j = 0; j < Getadminpages2.Count; j++)
{
rightCell = new TableCell();
rightRow = new TableRow();
rightCell.Text = Getadminpages2[j].catText;// MyReader2["catText" + langtext].ToString();
rightCell.HorizontalAlign = HorizontalAlign.Right;
SetTableLinks(Getadminpages2[j].catLink, Getadminpages2[j].catID, ref rightCell);
rightRow.Cells.Add(rightCell);
rightTable.Rows.Add(rightRow);
}
}
else
{
SetTableLinks(Getadminpages[i].catLink, Getadminpages[i].catID, ref rightCell);
rightRow.Cells.Add(rightCell);
rightTable.Rows.Add(rightRow);
}
}
#endregion
sql = "Select * From languages";
MySqlDataAdapter ad = new MySqlDataAdapter(sql, con);
DataSet ds = new DataSet();
ad.Fill(ds, "myLang");
LangMyDropDown.DataSource = ds.Tables["myLang"].DefaultView;
#region Top cat order
List <adminpages> Getadminpages0 = adminpages.AdminPagesList.Where(m => m.catParent == 0 && m.secLevel >= int.Parse(Session["secLevel"].ToString())).ToList();
Getadminpages0.OrderBy(m => m.catOrder);
TableCell bannerEmptyRight = new TableCell();
TableCell bannerEmptyLeft = new TableCell();
bannerEmptyLeft.CssClass = "bannerEmptyLeft";
bannerEmptyRight.CssClass = "bannerEmptyRight";
bannerRow.Cells.Add(bannerEmptyRight);
for (int i = 0; i < Getadminpages0.Count; i++)
{
TableCell bannerCell = new TableCell();
TableCell bannerLineCell = new TableCell();
bannerCell.Width = 132;
if (Getadminpages0[i].catID.ToString() == Request.QueryString["cat"].ToString())
{
bannerCell.CssClass = "bannerCellSelected";
}
else
{
bannerCell.CssClass = "bannerCell";
}
bannerCell.Text = Getadminpages0[i].catText;// MyReader["catText" + langtext].ToString();
if (Getadminpages0[i].catLink.Length > 0)
{
string admincat = "?cat=";
if (Getadminpages0[i].catLink.Contains("?"))
{
admincat = "&cat=";
}
if (Getadminpages0[i].catID.ToString() == Request.QueryString["cat"].ToString())
{
bannerCell.Text = "<a href=\"" + Getadminpages0[i].catLink + admincat + Getadminpages0[i].catID.ToString() + "\" class=\"bannerSelected\">" + bannerCell.Text + "</a>";
}
else
{
bannerCell.Text = "<a href=\"" + Getadminpages0[i].catLink + admincat + Getadminpages0[i].catID.ToString() + "\" class=\"banner\">" + bannerCell.Text + "</a>";
}
}
bannerLineCell.Width = 5;
bannerLineCell.Text = "<img src=\"images/SearchHeaderLine.jpg\" style=\"border:none\" alt=\"\" />";
bannerRow.Cells.Add(bannerCell);
bannerRow.Cells.Add(bannerLineCell);
}
#endregion
Session.Timeout = 90;
TableCell EmptyCell = new TableCell();
EmptyCell.HorizontalAlign = HorizontalAlign.Left;
EmptyCell.ForeColor = System.Drawing.Color.FromName("#ffffff");
sql = "SELECT * FROM adminsites where siteID=" + Session["siteID"];
cmd.CommandText = sql;
cmd.Connection = con;
MyReader = cmd.ExecuteReader();
if (MyReader.Read())
{
LoginInfoCell.Text = Languages2.MyText("General_Manage Site_אתר מנוהל:") + " <b>" + MyReader["SiteName"].ToString() + "</b><br> " + Languages2.MyText("General_Connected as:_מחובר כ:") + " <b>" + Session["ManUN"].ToString() + "</b>";
LoginInfoCell.Text += "<br>" + Languages2.MyText("General_Last Login_כניסה אחרונה") + ":<b>" + Session["LastLogin"].ToString() + "</b>";
LoginInfoCell.CssClass = "LoginInfoCell";
}
MyReader.Close();
con.Close();
EmptyCell.Text = " ";
bannerRow.Cells.Add(EmptyCell);
bannerRow.Cells.Add(bannerRowLeft);
bannerRow.Cells.Add(bannerEmptyLeft);
bannerTable.Rows.Add(bannerRow);
con.Close();
}
}
