GIF89;a GIF89;a using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using DataLayer; public partial class WebAdmin_Adminbanners : BasePage { private string typebanners = string.Empty; private string Place = string.Empty; private string Size = string.Empty; private string NameSite = string.Empty; protected void Page_Load(object sender, EventArgs e) { if (!(Page.IsPostBack)) { GetNameBanners(); } } protected DataSet GetNameBanners() { DataLayer.Banners dal = new DataLayer.Banners(); DataSet ds = new DataSet(); ds = dal.GetBaners(); gridBanners.DataSource = ds; gridBanners.DataBind(); return ds; } protected void gridBanners_CancelCommand(object source, DataGridCommandEventArgs e) { gridBanners.EditItemIndex = -1; GetNameBanners(); } protected void gridBanners_DeleteCommand(object source, DataGridCommandEventArgs e) { DataLayer.Banners dal = new DataLayer.Banners(); dal.DeleteBanersSelected((int)gridBanners.DataKeys[e.Item.ItemIndex]); GetNameBanners(); } protected void gridBanners_EditCommand(object source, DataGridCommandEventArgs e) { gridBanners.EditItemIndex = e.Item.ItemIndex; GetNameBanners(); } protected void gridBanners_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "NewRow") { AddEmptyRow(); } if (e.CommandName == "View") { string url = string.Format(@"~\Admin\Logbanners.aspx?id={0}", gridBanners.DataKeys[e.Item.ItemIndex].ToString()); Response.Redirect(url); } if ((e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)) { typebanners = ((Label)gridBanners.Items[e.Item.ItemIndex].FindControl("lblBannerType")).Text; Size = ((Label)gridBanners.Items[e.Item.ItemIndex].FindControl("lblSize")).Text; Place = ((Label)gridBanners.Items[e.Item.ItemIndex].FindControl("lblPlace")).Text; } } protected void AddEmptyRow() { DataSet m_ds = new DataSet(); m_ds = GetNameBanners(); DataRow dr = m_ds.Tables[0].NewRow(); dr["ad_id"] = -1; dr["Priority"] = 10; m_ds.Tables[0].Rows.Add(dr); gridBanners.EditItemIndex = m_ds.Tables[0].Rows.Count - 1; gridBanners.DataBind(); } protected DataSet GetTypeName() { DataSet ds = new DataSet(); DataLayer.Banners bannersType = new DataLayer.Banners(); ds = bannersType.GetBannersType(); return ds; } protected void gridBanners_ItemDataBound(object sender, DataGridItemEventArgs e) { if (e.Item.ItemType == ListItemType.EditItem) { DataSet m_drops = new DataSet(); m_drops = GetTypeName(); DropDownList ddlType = (DropDownList)e.Item.FindControl("txtBannerType"); ddlType.DataValueField = "ID"; ddlType.DataTextField = "BannerType"; ddlType.DataSource = m_drops.Tables[0].DefaultView; ddlType.DataBind(); for (int i = 0; i < ddlType.Items.Count; i++) { if (ddlType.Items[i].Text == typebanners) { ddlType.SelectedIndex = i; } } DropDownList ddlSize = new DropDownList(); ddlSize = (DropDownList)e.Item.FindControl("ddlSize"); ListItem item = new ListItem("Small", "1"); ddlSize.Items.Add(item); ListItem item2 = new ListItem("Medium", "2"); ddlSize.Items.Add(item2); ListItem item1 = new ListItem("Large", "3"); ddlSize.Items.Add(item1); for (int i = 0; i < ddlSize.Items.Count; i++) { if (ddlSize.Items[i].Text == Size) { ddlSize.SelectedIndex = i; } } DropDownList ddlPlace = new DropDownList(); ddlPlace = (DropDownList)e.Item.FindControl("dllPlace"); ListItem itemPlace = new ListItem("Bottom left", "1"); ddlPlace.Items.Add(itemPlace); ListItem itemPlace1 = new ListItem("Bottom right", "2"); ddlPlace.Items.Add(itemPlace1); ListItem itemPlace2 = new ListItem("Bottom center", "3"); ddlPlace.Items.Add(itemPlace2); for (int i = 0; i < ddlPlace.Items.Count; i++) { if (ddlPlace.Items[i].Text == Place) { ddlPlace.SelectedIndex = i; } } if ((int)gridBanners.DataKeys[e.Item.ItemIndex] == -1) { ((RequiredFieldValidator)e.Item.FindControl("Requiredfieldvalidator3")).Enabled = true; ((Label)e.Item.FindControl("lblImageEdit")).Visible = false; } else { ((RequiredFieldValidator)e.Item.FindControl("Requiredfieldvalidator3")).Enabled = false; ((Label)e.Item.FindControl("lblImageEdit")).Visible = true; } } } protected void gridBanners_UpdateCommand(object source, DataGridCommandEventArgs e) { DataLayer.Banners dal = new DataLayer.Banners(); string path = Server.MapPath("~/Banners/"); string[] param = new string[7]; string p_size = string.Empty; string p_place = string.Empty; param[0] = gridBanners.DataKeys[e.Item.ItemIndex].ToString(); p_size = ((DropDownList)e.Item.FindControl("ddlSize")).SelectedItem.Text; p_place = ((DropDownList)e.Item.FindControl("dllPlace")).SelectedItem.Text; param[1] = ((DropDownList)e.Item.FindControl("txtBannerType")).SelectedValue; param[2] = ((TextBox)e.Item.FindControl("txtLink")).Text; param[3] = ((TextBox)e.Item.FindControl("txtPriority")).Text; if (param[0] == "-1") { param[4] = ((FileUpload)e.Item.FindControl("txtLoad")).FileName; ((FileUpload)e.Item.FindControl("txtLoad")).SaveAs(path + ((FileUpload)e.Item.FindControl("txtLoad")).FileName); } else { if (((FileUpload)e.Item.FindControl("txtLoad")).FileName == string.Empty) { param[4] = ((Label)e.Item.FindControl("lblImageEdit")).Text; } else { param[4] = ((FileUpload)e.Item.FindControl("txtLoad")).FileName; ((FileUpload)e.Item.FindControl("txtLoad")).SaveAs(path + ((FileUpload)e.Item.FindControl("txtLoad")).FileName); } } param[5] = ((TextBox)e.Item.FindControl("txtTooltip")).Text; param[6] = ((TextBox)e.Item.FindControl("txtExpireddate")).Text; dal.UpdateBanners(Convert.ToInt32(param[0]), p_size, p_place, Convert.ToInt32(param[1]), param[2], Convert.ToInt32(param[3]), param[4], param[5],Convert.ToDateTime(param[6])); gridBanners.EditItemIndex = -1; gridBanners.SelectedIndex = -1; GetNameBanners(); } protected string FormatDate(string p_date) { if (p_date.Length == 0) return ""; DateTime d = Convert.ToDateTime(p_date); return d.ToShortDateString(); } public string GetDeleteAlert() { return GetGlobalResourceObject("Common", "DeleteAlert").ToString(); } }