protected void btn_guardarPSNew_Click(object sender, EventArgs e)
        {
            try
            {
                if (rcmb_añoNewPS.SelectedIndex > 0 && rcmb_mesNewDesdePS.SelectedIndex > 0 && rcmb_mesNewHastaPS.SelectedIndex > 0)
                {
                    iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
                    sidcanal   = this.Session["Canal"].ToString();
                    siduser    = this.Session["sUser"].ToString();
                    for (int i = 0; i < RadGrid_newPSugeridoPS.Items.Count; i++)
                    {
                        GridDataItem ditem = RadGrid_newPSugeridoPS.Items[i];

                        string cod_product  = ditem["cod_Product"].Text;
                        object PrecSugerido = (ditem.FindControl("rtxt_precio") as RadNumericTextBox).DbValue;


                        if (PrecSugerido != null)
                        {
                            oCoon.ejecutarDataReader("UP_WEBXPLORA_CLIE_V2_INSERTAR_PRECIO_SUGERIDO_SKU_MADATORIO", sidcanal, iidcompany, rcmb_añoNewPS.SelectedValue, rcmb_mesNewDesdePS.SelectedValue, rcmb_mesNewHastaPS.SelectedValue, cod_product, PrecSugerido, siduser, DateTime.Now, siduser, DateTime.Now);
                        }
                    }

                    ModalPopupExtender_addPS.Show();

                    lbl_msj_validation.Text      = "Registro exitoso.";
                    lbl_msj_validation.ForeColor = System.Drawing.Color.Green;
                    ModalPopupExtender_validationMessagePS.Show();
                }
                else
                {
                    //ModalPopupExtender_addPS.Hide();

                    ModalPopupExtender_validationMessagePS.Show();
                    lbl_msj_validation.Text = "Por favor, termine de seleccionar las opciones.";
                    //UpdatePanel_validationMessagePS.Update();
                }
            }
            catch (Exception ex)
            {
                lbl_msj_validation.Text      = "Error, intentalo nuevamente.";
                lbl_msj_validation.ForeColor = System.Drawing.Color.Red;
                ModalPopupExtender_validationMessagePS.Show();

                Lucky.CFG.Exceptions.Exceptions mesjerror = new Lucky.CFG.Exceptions.Exceptions(ex);
                mesjerror.errorWebsite(System.Configuration.ConfigurationManager.AppSettings["COUNTRY"]);
            }
        }
        protected void btn_guardarPS_Click(object sender, EventArgs e)
        {
            try
            {
                iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
                sidcanal   = this.Session["Canal"].ToString();
                siduser    = this.Session["sUser"].ToString();
                for (int i = 0; i < RadGrid_PSugeridosPS.Items.Count; i++)
                {
                    GridDataItem ditem = RadGrid_PSugeridosPS.Items[i];

                    string cod_product  = ditem["cod_Product"].Text;
                    object PrecSugerido = (ditem.FindControl("rtxt_precio") as RadNumericTextBox).DbValue;


                    string id_year  = (ditem.FindControl("lbl_id_año") as Label).Text;
                    string id_month = (ditem.FindControl("lbl_id_mes") as Label).Text;

                    if (PrecSugerido != null)
                    {
                        oCoon.ejecutarDataReader("UP_WEBXPLORA_CLIE_V2_ACTUALIZAR_PRECIO_SUGERIDO", sidcanal, iidcompany, cod_product, id_year, id_month, PrecSugerido, siduser, DateTime.Now);
                    }
                }

                lbl_msj_validation.Text      = "Registro exitoso.";
                lbl_msj_validation.ForeColor = System.Drawing.Color.Green;
                ModalPopupExtender_validationMessagePS.Show();
            }
            catch (Exception ex)
            {
                lbl_msj_validation.Text      = "Error, intentalo nuevamente.";
                lbl_msj_validation.ForeColor = System.Drawing.Color.Red;
                ModalPopupExtender_validationMessagePS.Show();

                Lucky.CFG.Exceptions.Exceptions mesjerror = new Lucky.CFG.Exceptions.Exceptions(ex);
                mesjerror.errorWebsite(System.Configuration.ConfigurationManager.AppSettings["COUNTRY"]);
            }
        }
        protected void btn_buscarPS_Click(object sender, EventArgs e)
        {
            try
            {
                lbl_info.Text           = "";
                lbl_msj_validation.Text = "";
                if (rcmb_añoPS.SelectedIndex > 0 && rcmb_mesPS.SelectedIndex > 0)
                {
                    iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
                    sidcanal   = this.Session["Canal"].ToString();

                    DataTable dtprec = oCoon.ejecutarDataTable("UP_WEBXPLORA_CLIE_V2_OBTENER_PRECIOS_SUGERIDOS_SKU_MANDATORIOS", sidcanal, iidcompany, rcmb_añoPS.SelectedValue, rcmb_mesPS.SelectedValue);


                    RadGrid_PSugeridosPS.DataSource = dtprec;
                    RadGrid_PSugeridosPS.DataBind();

                    if (RadGrid_PSugeridosPS.Items.Count > 0)
                    {
                        lbl_info.Text = "Precios del mes de: " + rcmb_mesPS.SelectedItem.Text + " del año : " + rcmb_añoPS.SelectedItem.Text;
                    }
                    //UpdatePanel_gridPSugeridoPS.Update();
                }
                else
                {
                    ModalPopupExtender_validationMessagePS.Show();
                    lbl_msj_validation.Text = "Por favor, termine de seleccionar las opciones.";
                    //UpdatePanel_validationMessagePS.Update();
                }
            }
            catch (Exception ex)
            {
                Lucky.CFG.Exceptions.Exceptions mesjerror = new Lucky.CFG.Exceptions.Exceptions(ex);
                mesjerror.errorWebsite(System.Configuration.ConfigurationManager.AppSettings["COUNTRY"]);
            }
        }