public List <Advertise> Advertise_Get(string Top, string Where, string Order)
{
try
{
List <Advertise> list = new List <Advertise>();
list = AdvertiseBUS.Advertise_GetByTop(Top, Where, Order);
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.Advertise obj = new Data.Advertise();
obj.Name = txtName.Text;
if (txtImage.Text.StartsWith("http://"))
{
string fileExt = Path.GetExtension(txtImage.Text);
WebClient webClient = new WebClient();
if (fileExt.ToLower() == ".gif" || fileExt.ToLower() == ".png" || fileExt.ToLower() == ".jpg" || fileExt.ToLower() == ".jpeg")
{
string urlsave = "/Uploads/Advertise/" + Common.StringClass.RandomString(10) + fileExt;
webClient.DownloadFile(txtImage.Text, Request.PhysicalApplicationPath + urlsave);
obj.Image = urlsave;
}
}
else
{
obj.Image = txtImage.Text;
}
obj.ImageSmall = txtImagesmall.Text;
obj.Summary = txtsummary.Text;
obj.Width = "0";
obj.Height = "0";
obj.Link = txtLink.Text;
obj.Target = ddlTarget.SelectedValue;
obj.ContentDetail = "";
obj.Position = ddlPosition.SelectedValue;
obj.PageId = ddlModule.SelectedValue;
obj.Click = "";
obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1";
obj.Active = chkActive.Checked ? "1" : "0";
obj.Lang = Lang;
if (txtId.Text.Length == 0)
{
obj.Id = Id;
AdvertiseBUS.Advertise_Insert(obj);
}
else
{
obj.Id = txtId.Text;
AdvertiseBUS.Advertise_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
}
}
private void BindGrid()
{
if (ddlFilterPosition.SelectedValue == "" || ddlFilterPosition.SelectedValue == null)
{
grdAdvertise.DataSource = AdvertiseBUS.Advertise_GetByAll(Lang);
}
else
{
grdAdvertise.DataSource = AdvertiseBUS.Advertise_GetByTop("", "Lang='" + Lang + "' and Position=" + ddlFilterPosition.SelectedValue, "Id desc");
}
grdAdvertise.DataBind();
if (grdAdvertise.PageCount <= 1)
{
grdAdvertise.PagerStyle.Visible = false;
}
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
DataGridItem item = default(DataGridItem);
for (int i = 0; i < grdAdvertise.Items.Count; i++)
{
item = grdAdvertise.Items[i];
if (item.ItemType == ListItemType.AlternatingItem | item.ItemType == ListItemType.Item)
{
if (((CheckBox)item.FindControl("ChkSelect")).Checked)
{
string strId = item.Cells[1].Text;
AdvertiseBUS.Advertise_Delete(strId);
}
}
}
grdAdvertise.CurrentPageIndex = 0;
BindGrid();
}
protected void grdAdvertise_ItemCommand(object source, DataGridCommandEventArgs e)
{
string strCA = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "Edit":
Id = strCA;
List <Data.Advertise> listE = AdvertiseBUS.Advertise_GetById(Id);
txtId.Text = strCA;
txtName.Text = listE[0].Name;
txtsummary.Text = listE[0].Summary;
if (listE[0].Image.Length > 0)
{
txtImage.Text = listE[0].Image;
imgImage.Visible = true;
imgImage.ImageUrl = listE[0].Image;
}
if (listE[0].ImageSmall.Length > 0)
{
txtImagesmall.Text = listE[0].Image;
Image1.Visible = true;
Image1.ImageUrl = listE[0].ImageSmall;
}
//else
//{
// trImages.Visible = false;
//}
//txtWidth.Text = listE[0].Width;
//txtHeight.Text = listE[0].Height;
txtLink.Text = listE[0].Link;
ddlTarget.SelectedValue = listE[0].Target;
ddlPosition.SelectedValue = listE[0].Position;
ddlModule.SelectedValue = listE[0].PageId;
txtOrd.Text = listE[0].Ord;
chkActive.Checked = listE[0].Active == "1" || listE[0].Active == "True";
pnView.Visible = false;
pnUpdate.Visible = true;
break;
case "Active":
string strA = "";
string str = e.Item.Cells[2].Text;
strA = str == "1" ? "0" : "1";
SqlDataProvider sql = new SqlDataProvider();
sql.ExecuteNonQuery("Update [Advertise] set Active=" + strA + " Where Id='" + strCA + "'");
BindGrid();
break;
case "Delete":
AdvertiseBUS.Advertise_Delete(strCA);
BindGrid();
break;
case "Image":
Response.Redirect("/Admins/ImagesDetail.aspx?ImagesId=" + strCA + "");
break;
}
}
