protected void BtnModificar_Click(object sender, EventArgs e) { oBanner unBannerModificar = new oBanner(); if (vioImagen) { imagenEditar = imgMuestraEditar.ImageUrl.Substring(imgMuestraEditar.ImageUrl.LastIndexOf("\\") + 1); } //btnVerImagenEditar_Click(sender, e); if (imagenEditar != "") { // Create a name for the file to store if (!vioImagen) { HttpPostedFile myFile = fuImagenEditar.PostedFile; if (myFile.FileName != null & myFile.FileName != "") { int nFileLen = myFile.ContentLength; // Allocate a buffer for reading of the file // make sure the size of the file is > 0 if (nFileLen > 0) { byte[] myData = new byte[nFileLen]; myFile.InputStream.Read(myData, 0, nFileLen); // Create a name for the file to store string strFilename = "\\Banners\\" + Path.GetFileName(myFile.FileName); // Write data into a file WriteToFile(Server.MapPath(strFilename), ref myData); imgMuestraEditar.ImageUrl = ".." + strFilename; //imagen = strFilename.Substring(strFilename.LastIndexOf("\\") + 1); unBannerModificar.imagen = imagenEditar; } } } else { unBannerModificar.imagen = imagenEditar; } } unBannerModificar.id = int.Parse(hId.Value.ToString()); unBannerModificar.nombre = txtNombreEditar.Text; unBannerModificar.columna = ddlColumnaEditar.SelectedValue; unBannerModificar.imagen = imagenEditar; unBannerModificar.activo = chkActivoEditar.Checked; nBanner nBanner = new nBanner(); nBanner.Modificar(unBannerModificar); string sError = cargar_Grilla(); formModificar.Visible = false; vioImagen = false; }
protected void grdBanners_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Editar") { string sError = ""; try { if (int.Parse(e.CommandArgument.ToString()) > 0) { nBanner unBannerN = new nBanner(); oBanner unBannerO = new oBanner(); sError = unBannerN.Buscar_Uno(int.Parse(e.CommandArgument.ToString()), ref unBannerO); hId.Value = unBannerO.id.ToString(); txtNombreEditar.Text = unBannerO.nombre; imgMuestraEditar.ImageUrl = unBannerO.imagen; chkActivoEditar.Checked = unBannerO.activo; ddlColumnaEditar.SelectedValue = unBannerO.columna; txtLinkEditar.Text = unBannerO.link; formModificar.Visible = true; //HtmlGenericControl formModificar = new HtmlGenericControl("formModificar"); //formModificar.FindControl(""); } } catch (Exception ex) { Response.Write("<script type='text/javascript' language='javascript'> alert('" + sError + "');</script>"); } } }
public List <oBanner> Shuffle() { Random rng = new Random(); List <oBanner> list = carga_ListaBanners(); int n = list.Count; while (n > 1) { n--; int k = rng.Next(n + 1); oBanner value = list[k]; list[k] = list[n]; list[n] = value; } return(list); }
protected void btnGuardar_Click(object sender, EventArgs e) { if (imagen != "") { // Create a name for the file to store HttpPostedFile myFile = fuImagen.PostedFile; if (!imagenExiste(imagen)) { if (myFile.FileName != null & myFile.FileName != "") { int nFileLen = myFile.ContentLength; // Allocate a buffer for reading of the file // make sure the size of the file is > 0 if (nFileLen > 0) { byte[] myData = new byte[nFileLen]; myFile.InputStream.Read(myData, 0, nFileLen); // Create a name for the file to store string strFilename = "\\Banners\\" + Path.GetFileName(myFile.FileName); // Write data into a file WriteToFile(Server.MapPath(strFilename), ref myData); imgMuestra.ImageUrl = ".." + strFilename; //imagen = strFilename.Substring(strFilename.LastIndexOf("\\") + 1); } } oBanner unBanner = new oBanner(); unBanner.nombre = txtNombre.Text; unBanner.imagen = imagen; unBanner.columna = ddlColumna.SelectedValue; unBanner.activo = chkActivo.Checked; unBanner.link = txtLink.Text; nBanner nBanner = new nBanner(); nBanner.Alta(ref unBanner); string sError = cargar_Grilla(); } } else { Response.Write("<script type='text/javascript' language='javascript'> alert('La imagen seleccionada ya se encuentra cargada.');</script>"); } }
public string Alta(ref oBanner pE_Banner) { try { string[,] strParameters = { { "@pE_nombre", pE_Banner.nombre }, { "@pE_imagen", pE_Banner.imagen }, { "@pE_activo", (pE_Banner.activo == true?"1":"0") }, { "@pE_columna", pE_Banner.columna }, { "@pE_link", pE_Banner.link } }; pE_Banner.id = int.Parse(oCon.ExecScalar("web_Banner_Alta", CommandType.StoredProcedure, strParameters).ToString()); return(""); } catch (Exception ex) { return(ex.Message); } }
public string Modificar(oBanner pE_Banner) { try { string[,] strParameters = { { "@pE_id", pE_Banner.id.ToString() }, { "@pE_nombre", pE_Banner.nombre }, { "@pE_imagen", pE_Banner.imagen }, { "@pE_activo", pE_Banner.activo.ToString() }, { "@pE_columna", pE_Banner.columna }, { "@pE_link", pE_Banner.link } }; oCon.ExecNonQuery("web_Banner_Modificar", CommandType.StoredProcedure, strParameters); return(""); } catch (Exception ex) { return(ex.Message); } }
public string Buscar_Uno(long pE_Id, ref oBanner pS_Banner) { string sError = ""; try { SqlDataReader dr = null; string[,] strParameters = { { "@pE_Id", pE_Id.ToString() } }; dr = oCon.ExecReader("web_Banner_BuscarUno", CommandType.StoredProcedure, strParameters); if (dr.HasRows) { while (dr.Read()) { pS_Banner.id = Convert.ToInt32(dr["id"].ToString()); pS_Banner.nombre = (dr["nombre"] == DBNull.Value ? "" : dr["nombre"].ToString()); pS_Banner.imagen = (dr["imagen"] == DBNull.Value ? "" : dr["imagen"].ToString()); pS_Banner.activo = (dr["activo"].ToString().ToLower() == "false" ? false : true); pS_Banner.columna = (dr["columna"] == DBNull.Value ? "" : dr["columna"].ToString()); pS_Banner.link = (dr["link"] == DBNull.Value ? "" : dr["link"].ToString()); } } else { throw new Exception("El banner seleccionado no existe"); } dr.Close(); dr = null; } catch (Exception ex) { sError = ex.Message; } return(sError); }
private List <oBanner> carga_ListaBanners() { List <oBanner> banners = new List <oBanner>(); nBanner bannerN = new nBanner(); DataTable dt = new DataTable(); string sError = bannerN.Buscar_TodosInicio(ref dt); foreach (DataRow dr in dt.Rows) { oBanner unBanner = new oBanner(); unBanner.id = Convert.ToInt32(dr["id"].ToString()); unBanner.nombre = (dr["nombre"] == DBNull.Value ? "" : dr["nombre"].ToString()); unBanner.imagen = (dr["imagen"] == DBNull.Value ? "" : dr["imagen"].ToString()); unBanner.activo = (dr["activo"].ToString().ToLower() == "false" ? false : true); unBanner.columna = (dr["columna"] == DBNull.Value ? "" : dr["columna"].ToString()); unBanner.link = (dr["link"] == DBNull.Value ? "" : dr["link"].ToString()); banners.Add(unBanner); } return(banners.Where(a => a.activo == true).ToList <oBanner>()); }
public string Modificar(oBanner pE_Banner) { return(dBanner.Modificar(pE_Banner)); }
public string Buscar_Uno(long pE_Id, ref oBanner pS_Banner) { return(dBanner.Buscar_Uno(pE_Id, ref pS_Banner)); }
public string Alta(ref oBanner pE_Banner) { return(dBanner.Alta(ref pE_Banner)); }