Fecha Final : .
Hora Inicio: 2:06 PM
Hora Final: .8:47 PM
Horas invertidas(Minutos): .275
Colaboradores: Wilson Lopez, Oscar Cortés.
Actividad
Continuar paginas web
Inicio Abonado
Panel Administrador
Configuración (Administrador)
Login
Consulta Recibo
Codigo
Inicio Abonado
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Inicio.aspx.cs" Inherits="ProyectoEvaluaciones_BDI.Inicio" %>
<!DOCTYPE html>
<html lang ="en">
<head runat="server">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Inicio</title>
</head>
<body>
<form id="form1" runat="server">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="Inicio.aspx">Plantilla</a>
</div>
<ul class="nav navbar-nav">
<li class="active"><a href="LogIn.aspx">Salir</a></li>
</ul>
</div>
</nav>
<div class="container">
<h2>Pagina para Abonados</h2>
<asp:Panel ID="PL_Cursos" runat="server" CssClass="panel-group">
<div class="panel panel-primary">
<div class="panel-heading">
<table style="width:50%;">
<tr>
<td class="auto-style1"> Filtrado de recibos: </td>
<td> <asp:RadioButton runat="server" text ="Todos"/> </td>
<td> <asp:RadioButton runat="server" text ="Pendientes"/> </td>
<td> <asp:RadioButton runat="server" text ="Cancelados"/> </td>
</tr>
</table>
</div>
</div>
<div class="panel panel-default">
<asp:Panel runat="server" ID ="PL_ListadoRecibos"> </asp:Panel>
<div class="panel-body"> Resultado de la busqueda.</div>
<p> Propiedad.</p>
<p> Mes.</p>
<p> Monto.</p>
<p> Pagar.</p>
<p> Consultar.</p>
</div>
</asp:Panel>
</div>
<div class="container">
<div class="row">
<div class="col-sm-4">
<h3>Proyecto Programado 2</h3>
<p>Bases de Datos I</p>
<p>Grupo 1</p>
</div>
<div class="col-sm-4">
<h3>Cobro para municipalidades</h3>
<p>En esta pagina de muestra puedes cargar los datos de las municipalidades para realizar cobros a los clientes.</p>
</div>
<div class="col-sm-4">
<h3>Desarrolladores</h3>
<p>Óscar Cortés Cordero - 2016136191</p>
<p>Wilson Lopez - 2014118649</p>
</div>
</div>
</div>
</form>
</body>
</html>
Panel Administrador
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PanelAdministrador.aspx.cs" Inherits="ProyectoEvaluaciones_BDI.PanelAdministrador" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Panel Administrador</title>
<link rel="shortcut icon" type="image/x-icon" href="images/Ico.ico" />
<meta name="description" content="">
<meta name="author" content="templatemo">
<!--
Visual Admin Template
http://www.templatemo.com/preview/templatemo_455_visual_admin
-->
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,400italic,700' rel='stylesheet' type='text/css'>
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/templatemo-style.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="light-gray-bg">
<form id="form1" runat="server">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="PanelAdministrador.aspx">Gestor MuniRecibos</a>
</div>
<ul class="nav navbar-nav">
<li class="active"><a href="Configuracion.aspx">Configuracion</a></li>
</ul>
<ul class="nav navbar-nav">
<li class="active"><a href="LogIn.aspx">Salir</a></li>
</ul>
</div>
</nav>
<div class="container">
<h2>Panel de Administrador</h2>
<br />
<asp:Panel runat="server">
<asp:Button runat="server" Text ="Cortes de conexión de agua" OnClick="ChangeDisplayerIndex" CommandArgument="0"/>
<asp:Button runat="server" Text ="Usuarios con morosidad más alta" OnClick="ChangeDisplayerIndex" CommandArgument="1"/>
<asp:Button runat="server" Text ="Distritos con morosidad más alta" OnClick="ChangeDisplayerIndex" CommandArgument="2"/>
</asp:Panel>
<br /> <br />
<asp:MultiView ID="MV_Displayer" runat="server" ActiveViewIndex="0">
<asp:View runat="server">
Cortes de conexión de agua<br />
<asp:Panel runat="server" CssClass="table-responsive" ID="PL_CorteAgua" >
</asp:Panel>
</asp:View>
<asp:View runat="server">
Morosidad más alta<br />
<asp:Panel runat="server" CssClass="table-responsive" ID="PL_MorosidadUsuarios" >
</asp:Panel>
</asp:View>
<asp:View runat="server">
Distrito con mayor morosidad<br />
<asp:Panel runat="server" CssClass="table-responsive" ID="PL_MorosidadDistritos" >
</asp:Panel>
</asp:View>
</asp:MultiView>
</div>
</form>
</body>
</html>
Configuracion (Administrador)
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Configuracion.aspx.cs" Inherits="ProyectoEvaluaciones_BDI.Configuracion" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Configuracion</title>
<link rel="shortcut icon" type="image/x-icon" href="images/Ico.ico" />
<meta name="description" content="">
<meta name="author" content="templatemo">
<!--
Visual Admin Template
http://www.templatemo.com/preview/templatemo_455_visual_admin
-->
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,400italic,700' rel='stylesheet' type='text/css'>
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/templatemo-style.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="light-gray-bg">
<form id="form1" runat="server">
<div>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="PanelAdministrador.aspx">Gestor MuniRecibos</a>
</div>
<ul class="nav navbar-nav">
<li class="active"><a href="Configuracion.aspx">Configuracion</a></li>
</ul>
<ul class="nav navbar-nav">
<li class="active"><a href="LogIn.aspx">Salir</a></li>
</ul>
</div>
</nav>
<div class="container">
<h2>Configuración del sistema</h2>
<table style="width:100%;">
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Nombre de la municipalidad:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_Nombre" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Dia para emitir recibos:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_diaEmite" runat="server" class="form-control" placeholder="Dia en que se generan los recibos" onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Dia limite:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_DiaLimite" runat="server" class="form-control" placeholder="Dia maximo para pagar..." onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Valor cubico del agua:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_Interes" runat="server" class="form-control" placeholder="Interes a cobrar a los morosos..." onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Valor cubico del agua:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_ValorAgua" runat="server" class="form-control" placeholder="Valor.." onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">
<asp:Button ID="Button1" runat="server" Text="Cancelar"
class="templatemo-blue-button width-80"/>
</td>
<td class="auto-style2">
<asp:Button ID="Btn_IniciarSesion" runat="server" Text="Guardar"
class="templatemo-blue-button width-80"/>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1"> </td>
<td class="auto-style2">
<asp:Label runat="server" ID="LB_Notificador" Text =""> </asp:Label>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
Login
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LogIn.aspx.cs" Inherits="ProyectoEvaluaciones_BDI.LogIn" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>MuniRecibos - Login</title>
<link rel="shortcut icon" type="image/x-icon" href="images/Ico.ico" />
<meta name="description" content="">
<meta name="author" content="templatemo">
<!--
Visual Admin Template
http://www.templatemo.com/preview/templatemo_455_visual_admin
-->
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,400italic,700' rel='stylesheet' type='text/css'>
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/templatemo-style.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="light-gray-bg">
<div class="templatemo-content-widget templatemo-login-widget white-bg">
<header class="text-center">
<div class="square"></div>
<h1>MuniRecibos</h1>
</header>
<form id="form1" runat="server">
<div>
<table style="width:100%;">
<tr>
<td class="auto-style1">Usuario:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_User" runat="server" class="form-control" placeholder="js@dashboard.com"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1"> </td>
<td class="auto-style2">
<asp:Button ID="Btn_IniciarSesion" runat="server" Text="Iniciar sesión"
class="templatemo-blue-button width-100" OnClick="Btn_IniciarSesion_Click" />
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1"> </td>
<td class="auto-style2">
<asp:Label runat="server" ID="LB_Notificador" Text =""> </asp:Label>
</td>
</tr>
</table>
</div>
</form>
</div>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Recibos.aspx.cs" Inherits="ProyectoEvaluaciones_BDI.Recibos" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Recibo</title>
<link rel="shortcut icon" type="image/x-icon" href="images/Ico.ico" />
<meta name="description" content="">
<meta name="author" content="templatemo">
<!--
Visual Admin Template
http://www.templatemo.com/preview/templatemo_455_visual_admin
-->
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,400italic,700' rel='stylesheet' type='text/css'>
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/templatemo-style.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="light-gray-bg">
<form id="form1" runat="server">
<div>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="Inicio.aspx">Gestor MuniRecibos</a>
</div>
<ul class="nav navbar-nav">
<li class="active"><a href="LogIn.aspx">Salir</a></li>
</ul>
</div>
</nav>
<div class="container">
<h2>Detalle del recibo</h2>
<br />
<asp:Button runat ="server" ID ="BTN_Cancelar" CssClass="btn-primary" Text ="Pagar recibo" />
<br />
<table style="width:80%;" >
<tr>
<td class="auto-style1">Número de abonado:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_NumeroAbonado" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
<td></td>
<td></td>
<td class="auto-style1">Mes:</td>
<td class="auto-style2">
<asp:TextBox ID="TB_Mes" runat="server" class="form-control" placeholder="Mes del recibo" onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Nombre:</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox1" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
<td class="auto-style1">Identificación:</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox2" runat="server" class="form-control" placeholder="Mes del recibo" onkeydown = "return (!(event.keyCode>=65) && event.keyCode!=32);"></asp:TextBox>
</td>
<td></td>
<td></td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td class="auto-style1">Interes:</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox3" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
<td class="auto-style1">Total a pagar:</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox5" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
<td class="auto-style1">Fecha limite:</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox6" Enabled ="false" runat="server" class="form-control" placeholder="No se puede cambiar"></asp:TextBox>
</td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
</table>
<asp:Panel runat ="server" ID="PL_LineasRecibo">
</asp:Panel>
</div>
</div>
</form>
</body>
</html>
Descanso
Hora Inicio: 4:18 PM
Hora Final: .6:24 PM
Horas invertidas(Minutos): 126
Problemas
Usar SSMS en la misma computadora que creamos la pagina web
[Solución] Aun nada. Se instalo la local db de Express pero ni de esta u otra manera se logro que SSMS detectara algun servidor.
Referencias
https://stackoverflow.com/questions/9193746/can-sql-server-express-localdb-be-connected-to-remotely
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb?view=sql-server-2017
https://stackoverflow.com/questions/42951632/sql-server-express-localdb-msi-offline-installer
https://www.sqlshack.com/install-microsoft-sql-server-express-localdb/
No hay comentarios.:
Publicar un comentario