public static string MostrarSlider(SliderBE objSliderBE)
{
try
{
String control = "";
control += "<li data-transition=\"premium-random\" data-slotamount=\"3\">";
control += "<img src=\"/images/sliders/" + objSliderBE.Background + "\" alt=\"slider img\" width=\"1400\" height=\"377\" />";
control += "<div class=\"caption lfb ltb\" data-x=\"800\" data-y=\"50\" data-speed=\"1000\" data-start=\"1000\" data-easing=\"easeInOutCubic\">";
control += "<img src=\"/images/sliders/" + objSliderBE.Imagen + "\" alt=\"woman\" width=\"361\" height=\"374\" />";
control += "</div>";
control += "<div class=\"caption lfl big_theme\" data-x=\"120\" data-y=\"120\" data-speed=\"1000\" data-start=\"500\" data-easing=\"easeInOutBack\">";
control += objSliderBE.Nombre;
control += "</div>";
control += "<div class=\"caption lfl small_theme\" data-x=\"120\" data-y=\"190\" data-speed=\"1000\" data-start=\"700\" data-easing=\"easeInOutBack\">";
control += objSliderBE.Descripcion;
control += "</div>";
control += "<a href=\"" + objSliderBE.Url + "\" class=\"caption lfl btn btn-primary btn_theme\" data-x=\"120\" data-y=\"260\" data-speed=\"1000\" data-start=\"900\" data-easing=\"easeInOutBack\">";
control += objSliderBE.Boton;
control += "</a>";
control += "</li>";
return(control);
}
catch (Exception)
{
throw;
}
}
protected void btnActualizarOrden_Click(object sender, EventArgs e)
{
SliderBC objSliderBC = new SliderBC();
SliderBE objSliderBE = new SliderBE();
try
{
for (int i = 0; i < gvSliders.Rows.Count; i++)
{
TextBox txtOrden = (TextBox)gvSliders.Rows[i].FindControl("txtOrden");
objSliderBE = new SliderBE();
objSliderBE.Id_Slider = Convert.ToInt32(gvSliders.DataKeys[i].Value);
objSliderBE.Orden = Convert.ToInt32(txtOrden.Text.Trim());
objSliderBC.Update_Slider_Orden(objSliderBE);
}
//Tools.Alert("El orden se actualizó satisfactoriamente", "Cambiar Orden", GetType(), this);
LlenarSlider();
}
catch (Exception ex)
{
Tools.Error(GetType(), this, ex);
}
}
public void Update_Slider_Orden(SliderBE objSliderBE)
{
try
{
objSliderDALC.Update_Slider_Orden(objSliderBE);
}
catch (Exception)
{
throw;
}
}
public void Update_Slider_Background(SliderBE objSliderBE)
{
try
{
objSliderDALC.Update_Slider_Background(objSliderBE);
}
catch (Exception)
{
throw;
}
}
public int Insert_Slider(SliderBE objSliderBE)
{
try
{
return(objSliderDALC.Insert_Slider(objSliderBE));
}
catch (Exception)
{
throw;
}
}
public List <SliderBE> Select_Slider()
{
String cadena;
String sql = "Slider_Select";
SliderBE objSliderBE = null;
List <SliderBE> lstSliderBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (lstSliderBE == null)
{
lstSliderBE = new List <SliderBE>();
}
objSliderBE = new SliderBE();
objSliderBE.Background = dr["background"].ToString();
objSliderBE.Boton = dr["boton"].ToString();
objSliderBE.Descripcion = dr["descripcion"].ToString();
objSliderBE.Id_Slider = Convert.ToInt32(dr["id_slider"]);
objSliderBE.Imagen = dr["imagen"].ToString();
objSliderBE.Nombre = dr["nombre"].ToString();
objSliderBE.Url = dr["url"].ToString();
objSliderBE.Orden = Convert.ToInt32(dr["orden"]);
lstSliderBE.Add(objSliderBE);
}
}
}
}
return(lstSliderBE);
}
catch (Exception)
{
throw;
}
}
public SliderBE Get_Slider(Int32 id_slider)
{
String cadena;
String sql = "Slider_Get";
SqlParameter[] arrParameters = new SqlParameter[1];
SliderBE objSliderBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@id_slider", id_slider);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
objSliderBE = new SliderBE();
objSliderBE.Background = dr["background"].ToString();
objSliderBE.Boton = dr["boton"].ToString();
objSliderBE.Descripcion = dr["descripcion"].ToString();
objSliderBE.Id_Slider = Convert.ToInt32(dr["id_slider"]);
objSliderBE.Imagen = dr["imagen"].ToString();
objSliderBE.Nombre = dr["nombre"].ToString();
objSliderBE.Url = dr["url"].ToString();
}
}
}
}
return(objSliderBE);
}
catch (Exception)
{
throw;
}
}
protected void btnGuardarImagen_Click(object sender, EventArgs e)
{
SliderBE objSliderBE = new SliderBE();
SliderBC objSliderBC = new SliderBC();
string nombre_img = "";
try
{
if (fuNuevaImagen.HasFile)
{
string ext = Path.GetExtension(fuNuevaImagen.FileName);
if (Tools.EsImagen(ext))
{
string idPanel = hdImagenCodigo.Value;
string rutaImagen = hdRutaImagen.Value;
rutaImagen = rutaImagen.Remove(0, 4);
rutaImagen = rutaImagen.Remove(rutaImagen.Length - 1);
objSliderBE.Id_Slider = Convert.ToInt32(ViewState["ID_SLIDER"]);
switch (idPanel)
{
case "1":
nombre_img = ViewState["ID_SLIDER"] + ext;
objSliderBE.Background = nombre_img;
objSliderBC.Update_Slider_Background(objSliderBE);
pnlImagen1.Style.Add("background-image", "url('" + PATH_IMG_BACK + nombre_img + "?r=" + (new Random().Next()) + "')");
break;
case "2":
nombre_img = "img" + ViewState["ID_SLIDER"] + ext;
objSliderBE.Imagen = nombre_img;
objSliderBC.Update_Slider_Imagen(objSliderBE);
pnlImagen2.Style.Add("background-image", "url('" + PATH_IMG_BACK + nombre_img + "?r=" + (new Random().Next()) + "')");
break;
}
string path = MapPath(".." + PATH_IMG_BACK);
File.Delete(path + Path.GetFileName(rutaImagen));
fuNuevaImagen.SaveAs(path + nombre_img);
}
}
}
catch (Exception ex)
{
Tools.Error(GetType(), this, ex);
}
}
public int Insert_Slider(SliderBE objSliderBE)
{
String cadena;
String sql = "Slider_Insert";
SqlParameter[] arrParameters = new SqlParameter[6];
int codigo = 0;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@background", objSliderBE.Background);
arrParameters[1] = new SqlParameter("@boton", objSliderBE.Boton);
arrParameters[2] = new SqlParameter("@descripcion", objSliderBE.Descripcion);
arrParameters[3] = new SqlParameter("@imagen", objSliderBE.Imagen);
arrParameters[4] = new SqlParameter("@nombre", objSliderBE.Nombre);
arrParameters[5] = new SqlParameter("@url", objSliderBE.Url);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
codigo = Convert.ToInt32(cmd.ExecuteScalar());
}
}
return(codigo);
}
catch (Exception)
{
throw;
}
}
public void Update_Slider(SliderBE objSliderBE)
{
String cadena;
String sql = "Slider_Update";
SqlParameter[] arrParameters = new SqlParameter[5];
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@boton", objSliderBE.Boton);
arrParameters[1] = new SqlParameter("@descripcion", objSliderBE.Descripcion);
arrParameters[2] = new SqlParameter("@id_slider", objSliderBE.Id_Slider);
arrParameters[3] = new SqlParameter("@nombre", objSliderBE.Nombre);
arrParameters[4] = new SqlParameter("@url", objSliderBE.Url);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
}
private void MostrarSlider()
{
SliderBC objSliderBC = new SliderBC();
SliderBE objSliderBE = new SliderBE();
try
{
string path = MapPath(PATH_IMG_BACK);
objSliderBE = objSliderBC.Get_Slider(Convert.ToInt32(ViewState["ID_SLIDER"]));
txtBoton.Text = objSliderBE.Boton;
txtDescripcion.Text = objSliderBE.Descripcion;
txtNombre.Text = objSliderBE.Nombre;
txtUrl.Text = objSliderBE.Url;
pnlImagen1.Style.Add("background-image", "url('" + PATH_IMG_BACK + objSliderBE.Background + "')");
pnlImagen2.Style.Add("background-image", "url('" + PATH_IMG_BACK + objSliderBE.Imagen + "')");
}
catch (Exception)
{
throw;
}
}
public void Update_Slider_Background(SliderBE objSliderBE)
{
String cadena;
String sql = "Slider_Update_Background";
SqlParameter[] arrParameters = new SqlParameter[2];
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@background", objSliderBE.Background);
arrParameters[1] = new SqlParameter("@id_slider", objSliderBE.Id_Slider);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
SliderBE objSliderBE = new SliderBE();
SliderBC objSliderBC = new SliderBC();
try
{
objSliderBE.Boton = txtBoton.Text.Trim();
objSliderBE.Descripcion = txtDescripcion.Text.Trim();
objSliderBE.Nombre = txtNombre.Text.Trim();
objSliderBE.Url = txtUrl.Text.Trim();
if ((Modo)ViewState["MODO"] == Modo.Insertar)
{
objSliderBE.Background = Path.GetExtension(fuFondo.FileName);
objSliderBE.Imagen = Path.GetExtension(fuImagen.FileName);
string path = MapPath(".." + PATH_IMG_BACK);
int codigo = objSliderBC.Insert_Slider(objSliderBE);
fuFondo.SaveAs(path + codigo + objSliderBE.Background);
fuImagen.SaveAs(path + "img" + codigo + objSliderBE.Imagen);
}
else if ((Modo)ViewState["MODO"] == Modo.Editar)
{
objSliderBE.Id_Slider = Convert.ToInt32(ViewState["ID_SLIDER"]);
objSliderBC.Update_Slider(objSliderBE);
}
Response.Redirect("/Administrador/Sliders.aspx");
}
catch (Exception ex)
{
Tools.Error(GetType(), this, ex);
}
}
