public int Insert_Update_Whishlist(WhishlistBE objWhishlistBE) { try { return(objWhishlistDALC.Insert_Update_Whishlist(objWhishlistBE)); } catch (Exception) { throw; } }
public void Update_Whishlist(WhishlistBE objWhishlistBE) { try { objWhishlistDALC.Update_Whishlist(objWhishlistBE); } catch (Exception) { throw; } }
public WhishlistBE Get_Whishlist(Int32 id_producto, Int32 id_usuario, Int32 id_whishlist) { String cadena; String sql = "Whishlist_Get"; SqlParameter[] arrParameters = new SqlParameter[3]; WhishlistBE objWhishlistBE = 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_producto", id_producto); arrParameters[1] = new SqlParameter("@id_usuario", id_usuario); arrParameters[2] = new SqlParameter("@id_whishlist", id_whishlist); for (int i = 0; i < arrParameters.Length; i++) { cmd.Parameters.Add(arrParameters[i]); } cmd.Connection.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { objWhishlistBE = new WhishlistBE(); objWhishlistBE.Fecha_Creacion = Convert.ToDateTime(dr["fecha_creacion"]); objWhishlistBE.Id_Producto = Convert.ToInt32(dr["id_producto"]); objWhishlistBE.Id_Usuario = Convert.ToInt32(dr["id_usuario"]); objWhishlistBE.Id_Whishlist = Convert.ToInt32(dr["id_whishlist"]); } } } } return(objWhishlistBE); } catch (Exception) { throw; } }
public List <WhishlistBE> Select_Whishlist() { String cadena; String sql = "Whishlist_Select"; WhishlistBE objWhishlistBE = null; List <WhishlistBE> lstWhishlistBE = 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 (lstWhishlistBE == null) { lstWhishlistBE = new List <WhishlistBE>(); } objWhishlistBE = new WhishlistBE(); objWhishlistBE.Fecha_Creacion = Convert.ToDateTime(dr["fecha_creacion"]); objWhishlistBE.Id_Producto = Convert.ToInt32(dr["id_producto"]); objWhishlistBE.Id_Usuario = Convert.ToInt32(dr["id_usuario"]); objWhishlistBE.Id_Whishlist = Convert.ToInt32(dr["id_whishlist"]); lstWhishlistBE.Add(objWhishlistBE); } } } } return(lstWhishlistBE); } catch (Exception) { throw; } }
public static void AñadirFavoritos(int idProducto) { WhishlistBC objWhishlistBC = new WhishlistBC(); WhishlistBE objWhishlistBE = new WhishlistBE(); try { objWhishlistBE.Id_Usuario = ((UsuarioBE)HttpContext.Current.Session["USUARIO"]).Id_Usuario; objWhishlistBE.Id_Producto = idProducto; objWhishlistBC.Insert_Whishlist(objWhishlistBE); } catch (Exception) { throw; } }
private string GetWishItem(WhishlistBE objWishlistBE) { String wishitem = ""; try { wishitem += "<tr id=\"trItemWish" + objWishlistBE.Id_Producto + "\">"; wishitem += "<td class=\"image\"><img src=\"/images/productos/" + objWishlistBE.Nombre_Imagen + "\" alt=\"\" width=\"100\" height=\"124\" /></td>"; wishitem += "<td class=\"desc\">" + objWishlistBE.Nombre + " <a title=\"Remove Item\" class=\"icon-remover\" href=\"#\" onclick=\"RemoverFavorito(" + objWishlistBE.Id_Producto + ")\"></a></td>"; wishitem += "<td class=\"price\">S/. " + objWishlistBE.Precio + "</td>"; wishitem += "</tr>"; return(wishitem); } catch (Exception) { throw; } }
public int Insert_Update_Whishlist(WhishlistBE objWhishlistBE) { String cadena; String sql = "Whishlist_Insert_Update"; int codigo = 0; SqlParameter[] arrParameters = new SqlParameter[4]; 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("@fecha_creacion", objWhishlistBE.Fecha_Creacion); arrParameters[1] = new SqlParameter("@id_producto", objWhishlistBE.Id_Producto); arrParameters[2] = new SqlParameter("@id_usuario", objWhishlistBE.Id_Usuario); arrParameters[3] = new SqlParameter("@id_whishlist", objWhishlistBE.Id_Whishlist); 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 List <WhishlistBE> Get_Whishlist_Usuario(Int32 id_usuario) { String cadena; String sql = "Wishlist_Get_Usuario"; SqlParameter[] arrParameters = new SqlParameter[1]; WhishlistBE objWhishlistBE = null; List <WhishlistBE> lstWhishlistBE = 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_usuario", id_usuario); for (int i = 0; i < arrParameters.Length; i++) { cmd.Parameters.Add(arrParameters[i]); } cmd.Connection.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (lstWhishlistBE == null) { lstWhishlistBE = new List <WhishlistBE>(); } objWhishlistBE = new WhishlistBE(); objWhishlistBE.Fecha_Creacion = Convert.ToDateTime(dr["fecha_creacion"]); objWhishlistBE.Id_Producto = Convert.ToInt32(dr["id_producto"]); objWhishlistBE.Id_Usuario = Convert.ToInt32(dr["id_usuario"]); objWhishlistBE.Id_Whishlist = Convert.ToInt32(dr["id_whishlist"]); objWhishlistBE.Nombre_Imagen = dr["nombre_imagen"].ToString(); objWhishlistBE.Nombre = dr["nombre"].ToString(); objWhishlistBE.Precio = Convert.ToDecimal(dr["precio"]); objWhishlistBE.Descripcion_Corta = dr["descripcion_corta"].ToString(); lstWhishlistBE.Add(objWhishlistBE); } } } } return(lstWhishlistBE); } catch (Exception) { throw; } }