private void llenar_Periodos()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
Conexion oCoon = new Conexion();
DataTable dtp = null;
int Report = Convert.ToInt32(this.Session["Reporte"]);
string canal = this.Session["Canal"].ToString().Trim();
int icompany = Convert.ToInt32(this.Session["companyid"]);
dtp = oCoon.ejecutarDataTable("UP_WEBXPLORA_CLIE_V2_OBTENERPERIODOS_2", canal, icompany, Report, cmb_mes.SelectedValue, cmb_año.SelectedValue);
if (dtp.Rows.Count > 0)
{
cmb_periodo.DataSource = dtp;
cmb_periodo.DataValueField = "id_periodo";
cmb_periodo.DataTextField = "Periodo";
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
}
else
{
dtp = null;
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
cmb_año.DataBind();
cmb_año.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_mes.DataBind();
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cargarMenu();
llenar_Años();
llenar_Meses();
llenargrilla1("", "");
}
catch (Exception ex)
{
Exception mensaje = ex;
this.Session.Abandon();
//Response.Redirect("~/err_mensaje_seccion.aspx", true);
}
}
}
protected void cmb_mes_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
cmb_periodo.Items.Clear();
llenar_Periodos();
}
private void llenar_Meses()
{
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
DataTable dtm = Get_Administrativo.Get_ObtenerMeses();
if (dtm.Rows.Count > 0)
{
cmb_mes.DataSource = dtm;
cmb_mes.DataValueField = "codmes";
cmb_mes.DataTextField = "namemes";
cmb_mes.DataBind();
cmb_mes.DataSource = dtm;
cmb_mes.DataValueField = "codmes";
cmb_mes.DataTextField = "namemes";
cmb_mes.DataBind();
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Seleccione--", "-1"));
}
else
{
dtm = null;
}
}
protected void cargarParametrosdeXml()
{
RadGrid RadGrid_parametros = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("RadGrid_parametros") as RadGrid;
string path = Server.MapPath("~/parametros.xml");
if (System.IO.File.Exists(path))
{
Reportes_parametros oReportes_parametros = new Reportes_parametros();
oReportes_parametros.Id_reporte = Convert.ToInt32(this.Session["Reporte"]);
oReportes_parametros.Id_user = this.Session["sUser"].ToString();
oReportes_parametros.Id_compañia = Convert.ToInt32(this.Session["companyid"]);
oReportes_parametros.Id_servicio = Convert.ToInt32(this.Session["Service"]);
oReportes_parametros.Id_canal = this.Session["Canal"].ToString().Trim();
oReportes_parametros.Id_tipoReporte = this.Request.Path;
Reportes_parametrosToXml oReportes_parametrosToXml = new Reportes_parametrosToXml();
try
{
RadGrid_parametros.DataSource = oReportes_parametrosToXml.Get_Parametros(oReportes_parametros, path);
RadGrid_parametros.DataBind();
}
catch
{
}
}
}
protected void Click_btn_img_ver(object sender, EventArgs e)
{
ModalPopupExtender mpe_ver = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("mpe_ver") as ModalPopupExtender;
cargarParametrosdeXml();
mpe_ver.Show();
}
protected void cmb_cobertura_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
Label lbl_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("lbl_ciudad") as Label;
Label lbl_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("lbl_cadena") as Label;
if (cmb_cobertura.SelectedValue == "2")
{
lbl_ciudad.Visible = true;
cmb_ciudad.Visible = true;
}
else
{
cmb_ciudad.SelectedIndex = 0;
lbl_ciudad.Visible = false;
cmb_ciudad.Visible = false;
//---
cmb_cadena.Visible = false;
lbl_cadena.Visible = false;
cargarCadena();
}
}
protected void cmb_mes_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
UpdatePanel up_filtros = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("up_filtros") as UpdatePanel;
cargarPeriodo();
up_filtros.Update();
}
private void llenar_Años()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
DataTable dty = null;
dty = Get_Administrativo.Get_ObtenerYears();
if (dty.Rows.Count > 0)
{
cmb_año.DataSource = dty;
cmb_año.DataValueField = "Years_Number";
cmb_año.DataTextField = "Years_Number";
cmb_año.DataBind();
cmb_año.DataSource = dty;
cmb_año.DataValueField = "Years_Number";
cmb_año.DataTextField = "Years_Number";
cmb_año.DataBind();
cmb_año.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
}
else
{
dty = null;
}
}
protected void cargarCadena()
{
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
Label lbl_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("lbl_cadena") as Label;
cmb_cadena.Visible = false;
lbl_cadena.Visible = false;
DataTable dt = null;
iservicio = Convert.ToInt32(this.Session["Service"]);
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
if (cmb_cobertura.SelectedValue == "1" || cmb_ciudad.SelectedIndex > 0)
{
cmb_cadena.Visible = true;
lbl_cadena.Visible = true;
if (cmb_cobertura.SelectedValue == "1")
{
cmb_ciudad.SelectedValue = "9";
}
}
dt = oCoon.ejecutarDataTable("UP_WEBXPLORA_AD_OBTENER_NODECOMERCIAL_BY_cod_oficina", iservicio, sidcanal, iidcompany, cmb_ciudad.SelectedValue);
cmb_cadena.DataSource = dt;
cmb_cadena.DataValueField = "id_NodeCommercial";
cmb_cadena.DataTextField = "commercialNodeName";
cmb_cadena.DataBind();
cmb_cadena.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
public void cargarMes()
{
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
DataTable dtm = Get_Administrativo.Get_ObtenerMeses();
cmb_mes.DataSource = dtm;
cmb_mes.DataValueField = "codmes";
cmb_mes.DataTextField = "namemes";
cmb_mes.DataBind();
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Seleccione--", "0"));
}
private void Ciudad()
{
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
DataTable dtc = null;
dtc = Get_DataClientes.Get_Obtenerinfocombos(iidcompany, sidcanal, "0", 1);
cmb_ciudad.DataSource = dtc;
cmb_ciudad.DataValueField = "cod_city";
cmb_ciudad.DataTextField = "name_city";
cmb_ciudad.DataBind();
cmb_ciudad.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
public void cargarAño()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
DataTable dty = null;
dty = Get_Administrativo.Get_ObtenerYears();
cmb_año.DataSource = dty;
cmb_año.DataValueField = "Years_Number";
cmb_año.DataTextField = "Years_Number";
cmb_año.DataBind();
cmb_año.Items.Insert(0, new RadComboBoxItem("--Seleccione--", "0"));
}
protected void cmb_categoria_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox cmb_marca = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_marca") as RadComboBox;
RadComboBox cmb_categoria = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_categoria") as RadComboBox;
if (cmb_categoria.SelectedIndex > 0)
{
CargarMarcas();
}
else
{
cmb_marca.Items.Clear();
cmb_marca.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
}
protected void CargarRegion()
{
RadComboBox cmb_region = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_region") as RadComboBox;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
DataTable dtr = oCoon.ejecutarDataTable("UP_WEBXPLORA_OBTENER_MALLA_BY_CHANNEL_AND_CLIENTE", sidcanal, iidcompany);
cmb_region.DataSource = dtr;
cmb_region.DataValueField = "id_malla";
cmb_region.DataTextField = "malla";
cmb_region.DataBind();
cmb_region.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
private void Cobertura()
{
string canal = this.Session["Canal"].ToString().Trim();
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
DataTable dtc = null;
dtc = oCoon.ejecutarDataTable("UP_WEBXPLORA_CARGARCOBERTURA_COLGATE", iidcompany, canal);
cmb_cobertura.DataSource = dtc;
cmb_cobertura.DataValueField = "cod_Agrupacion";
cmb_cobertura.DataTextField = "Oficina_descripcion";
cmb_cobertura.DataBind();
}
protected void RadGrid_parametros_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
UpdatePanel up_filtros = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("up_filtros") as UpdatePanel;
ModalPopupExtender mpe_ver = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("mpe_ver") as ModalPopupExtender;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
if (e.CommandName == "BUSCAR")
{
Label lbl_id_año = (Label)e.Item.FindControl("lbl_id_año");
Label lbl_id_mes = (Label)e.Item.FindControl("lbl_id_mes");
Label lbl_id_periodo = (Label)e.Item.FindControl("lbl_id_periodo");
Label lbl_id_tipoCiudad = (Label)e.Item.FindControl("lbl_id_tipoCiudad");
Label lbl_id_oficina = (Label)e.Item.FindControl("lbl_id_oficina");
Label lbl_id_cadena = (Label)e.Item.FindControl("lbl_id_cadena");
ImageButton imgBtn_buscar = (ImageButton)e.Item.FindControl("btn_img_buscar");
cmb_año.SelectedIndex = cmb_año.Items.FindItemIndexByValue(lbl_id_año.Text);
cmb_mes.SelectedIndex = cmb_mes.Items.FindItemIndexByValue(lbl_id_mes.Text);
cargarPeriodo();
cmb_periodo.SelectedIndex = cmb_periodo.Items.FindItemIndexByValue(lbl_id_periodo.Text);
cmb_cobertura.SelectedIndex = cmb_cobertura.Items.FindItemIndexByValue(lbl_id_tipoCiudad.Text);
cmb_ciudad.SelectedIndex = cmb_ciudad.Items.FindItemIndexByValue(lbl_id_oficina.Text);
cmb_cadena.SelectedIndex = cmb_cadena.Items.FindItemIndexByValue(lbl_id_cadena.Text);
up_filtros.Update();
}
if (e.CommandName == "ELIMINAR")
{
Label lbl_id = (Label)e.Item.FindControl("lbl_id");
string path = Server.MapPath("~/parametros.xml");
Reportes_parametros oReportes_parametros = new Reportes_parametros();
oReportes_parametros.Id = Convert.ToInt32(lbl_id.Text);
Reportes_parametrosToXml oReportes_parametrosToXml = new Reportes_parametrosToXml();
oReportes_parametrosToXml.DeleteElement(oReportes_parametros, path);
cargarParametrosdeXml();
mpe_ver.Show();
}
}
public void llenargrilla()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
int icompany = Convert.ToInt32(this.Session["companyid"]);
int iservicio = Convert.ToInt32(this.Session["Service"]);
string canal = this.Session["Canal"].ToString().Trim();
int Report = Convert.ToInt32(this.Session["Reporte"]);
Conexion cn = new Conexion();
ds = cn.ejecutarDataSet("UP_WEBXPLORA_CLIE_V2_REPORTE_PROMOCIONES_COLGATE", canal, iservicio, icompany, cmb_año.SelectedValue, cmb_mes.SelectedValue, cmb_periodo.SelectedValue);
}
public void cargarMenu()
{
MenuService1.MenuServiceClient client = new MenuService1.MenuServiceClient("BasicHttpBinding_IMenuService");
RadMenu rad_menu = RadPanelBar_menu.FindChildByValue <RadPanelItem>("menu").FindControl("rad_menu") as RadMenu;
string dataJson;
string request;
request = "{'i':'" + Session["id_menu"].ToString() + "'}";
dataJson = client.ObtenerMenuDetalle(request);
//MenuServiceResponse menuServiceResponse = HelperJson.Deserialize<MenuServiceResponse>(dataJson);
MenuLoadUtil oLoadMenu = new MenuLoadUtil();
//rad_menu = oLoadMenu.LoadRadMenu(rad_menu, menuServiceResponse);
}
private void CargarMarcas()
{
RadComboBox cmb_marca = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_marca") as RadComboBox;
RadComboBox cmb_categoria = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_categoria") as RadComboBox;
DataTable dtm = null;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
dtm = oCoon.ejecutarDataTable("UP_WEBXPLORA_CLIEN_V2_LLENARMARCAS_PRECIOS", cmb_categoria.SelectedValue, 0, iidcompany);
cmb_marca.DataSource = dtm;
cmb_marca.DataValueField = "id_Brand";
cmb_marca.DataTextField = "Name_Brand";
cmb_marca.DataBind();
cmb_marca.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
private void CargarCategorias()
{
RadComboBox cmb_categoria = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_categoria") as RadComboBox;
DataTable dtcatego = null;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
Report = Convert.ToInt32(this.Session["Reporte"]);
dtcatego = Get_DataClientes.Get_Obtenerinfocombos_F(iidcompany, sidcanal, Report, "0", 2);
cmb_categoria.DataSource = dtcatego;
cmb_categoria.DataValueField = "cod_catego";
cmb_categoria.DataTextField = "Name_Catego";
cmb_categoria.DataBind();
cmb_categoria.Items.Insert(0, new RadComboBoxItem("--Seleccione--", "0"));
}
protected void buttonGuardar_Click(object sender, EventArgs e)
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
TextBox txt_descripcion_parametros = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("txt_descripcion_parametros") as TextBox;
ModalPopupExtender mpe_ver = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("mpe_ver") as ModalPopupExtender;
string path = Server.MapPath("~/parametros.xml");
Reportes_parametros oReportes_parametros = new Reportes_parametros();
oReportes_parametros.Id_reporte = Convert.ToInt32(this.Session["Reporte"]);
oReportes_parametros.Id_user = this.Session["sUser"].ToString();
oReportes_parametros.Id_compañia = Convert.ToInt32(this.Session["companyid"]);
oReportes_parametros.Id_servicio = Convert.ToInt32(this.Session["Service"]);
oReportes_parametros.Id_canal = this.Session["Canal"].ToString().Trim();
oReportes_parametros.Id_TipoCiudad = Convert.ToInt32(cmb_cobertura.SelectedValue);
oReportes_parametros.Id_oficina = Convert.ToInt32(cmb_ciudad.SelectedValue);
oReportes_parametros.Icadena = (cmb_cadena.SelectedValue == "") ? 0 : Convert.ToInt32(cmb_cadena.SelectedValue);
oReportes_parametros.Id_año = cmb_año.SelectedValue;
oReportes_parametros.Id_mes = cmb_mes.SelectedValue;
oReportes_parametros.Id_periodo = Convert.ToInt32(cmb_periodo.SelectedValue);
oReportes_parametros.Descripcion = txt_descripcion_parametros.Text.Trim();
oReportes_parametros.Id_tipoReporte = this.Request.Path;
Reportes_parametrosToXml oReportes_parametrosToXml = new Reportes_parametrosToXml();
if (!System.IO.File.Exists(path))
{
oReportes_parametrosToXml.createXml(oReportes_parametros, path);
}
else
{
oReportes_parametrosToXml.addToXml(oReportes_parametros, path);
}
cargarParametrosdeXml();
mpe_ver.Show();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
cmb_año.DataBind();
cmb_año.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_mes.DataBind();
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cargarMenu();
llenar_Años();
llenar_Meses();
llenargrilla();
}
}
private void ConfigurarControles()
{
string sidperdil = this.Session["Perfilid"].ToString();
sidcanal = this.Session["Canal"].ToString();
if (sidperdil == ConfigurationManager.AppSettings["PerfilAnalista"])
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("configuracion").Visible = true;
if (sidcanal == "1023")
{
RadPageView_Parametrizacion.Visible = true;
cargarCategorias();
cargarListaGraficos();
cargarProductos();
}
}
else
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("configuracion").Visible = false;
}
}
public void cargarPeriodo()
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
Report = Convert.ToInt32(this.Session["Reporte"]);
iservicio = Convert.ToInt32(this.Session["Service"]);
cmb_periodo.Items.Clear();
cmb_periodo.Enabled = true;
DataTable dtp = null;
dtp = oCoon.ejecutarDataTable("UP_WEBXPLORA_CLIE_V2_OBTENER_PERIODOS_POR_MES", iservicio, sidcanal, iidcompany, Report, cmb_año.SelectedValue, cmb_mes.SelectedValue);
cmb_periodo.DataSource = dtp;
cmb_periodo.DataValueField = "ReportsPlanning_Periodo";
cmb_periodo.DataTextField = "Descripcion";
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Seleccione--", "0"));
}
private void cargarReportSOD()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
RadComboBox cmb_marca = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_marca") as RadComboBox;
RadComboBox cmb_categoria = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_categoria") as RadComboBox;
RadComboBox cmb_region = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_region") as RadComboBox;
Informes_validacion.UC_ValidarPeriodos UC_ValidarPeriodos1 = RadPanelBar_menu.FindChildByValue <RadPanelItem>("validar").FindControl("UC_ValidarPeriodos1") as Informes_validacion.UC_ValidarPeriodos;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
Report = Convert.ToInt32(this.Session["Reporte"]);
iservicio = Convert.ToInt32(this.Session["Service"]);
string sidperdil = this.Session["Perfilid"].ToString();
string año, mes, periodo;
string validacion;
año = cmb_año.SelectedValue;
mes = cmb_mes.SelectedValue;
if (cmb_año.SelectedValue == "0" && cmb_mes.SelectedValue == "0")
{
P.Servicio = iservicio;
P.Canal = sidcanal;
P.Cliente = iidcompany;
P.SetPeriodoInicial_SOD();
año = P.Año;
mes = P.Mes;
cmb_año.SelectedIndex = cmb_año.Items.FindItemIndexByValue(año);
cmb_mes.SelectedIndex = cmb_mes.Items.FindItemIndexByValue(mes);
}
if (sidperdil == ConfigurationManager.AppSettings["PerfilAnalista"])
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("itemValidacion").Visible = true;
UC_ValidarPeriodos1.SetValidacion(iservicio, sidcanal, iidcompany, Report, año, mes, "1");
validacion = "0";
}
else
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("itemValidacion").Visible = false;
validacion = "1";
}
Reporte_contenido.Visible = true;
Reporte_contenido.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
Reporte_contenido.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.Percent;
Reporte_contenido.ServerReport.ReportPath = "/Reporte_Precios_V1/Evolucion_SOD_Mayorista";
String strConnection = ConfigurationManager.AppSettings["SERVIDOR_REPORTING_SERVICES"];
Reporte_contenido.ServerReport.ReportServerUrl = new Uri(strConnection);
Reporte_contenido.ServerReport.ReportServerCredentials = new CFG.Tools.ReportServerNetCredentials();
List <Microsoft.Reporting.WebForms.ReportParameter> parametros = new List <Microsoft.Reporting.WebForms.ReportParameter>();
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("AÑO", cmb_año.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("MES", cmb_mes.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("OFICINA", "0"));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CATEGORIA", (cmb_categoria.SelectedValue == "0" ? "12" : cmb_categoria.SelectedValue)));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("MARCA", cmb_marca.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("PDV", "0"));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CANAL", sidcanal));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CLIENTE", iidcompany.ToString()));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("SERVICIO", iservicio.ToString()));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("ValidAnalyst", validacion));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("id_mallas", (cmb_region.SelectedValue == "0" ? "2" : cmb_region.SelectedValue)));
Reporte_contenido.ServerReport.SetParameters(parametros);
}
private void cargarReporte()
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
Informes_validacion.UC_ValidarPeriodos UC_ValidarPeriodos1 = RadPanelBar_menu.FindChildByValue <RadPanelItem>("validar").FindControl("UC_ValidarPeriodos1") as Informes_validacion.UC_ValidarPeriodos;
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
Report = Convert.ToInt32(this.Session["Reporte"]);
iservicio = Convert.ToInt32(this.Session["Service"]);
string sidperdil = this.Session["Perfilid"].ToString();
string id_categoria, año, mes, periodo;
bool validacion;
id_categoria = Request.QueryString["cod"];
año = cmb_año.SelectedValue;
mes = cmb_mes.SelectedValue;
periodo = cmb_periodo.SelectedValue;
if (cmb_año.SelectedValue == "0" && cmb_mes.SelectedValue == "0")
{
P.Servicio = iservicio;
P.Canal = sidcanal;
P.Cliente = iidcompany;
P.SetPeriodoInicial_Presencia();
año = P.Año;
mes = P.Mes;
periodo = P.PeriodoId;
cmb_año.SelectedIndex = cmb_año.Items.FindItemIndexByValue(año);
cmb_mes.SelectedIndex = cmb_mes.Items.FindItemIndexByValue(mes);
cargarPeriodo();
cmb_periodo.SelectedIndex = cmb_periodo.Items.FindItemIndexByValue(periodo);
}
if (sidperdil == ConfigurationManager.AppSettings["PerfilAnalista"])
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("itemValidacion").Visible = true;
RadPanelBar_menu.FindChildByValue <RadPanelItem>("configuracion").Visible = true;
UC_ValidarPeriodos1.SetValidacion(iservicio, sidcanal, iidcompany, Report, año, mes, periodo);
validacion = false;
}
else
{
RadPanelBar_menu.FindChildByValue <RadPanelItem>("itemValidacion").Visible = false;
RadPanelBar_menu.FindChildByValue <RadPanelItem>("configuracion").Visible = false;
validacion = true;
}
Reporte.Visible = true;
Reporte.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
Reporte.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.Percent;
Reporte.ServerReport.ReportPath = "/Reporte_Precios_V1/Reporte_IndexPriceDetail";
string strConnection = ConfigurationManager.AppSettings["SERVIDOR_REPORTING_SERVICES"];
Reporte.ServerReport.ReportServerUrl = new Uri(strConnection);
Reporte.ServerReport.ReportServerCredentials = new CFG.Tools.ReportServerNetCredentials();
List <Microsoft.Reporting.WebForms.ReportParameter> parametros = new List <Microsoft.Reporting.WebForms.ReportParameter>();
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("AÑO", año));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("MES", mes));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("PERIODO", periodo));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CIUDAD", cmb_ciudad.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CADENA", cmb_cadena.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("TIPOCIUDAD", cmb_cobertura.SelectedValue));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CANAL", sidcanal));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("CLIENTE", iidcompany.ToString()));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("SERVICIO", iservicio.ToString()));
parametros.Add(new Microsoft.Reporting.WebForms.ReportParameter("VALIDANALYST", validacion.ToString()));
Reporte.ServerReport.SetParameters(parametros);
}
