public List<Advertise> Advertise_GetByTop(string Top, string Where, string Order) { List<Data.Advertise> list = new List<Data.Advertise>(); using (SqlCommand dbCmd = new SqlCommand("sp_Advertise_GetByTop", GetConnection())) { Data.Advertise obj = new Data.Advertise(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.AdvertiseIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.Advertise obj = new Data.Advertise(); obj.Id = Id; obj.Name = txtName.Text; obj.Image = txtImage.Text; obj.Width = txtWidth.Text; obj.Height = txtHeight.Text; obj.Link = txtLink.Text; obj.Target = ddlTarget.SelectedValue; obj.Content = ""; obj.Position = ddlPosition.SelectedValue; obj.PageId = "0"; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; obj.Click = "0"; obj.Language = ddlLanguage.SelectedValue; if (Insert == true) { AdvertiseService.Advertise_Insert(obj); } else { AdvertiseService.Advertise_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public List <Advertise> Advertise_GetByAll() { List <Data.Advertise> list = new List <Data.Advertise>(); using (SqlCommand dbCmd = new SqlCommand("sp_Advertise_GetByAll", GetConnection())) { Data.Advertise obj = new Data.Advertise(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); try { if (dr.HasRows) { while (dr.Read()) { list.Add(obj.AdvertiseIDataReader(dr)); } } } catch (Exception) { } finally { if (dr != null) { dr.Close(); } obj = null; } } return(list); }
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; } }
public Advertise AdvertiseIDataReader(IDataReader dr) { Data.Advertise obj = new Data.Advertise(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.Width = (dr["Width"] is DBNull) ? string.Empty : dr["Width"].ToString(); obj.Height = (dr["Height"] is DBNull) ? string.Empty : dr["Height"].ToString(); obj.Link = (dr["Link"] is DBNull) ? string.Empty : dr["Link"].ToString(); obj.Target = (dr["Target"] is DBNull) ? string.Empty : dr["Target"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString(); obj.PageId = (dr["PageId"] is DBNull) ? string.Empty : dr["PageId"].ToString(); obj.Click = (dr["Click"] is DBNull) ? string.Empty : dr["Click"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); return(obj); }
public List<Advertise> Advertise_GetByAll() { List<Data.Advertise> list = new List<Data.Advertise>(); using (SqlCommand dbCmd = new SqlCommand("sp_Advertise_GetByAll", GetConnection())) { Data.Advertise obj = new Data.Advertise(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.AdvertiseIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.Advertise obj = new Data.Advertise(); obj.Id = Id; obj.Name = txtName.Text; obj.Image = txtImage.Text; obj.Width = txtWidth.Text; obj.Height = txtHeight.Text; obj.Link = txtLink.Text; obj.Target = txtTarget.Text; obj.Content = fckContent.Value; obj.Position = cboPosition.SelectedValue; obj.Click = txtClick.Text; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; obj.PageLinkId = ddlPageLink.SelectedValue; if (Insert == true) { AdvertiseService.Advertise_Insert(obj); } else { AdvertiseService.Advertise_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public Advertise AdvertiseIDataReader(IDataReader dr) { Data.Advertise obj = new Data.Advertise(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
public List<Advertise> Advertise_Paging(string CurentPage, string PageSize) { List<Data.Advertise> list = new List<Data.Advertise>(); using (SqlCommand dbCmd = new SqlCommand("sp_Advertise_Paging", GetConnection())) { Data.Advertise obj = new Data.Advertise(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage)); dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.AdvertiseIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }