protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
if (Session["UiQueryList"] != null)
{
UiQueryList.DataSource = Session["UiQueryList"];
UiQueryList.DataBind();
}
if (Session["UiLookupTeam"] != null)
{
UiLookupTeam.DataSource = Session["UiLookupTeam"];
UiLookupTeam.DataBind();
}
if (Session["UiGridLookupListaQuery"] != null)
{
UiGridLookupListaQuery.DataSource = Session["UiGridLookupListaQuery"];
UiGridLookupListaQuery.DataBind();
}
}
catch (Exception ex)
{
EstablecerError(ex.Message, sender);
}
}
public void CargarLayout(string LoginId, int QueryId)
{
try
{
var pResult = "";
var ds = _objQueryList.GetStatusByQueryList(Session["connectionString"].ToString(), QueryId, LoginId, ref pResult);
if (ds.Tables[0].Rows.Count > 0)
{
UiQueryList.LoadClientLayout(ds.Tables[0].Rows[0].ItemArray[2].ToString());
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void CargarConsulta()
{
try
{
var pResult = "";
var LoginId = Session["LOGIN"].ToString();
var IdQuery = UiGridLookupListaQuery.Text.Split(';')[0];
var QueryTitle = UiGridLookupListaQuery.Text.Split(';')[1];
var sWhere = "";
var ds = _objQueryList.GetQuerySelected(Session["connectionString"].ToString(), Convert.ToInt32(IdQuery), sWhere, LoginId, ref pResult);
if (pResult == "")
{
Session["UiQueryList"] = ds;
UiQueryList.Columns.Clear();
UiQueryList.AutoGenerateColumns = true;
UiQueryList.KeyFieldName = string.Empty;
UiQueryList.DataSource = ds;
UiQueryList.FilterExpression = "";
UiQueryList.Caption = QueryTitle.ToString();
UiQueryList.DataBind();
CargarLayout(LoginId, Convert.ToInt32(IdQuery));
CargaPermisos(IdQuery);
((ASPxGridView)(UiQueryList)).JSProperties.Add("cpTerminoDeProcesarQuery", true);
}
else
{
Session["UiQueryList"] = null;
UiQueryList.DataSource = null;
UiQueryList.KeyFieldName = string.Empty;
UiQueryList.Caption = "";
UiQueryList.FilterExpression = "";
UiQueryList.Columns.Clear();
UiQueryList.DataBind();
UiLookupTeam.Text = "";
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void GrabarLayout()
{
try
{
var pResult = "";
var Layout = UiQueryList.SaveClientLayout();
var LoginId = Session["LOGIN"].ToString();
var IdQuery = UiGridLookupListaQuery.Text.Split(';')[0];
var ds = _objQueryList.InsertUpdateXMLQuery(Session["connectionString"].ToString(), Convert.ToInt32(IdQuery), LoginId, Layout, ref pResult);
if (pResult == "")
{
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void UiQueryList_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
switch (e.Parameters.Split('|')[0])
{
case "ExpandirGrupoVistaGeneral":
UiQueryList.ExpandAll();
break;
case "ContraerGrupoVistaGeneral":
UiQueryList.CollapseAll();
break;
}
}
catch (Exception ex)
{
EstablecerError(ex.Message, sender);
}
}
