protected void Load_ListBox()
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cAppVistasCliente oAppVistasCliente = new cAppVistasCliente(ref oConn);
oAppVistasCliente.CodCliente = CodCliente.Value;
oAppVistasCliente.NotIn = true;
DataTable dtVistaCliente = oAppVistasCliente.Get();
if (dtVistaCliente != null)
{
foreach (DataRow oRow in dtVistaCliente.Rows)
{
ListBox1.Items.Add(new ListItem(oRow["desc_monitor_view"].ToString(), oRow["cod_monitor"].ToString()));
}
}
dtVistaCliente = null;
oAppVistasCliente.NotIn = false;
dtVistaCliente = oAppVistasCliente.Get();
if (dtVistaCliente != null)
{
foreach (DataRow oRow in dtVistaCliente.Rows)
{
ListBox2.Items.Add(new ListItem(oRow["desc_monitor_view"].ToString(), oRow["cod_monitor"].ToString()));
}
}
dtVistaCliente = null;
oConn.Close();
}
}
protected void btnAgregar_Click(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
if (ListBox1.SelectedIndex >= 0)
{
cAppVistasCliente oAppVistasCliente = new cAppVistasCliente(ref oConn);
for (int i = 0; i < ListBox1.Items.Count; i++)
{
if (ListBox1.Items[i].Selected)
{
oAppVistasCliente.CodCliente = CodCliente.Value;
oAppVistasCliente.CodMonitor = ListBox1.Items[i].Value;
oAppVistasCliente.Accion = "CREAR";
oAppVistasCliente.Put();
}
}
ListBox1.Items.Clear();
ListBox2.Items.Clear();
Load_ListBox();
}
oConn.Close();
}
}
protected void LoadGrid()
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cAppVistasCliente oAppVistasCliente = new cAppVistasCliente(ref oConn);
oAppVistasCliente.CodCliente = CodCliente.Value;
oAppVistasCliente.NotIn = false;
gridVistas.DataSource = oAppVistasCliente.Get();
gridVistas.DataBind();
oConn.Close();
}
}
protected void getMonitores()
{
StringBuilder sUrlPage;
StringBuilder sHtml = new StringBuilder();
dcControlPanel.Conn.DBConn oConn = new dcControlPanel.Conn.DBConn();
if (oConn.Open())
{
cAppVistasCliente oAppVistasCliente = new cAppVistasCliente(ref oConn);
oAppVistasCliente.CodCliente = oIsUsuario.CodUsuario;
oAppVistasCliente.NotIn = false;
DataTable DataVista = oAppVistasCliente.Get();
foreach (DataRow oRow in DataVista.Rows)
{
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = oRow["cod_monitor"].ToString();
DataTable dtmPage = oAptMonitorPages.Get();
if (dtmPage != null)
{
if (dtmPage.Rows.Count > 0)
{
string indexToken = string.Empty;
if (string.IsNullOrEmpty(dtmPage.Rows[0]["cod_cliente"].ToString()))
{
indexToken = oRow["cod_monitor"].ToString() + DateTime.Now.ToString("yyyyMMdd");
Session[indexToken] = 0;
}
sUrlPage = new StringBuilder();
sUrlPage.Append(dtmPage.Rows[0]["url_page"].ToString());
sUrlPage.Append("?codmonitor=").Append(oRow["cod_monitor"].ToString());
sUrlPage.Append("&codusuario=").Append(oIsUsuario.CodUsuario);
sUrlPage.Append("&authuser="******"&indexToken=").Append(indexToken);
sUrlPage.Append("&order=").Append(dtmPage.Rows[0]["order_page"].ToString());
sHtml.Append("<div class=\"col-md-6 wow fadeInUp\" data-wow-duration=\"4s\" data-wow-delay=\"1s\">");
sHtml.Append("<iframe src =\"/PaneldeControl/" + sUrlPage.ToString() + "\" width=\"600px\" height=\"300px\" scrolling=\"no\"></iframe>");
sHtml.Append("</div>");
}
}
}
idpanel.Controls.Add(new LiteralControl(sHtml.ToString()));
}
oConn.Close();
}
protected void gridPages_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
string pCodMonitor = gridPages.DataKeys[e.RowIndex].Value.ToString();
cAptMonitorMensaje oAptMonitorMensaje = new cAptMonitorMensaje(ref oConn);
oAptMonitorMensaje.CodMonitor = pCodMonitor;
oAptMonitorMensaje.Accion = "ELIMINAR";
oAptMonitorMensaje.Put();
if (!string.IsNullOrEmpty(oAptMonitorMensaje.Error))
{
Response.Write(oAptMonitorMensaje.Error);
Response.End();
}
cAptClientesMonitorpages oAptClientesMonitorpages = new cAptClientesMonitorpages(ref oConn);
oAptClientesMonitorpages.CodMonitor = pCodMonitor;
oAptClientesMonitorpages.Accion = "ELIMINAR";
oAptClientesMonitorpages.Put();
if (!string.IsNullOrEmpty(oAptClientesMonitorpages.Error))
{
Response.Write(oAptClientesMonitorpages.Error);
Response.End();
}
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = pCodMonitor;
oAptMonitorPages.Accion = "ELIMINAR";
oAptMonitorPages.Put();
if (!string.IsNullOrEmpty(oAptMonitorPages.Error))
{
Response.Write(oAptMonitorPages.Error);
Response.End();
}
cAppVistasCliente oAppVistasCliente = new cAppVistasCliente(ref oConn);
oAppVistasCliente.CodMonitor = pCodMonitor;
oAppVistasCliente.Accion = "ELIMINAR";
oAppVistasCliente.Put();
if (!string.IsNullOrEmpty(oAppVistasCliente.Error))
{
Response.Write(oAppVistasCliente.Error);
Response.End();
}
cAppMonitorView oAppMonitorView = new cAppMonitorView(ref oConn);
oAppMonitorView.CodMonitor = pCodMonitor;
oAppMonitorView.Accion = "ELIMINAR";
oAppMonitorView.Put();
if (!string.IsNullOrEmpty(oAptMonitorPages.Error))
{
Response.Write(oAptMonitorPages.Error);
Response.End();
}
oConn.Close();
}
}
catch (Exception ex)
{
Response.Write(ex.Message + "; " + ex.InnerException.ToString());
}
LoadGrid();
}
