コード例 #1
0
    protected void btnTodos_Click(object sender, EventArgs e)
    {
        try
        {
            DataTable dt = new DataTable();
            dt = objCtrMoldura.ListarTodoMoldura(objDtoMoldura);
            string Image1;
            string HtmlRepeater = "";
            string cs           = ConfigurationManager.ConnectionStrings["conexion"].ConnectionString;


            foreach (DataRow row in dt.Rows)
            {
                string PK_IM_Cod         = row["PK_IM_Cod"].ToString();
                string DM_Medida         = row["DM_Medida"].ToString();
                string VTM_UnidadMetrica = row["VTM_UnidadMetrica"].ToString();
                string DM_Precio         = row["DM_Precio"].ToString();
                string VM_Descripcion    = row["VM_Descripcion"].ToString();


                _log.CustomWriteOnLog("BaquetonC", "PK_IM_Cod : " + PK_IM_Cod);
                _log.CustomWriteOnLog("BaquetonC", "DM_Medida : " + DM_Medida);
                _log.CustomWriteOnLog("BaquetonC", "VTM_UnidadMetrica : " + VTM_UnidadMetrica);
                _log.CustomWriteOnLog("BaquetonC", "DM_Precio : " + DM_Precio);
                _log.CustomWriteOnLog("BaquetonC", "VM_Descripcion : " + VM_Descripcion);

                objDtoMoldura.PK_IM_Cod = int.Parse(PK_IM_Cod);


                using (SqlConnection con = new SqlConnection(cs))
                {
                    SqlCommand cmd = new SqlCommand("SP_GetImageById", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter paramId = new SqlParameter()
                    {
                        ParameterName = "@Id",
                        Value         = int.Parse(PK_IM_Cod)
                    };
                    _log.CustomWriteOnLog("BaquetonC", "id" + int.Parse(PK_IM_Cod));


                    cmd.Parameters.Add(paramId);

                    con.Open();
                    byte[] bytes = (byte[])cmd.ExecuteScalar();

                    con.Close();
                    string strbase64 = Convert.ToBase64String(bytes);

                    Image1 = "data:Image/png;base64," + strbase64;
                }
                HtmlRepeater += " <li>" +
                                "<div class=tipo-moldura>" +
                                "<img loading='lazy' src='" + Image1 + "' alt=''>" +
                                "<p>Mide: " + DM_Medida + "</p>" +
                                "<p>Precio: S./" + DM_Precio + "</p>" +
                                "<button id='btnSave' class='btn btn-primary nextBtn-2' onClick='cargarInformacion(" + PK_IM_Cod + ")'>Detalles</asp:button>" +
                                "</div>" +
                                "<button id='btnSave' class='btn btn-primary nextBtn-2' onClick='cargarListaDeseo(" + PK_IM_Cod + ")'>Agregar lista de deseos</asp:button>" +
                                "</div>" +
                                " </li>";

                ListaMoldura.InnerHtml = HtmlRepeater;
            }
        }

        catch (Exception ex)
        {
            _log.CustomWriteOnLog("Baqueton", "Error :" + ex.Message + "StackTrace" + ex.StackTrace);

            throw;
        }
    }
コード例 #2
0
        //Muestra listado de todas las molduras con su imagen, descripcion, precio y boton detalle
        public void mostrarTodos()
        {
            DataTable dt = new DataTable();

            dt = objCtrMoldura.ListarTodoMoldura(objDtoMoldura);
            string Image1;
            string HtmlRepeater = "";

            //string cs = ConfigurationManager.ConnectionStrings["conexion"].ConnectionString;

            foreach (DataRow row in dt.Rows)
            {
                string PK_IM_Cod = row["PK_IM_Cod"].ToString();
                //string DM_Medida = row["DM_Medida"].ToString();
                //string VTM_UnidadMetrica = row["VTM_UnidadMetrica"].ToString();
                string DM_Precio      = row["DM_Precio"].ToString();
                string VTM_Nombre     = row["VTM_Nombre"].ToString();
                string VM_Descripcion = row["VM_Descripcion"].ToString();

                _log.CustomWriteOnLog("Codigo", "PK_IM_Cod : " + PK_IM_Cod);
                //_log.CustomWriteOnLog("BaquetonC", "DM_Medida : " + DM_Medida);
                //_log.CustomWriteOnLog("BaquetonC", "VTM_UnidadMetrica : " + VTM_UnidadMetrica);
                _log.CustomWriteOnLog("Precio", "DM_Precio : " + DM_Precio);
                _log.CustomWriteOnLog("Descripcion", "VM_Descripcion : " + VM_Descripcion);

                objDtoMoldura.PK_IM_Cod = int.Parse(PK_IM_Cod);
                objCtrMoldura.ObtenerMoldura(objDtoMoldura, objDtoTipoMoldura);

                //using (SqlConnection con = new SqlConnection(cs))
                //{
                //    SqlCommand cmd = new SqlCommand("SP_GetImageById", con);
                //    cmd.CommandType = CommandType.StoredProcedure;
                //    SqlParameter paramId = new SqlParameter()
                //    {
                //        ParameterName = "@Id",
                //        Value = int.Parse(PK_IM_Cod)
                //    };
                //    _log.CustomWriteOnLog("Codigo baqueton", "id" + int.Parse(PK_IM_Cod));

                //    cmd.Parameters.Add(paramId);

                //    con.Open();
                //    byte[] bytes = (byte[])cmd.ExecuteScalar();
                //    con.Close();
                //    string strbase64 = Convert.ToBase64String(bytes);

                //    Image1 = "data:Image/png;base64," + strbase64;
                //}
                Image1        = "data:Image/png;base64," + Convert.ToBase64String(objDtoMoldura.VBM_Imagen);
                HtmlRepeater +=
                    "<div class='col-sm-6 col-xl-3 filter-item all web illustrator'>" +
                    "<div class=gal-box>" +
                    "<a src = '" + Image1 + "' class='image-popup' title='Baqueton-1'>" +
                    "<img src = '" + Image1 + "' class='img-fluid' alt=Baqueton 01' width='550px' height='412px'>" +
                    "</a>" +
                    "<div class='gall-info'>" +
                    "<h4 class='font-16 mt-0'>" + VTM_Nombre + " - #" + PK_IM_Cod + "</h4>" +
                    "<h4 class='font-16 mt-0'>" + " S/. " + DM_Precio + "</h4>" +
                    "<a href = javascript: void(0);>" +
                    "<input type='button' value='Detalles' id='btnSave' class='text-muted ml-1' onClick='cargarInformacion(" + PK_IM_Cod + ")'>" +
                    "</asp:input>" +
                    "</a>" +
                    "<a href = javascript:mostrarMensaje(); OnClick='btnAgregarCarrito_Click'  class='gal-like-btn'><i class='mdi mdi-cart'></i></a>" +
                    "</div>" +
                    "</div>" +
                    "</div>";
                ListaMoldura.InnerHtml = HtmlRepeater;
            }
        }