protected void kysGecikmePivot_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
//EFDal ed = new EFDal();
//kysGecikmePivot.DataSource = ed.vKYSGecikme();
//kysGecikmePivot.DataBind();
(sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM vKYSGecikme");
}
protected void kysGecikmePivot_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
//EFDal ed = new EFDal();
//kysGecikmePivot.DataSource = ed.vKYSGecikme();
//kysGecikmePivot.DataBind();
(sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM vKYSGecikme");
}
protected void pgDetallada_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
//ConsultaPersonalNegocio neg = new ConsultaPersonalNegocio();
//List<E_CONSULTA_DETALLE> lstConsulta = neg.obtieneConsultaPersonalDetallada(vIdBateria).Select(s => new E_CONSULTA_DETALLE {
//CL_CLASIFICACION = s.CL_CLASIFICACION,
//CL_COLOR = s.CL_COLOR,
//CL_FACTOR = s.CL_FACTOR,
//CL_TIPO_COMPETENCIA = s.CL_TIPO_COMPETENCIA,
//CL_VARIABLE = s.CL_VARIABLE,
//DS_COMPETENCIA = s.DS_COMPETENCIA,
//DS_FACTOR = s.DS_FACTOR,
//ICONO = ObtenerIconoDetalle(s.NO_VALOR),
//ID_FACTOR = s.ID_FACTOR,
//ID_COMPETENCIA = s.ID_COMPETENCIA,
//ID_VARIABLE = s.ID_VARIABLE,
//NO_VALOR= s.NO_VALOR,
//NB_FACTOR = s.NB_FACTOR,
//NB_ABREVIATURA = s.NB_ABREVIATURA,
//NB_COMPETENCIA = s.NB_COMPETENCIA,
//NB_PRUEBA = s.NB_PRUEBA,
//NB_CLASIFICACION_COMPETENCIA = s.NB_CLASIFICACION_COMPETENCIA
//}).ToList();
//pgDetallada.DataSource = lstConsulta;
}
protected void grdCliente_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
try {
grdCliente.DataSource =
JsonHelper.JsonDeserialize <List <gsDocVenta_ReporteVenta_ClienteResult> >((string)ViewState["lstVendedor"]);
}
catch (Exception ex) {
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
protected void grdPresupuesto_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
grdPresupuesto.DataSource = JsonHelper.JsonDeserialize <List <gsPresupuesto_Reporte_MarcaResult> >((string)ViewState["lstPresupuesto"]);
}
catch (Exception ex)
{
rwmReporte.RadAlert(ex.Message, 500, 100, "Error al descargar el excel", "");
}
}
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
var orderDetails = from o in DbContext.Orders
join od in DbContext.Order_Details on o.OrderID equals od.OrderID
join p in DbContext.Products on od.ProductID equals p.ProductID
where o.OrderDate.Value.Year >= 1997
select new
{
Year = o.OrderDate.Value.Year,
Quarter = "Quarter " + ((o.OrderDate.Value.Month / 4) + 1),
ProductName = p.ProductName,
Category = p.Category.CategoryName,
TotalPrice = od.UnitPrice * od.Quantity,
Quantity = od.Quantity
};
RadPivotGrid1.DataSource = orderDetails;
}
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
var orderDetails = from o in DbContext.Orders
join od in DbContext.Order_Details on o.OrderID equals od.OrderID
join p in DbContext.Products on od.ProductID equals p.ProductID
where o.OrderDate.Value.Year >= 1997
select new
{
Year = o.OrderDate.Value.Year,
Quarter = "Quarter " + ((o.OrderDate.Value.Month / 4) + 1),
ProductName = p.ProductName,
Category = p.Category.CategoryName,
TotalPrice = od.UnitPrice * od.Quantity,
Quantity = od.Quantity
};
RadPivotGrid1.DataSource = orderDetails;
}
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
try
{
if (Session["lstPresupuestoResumen"] != null)
{
rpgResumenZona.DataSource = JsonHelper.JsonDeserialize <List <USP_SEL_VENTA_POR_VENDEDOR2> >((string)Session["lstPresupuestoResumen"]);
}
}
catch (Exception ex)
{
rwmPre.RadAlert(ex.Message, 400, null, "Mensaje de error", null);
}
}
protected void grdIndicadores_OnNeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
if (lblDate2.Text == "2")
{
grdIndicadores.DataSource = JsonHelper.JsonDeserialize <List <gsReporte_IndicadoresCreditosResult> >((string)ViewState["lstIndicadores"]);
}
}
catch (Exception ex)
{
rwmVidaLey.RadAlert(ex.Message, 500, 100, "Error al consultar el archivo", "");
}
}
protected void gsReporteVentas_Item_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
if (lblReporte.Value == "1")
{
gsReporteVentas_Item.DataSource = JsonHelper.JsonDeserialize <List <ReporteVentas_ItemsResult> >((string)ViewState["ListaReporteItem"]);
}
}
catch (Exception ex)
{
rwmReporte.RadAlert(ex.Message, 500, 100, "Error al consultar NeedDataSource", "");
}
}
protected void gsContadorSinAccesos_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
if (lblReporteS.Value == "1")
{
this.gsContadorSinAccesos.DataSource = JsonHelper.JsonDeserialize <List <usp_Sel_MenusNoAccedidosResult> >((string)ViewState["ListaMenusS"]);
}
}
catch (Exception ex)
{
rwmReporte.RadAlert(ex.Message, 500, 100, "Error al consultar NeedDataSource", "");
}
}
protected void grdComparativoPivot_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
if (ViewState["lstPlaneamiento"] != null)
{
grdComparativoPivot.DataSource = JsonHelper.JsonDeserialize <List <gsPronostico_vs_RealResult> >((string)ViewState["lstPlaneamiento"]);
//grdProducto.DataBind();
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
//if (Session["Usuario"] == null)
// Response.Redirect("~/Security/frmCerrar.aspx");
//try
//{
// //CargarPresupuestoPendiente();
// //CargarPresupuestoPromotor();
// rpgResumenZona.DataSource = JsonHelper.JsonDeserialize<List<USP_Sel_MetaPresupuestoPromotorResult>>((string)Session["lstpromotor"]);
//}
//catch (Exception ex)
//{
// lblMensaje.Text = ex.Message;
// lblMensaje.CssClass = "mensajeError";
//}
}
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
try
{
List <USP_SEL_LetrasSinCanjeV2Result> lstletras = new List <USP_SEL_LetrasSinCanjeV2Result>();
lstletras = JsonHelper.JsonDeserialize <List <USP_SEL_LetrasSinCanjeV2Result> >((string)Session["lstletrasresumen"]);
if (lstletras.Any())
{
rpgResumenZona.DataSource = lstletras;
}
}
catch (Exception ex)
{
lblMensaje.Text = "ERROR: " + ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
protected void pgDetalleCompetencia_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
pgDetalleCompetencia.DataSource = vPuestoCandidatos;
}
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
(sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM Transportation");
}
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
(sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM Transportation");
}
/// <summary>
/// داده های پایوت گیرید از طریق این متد فراهم می گردد
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="PivotGridNeedDataSourceEventArgs"/> instance containing the event data.</param>
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
(sender as RadPivotGrid).DataSource = ExamBusiness.GetAllSansCoutCity(term, Session["UserId"].ToString());
}
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
}
