Example #1
0
        //Muestra listado de molduras baqueton clasico con su imagen, descripcion, precio y boton detalle
        protected void btnBaquetonClasico_Click(object sender, EventArgs e)
        {
            try
            {
                objDtoTipoMoldura.PK_ITM_Tipo = 2;
                _log.CustomWriteOnLog("Baqueton clasico tipo", "objDtoTipoMoldura.PK_ITM_Tipo : " + objDtoTipoMoldura.PK_ITM_Tipo);
                DataTable dt = new DataTable();
                dt = objCtrMoldura.ListarMoldurasPaginaInicial(objDtoTipoMoldura);
                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();
                    string VTM_Nombre     = row["VTM_Nombre"].ToString();

                    _log.CustomWriteOnLog("Codigo", "PK_IM_Cod : " + PK_IM_Cod);
                    //_log.CustomWriteOnLog("InspeccionarCatalogo", "DM_Medida : " + DM_Medida);
                    //_log.CustomWriteOnLog("InspeccionarCatalogo", "VTM_UnidadMetrica : " + VTM_UnidadMetrkica);
                    _log.CustomWriteOnLog("Precio", "DM_Precio : " + DM_Precio);
                    _log.CustomWriteOnLog("Descripcion", "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("Codigo", "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 +=
                        "<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: void(0); class='gal-like-btn'><i class='mdi mdi-cart'></i></a>" +
                        "</div>" +
                        "</div>" +
                        "</div>";
                    ListaMoldura.InnerHtml = HtmlRepeater;
                }
            }
            catch (Exception ex)
            {
                _log.CustomWriteOnLog("Baqueton clasico ERROR", "Error :" + ex.Message + "StackTrace" + ex.StackTrace);
            }
        }
    protected void btnBaquetonClasico_Click(object sender, EventArgs e)
    {
        try
        {
            objDtoTipoMoldura.PK_ITM_Tipo = 2;
            _log.CustomWriteOnLog("InspeccionarCatalogo", "objDtoTipoMoldura.PK_ITM_Tipo : " + objDtoTipoMoldura.PK_ITM_Tipo);
            DataTable dt = new DataTable();
            dt = objCtrMoldura.ListarMoldurasPaginaInicial(objDtoTipoMoldura);
            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("InspeccionarCatalogo", "PK_IM_Cod : " + PK_IM_Cod);
                _log.CustomWriteOnLog("InspeccionarCatalogo", "DM_Medida : " + DM_Medida);
                _log.CustomWriteOnLog("InspeccionarCatalogo", "VTM_UnidadMetrica : " + VTM_UnidadMetrica);
                _log.CustomWriteOnLog("InspeccionarCatalogo", "DM_Precio : " + DM_Precio);
                _log.CustomWriteOnLog("InspeccionarCatalogo", "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("InspeccionarCatalogo", "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("InspeccionarCatalogo", "Error :" + ex.Message + "StackTrace" + ex.StackTrace);

            throw;
        }
    }
Example #3
0
        protected void btnBaquetonClasico_Click(object sender, EventArgs e)
        {
            try
            {
                objDtoTipoMoldura.PK_ITM_Tipo = 2;
                _log.CustomWriteOnLog("InspeccionarCatalogo", "objDtoTipoMoldura.PK_ITM_Tipo : " + objDtoTipoMoldura.PK_ITM_Tipo);
                DataTable dt = new DataTable();
                dt = objCtrMoldura.ListarMoldurasPaginaInicial(objDtoTipoMoldura);
                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("InspeccionarCatalogo", "PK_IM_Cod : " + PK_IM_Cod);
                    //_log.CustomWriteOnLog("InspeccionarCatalogo", "DM_Medida : " + DM_Medida);
                    //_log.CustomWriteOnLog("InspeccionarCatalogo", "VTM_UnidadMetrica : " + VTM_UnidadMetrkica);
                    _log.CustomWriteOnLog("InspeccionarCatalogo", "DM_Precio : " + DM_Precio);
                    _log.CustomWriteOnLog("InspeccionarCatalogo", "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("InspeccionarCatalogo", "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;

                    HtmlRepeater +=
                        "<div class=row filterable-content>" +
                        "<div class=col-sm-6 col-xl-3 filter-item all web illustrator>" +
                        "<div class=gal-box>" +
                        "<a src = '" + Image1 + "' class='image-popup' title='Screenshot-1'>" +
                        "<img src = '" + Image1 + "' class='img-fluid' alt=work-thumbnail'>" +
                        "</a>" +
                        "<div class='gall-info'>" +
                        "<h4 class='font-16 mt-0'>Man wearing black jacket</h4>" +
                        "<a href = javascript: void(0);>" +
                        "<img src= ../assets/images/users/user-3.jpg alt= 'user-img' class='rounded-circl' height=24/>" +
                        "<span class='text-muted ml-1'>Justin Coke</span>" +
                        "</a>" +
                        "<a href = javascript: void(0); class='gal-like-btn'><i class='mdi mdi-heart-outline text-danger'></i></a>" +
                        "</div>" +
                        "</div>" +
                        "</div>" +
                        "</div>";
                    ListaMoldura.InnerHtml = HtmlRepeater;
                }
            }
            catch (Exception ex)
            {
                _log.CustomWriteOnLog("InspeccionarCatalogo", "Error :" + ex.Message + "StackTrace" + ex.StackTrace);
            }
        }