protected void btnRolC_Click(object sender, EventArgs e) { try { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { int Cedula = Convert.ToInt32(txtCedula.Text); TipoUsuario CancelarRol = oConexion.TipoUsuario.Where(w => w.Cedula == Cedula).Single(); oConexion.DeleteObject(CancelarRol); oConexion.SaveChanges(); bool ee = true; if (ee == true) { Response.Write("<script LANGUAGE='JavaScript' >alert('Se Quito el Rol Correctamente')</script>"); } } } catch { Response.Write("<script LANGUAGE='JavaScript' >alert('No Se Actualizo Correctamente')</script>"); } }
protected void btnActualizar_Click(object sender, EventArgs e) { //Boton Actualizar información int cedula = Convert.ToInt32(Session["cedula"]); using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { var user = (from u in oConexion.Usuario where u.Cedula == cedula select u).First(); user.Edad = Convert.ToInt32(txtEdad.Text); user.Telefono = Convert.ToInt32(txtTelefono.Text); user.Email = txtEmail.Text; user.Direccion = txtDireccion.Text; user.NombreUsuario = txtNombre.Text; user.ApellidoUsuario = txtApellidos.Text; user.Username = txtUserName.Text; try { oConexion.SaveChanges(); Response.Write("<script LANGUAGE='JavaScript' >alert('Cambios realizados exitosamente')</script>"); } catch (Exception ex) { Label1.Text = ex.Message; Response.Write("<script LANGUAGE='JavaScript' >alert('Error!')</script>"); } } }
protected void btnRol_Click(object sender, EventArgs e) { try { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { TipoUsuario NuevoRol = new TipoUsuario(); NuevoRol.Cedula = Convert.ToInt32(txtCedula.Text); NuevoRol.IdTipoUsuario = Convert.ToInt32(ddlTipo.SelectedValue); NuevoRol.NombreTipoUsuario = ddlTipo.SelectedItem.Text; oConexion.TipoUsuario.AddObject(NuevoRol); oConexion.SaveChanges(); bool n = true; if (n == true) { txtCedula.Text = ""; Response.Write("<script LANGUAGE='JavaScript' >alert('Se Asigno el Rol Correctamente')</script>"); } } } catch { Response.Write("<script LANGUAGE='JavaScript' >alert('Ingrese Nuevamente la Cedula Deseada')</script>"); } }
protected void btnConsultas_Click(object sender, EventArgs e) { try { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { int ced = Convert.ToInt32(Session["cedula"]); List <UsuarioCitas> resultado = (from c in oConexion.Usuario join f in oConexion.Cita on c.Cedula equals f.Cedula where f.Cedula == ced select new UsuarioCitas() { CodigoCita = f.IdCita, Cedula = c.Cedula, Nombre = c.NombreUsuario, Apellido = c.ApellidoUsuario, Lugar = f.LugarCita, Fecha = f.FechaCita, Hora = f.HoraCita } ).ToList(); GriewCitas.DataSource = resultado; GriewCitas.DataBind(); } txtHoraCita.Enabled = true; DropDownList1.Enabled = true; } catch { Response.Write("<script LANGUAGE='JavaScript' >alert('Revise los Datos Ingresados')</script>"); } }
protected void btnCancelar_Click(object sender, EventArgs e) { try { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { int cita = Convert.ToInt32(txtIdCita.Text); Cita CancelarCita = oConexion.Cita.Where(w => w.IdCita == cita).Single(); oConexion.DeleteObject(CancelarCita); oConexion.SaveChanges(); bool ee = true; if (ee == true) { Response.Write("<script LANGUAGE='JavaScript' >alert('Se Cancelo la Cita Correctamente')</script>"); List <UsuarioCitas> resultado = (from c in oConexion.Usuario join f in oConexion.Cita on c.Cedula equals f.Cedula where f.IdCita == cita select new UsuarioCitas() { CodigoCita = f.IdCita, Cedula = c.Cedula, Nombre = c.NombreUsuario, Apellido = c.ApellidoUsuario, Lugar = f.LugarCita, Fecha = f.FechaCita, Hora = f.HoraCita } ).ToList(); GriewCitas.DataSource = resultado; GriewCitas.DataBind(); } } txtHoraCita.Enabled = true; DropDownList1.Enabled = true; } catch { Response.Write("<script LANGUAGE='JavaScript' >alert('Revise los Datos Ingresados')</script>"); } }
protected void btnCambiarPass_Click(object sender, EventArgs e) { LabelMensajePass.Text = ""; string passss = EncriptacionMD5(txtPass.Text); int cedula = Convert.ToInt32(Session["cedula"]); ClinicaWebEntities db = new ClinicaWebEntities(); string cambiarpass = (from c in db.Usuario where c.Cedula == cedula select c.contrasena).FirstOrDefault(); if (cambiarpass == passss.ToUpper()) { if ((EncriptacionMD5(txtNewPass.Text).Equals(EncriptacionMD5(txtValidarPass.Text))) && (txtValidarPass.Text != "")) { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { var User = (from c in oConexion.Usuario where c.Cedula == cedula select c).SingleOrDefault(); User.contrasena = (EncriptacionMD5(txtNewPass.Text)); try { oConexion.SaveChanges(); Response.Write("<script LANGUAGE='JavaScript' >alert('La contraseña ha sido cambiada correctamente')</script>"); } catch (Exception ex) { Label1.Text = ex.Message; Response.Write("<script LANGUAGE='JavaScript' >alert('Error!')</script>"); } } } else { //Mensaje encima o debajo del campo Verificar Contraseña LabelMensajeValidorPass.Text = "No coicide la contraseña ingresada"; } } else { LabelMensajePass.Text = "Contraseña Incorrecta"; } }
protected void btnAgendar_Click(object sender, EventArgs e) { try { using (ClinicaWebEntities oConexion = new ClinicaWebEntities()) { string Fecha = txtFecha.Text; string Hora = txtHoraCita.Text; string Lugar = DropDownList1.SelectedItem.Text; int ced = Convert.ToInt32(Session["cedula"]); int queryC = (from C in oConexion.Cita where C.FechaCita == Fecha && C.HoraCita == Hora && C.LugarCita == Lugar select C.Cedula).FirstOrDefault(); if (queryC != 0) { Response.Write("<script LANGUAGE='JavaScript' >alert('La Cita Ya Ha Sido Reservada')</script>"); } else { Cita NuevaCita = new Cita(); NuevaCita.Cedula = ced; NuevaCita.FechaCita = txtFecha.Text; NuevaCita.HoraCita = txtHoraCita.Text; NuevaCita.LugarCita = DropDownList1.Text; oConexion.Cita.AddObject(NuevaCita); oConexion.SaveChanges(); bool n = true; if (n == true) { Response.Write("<script LANGUAGE='JavaScript' >alert('Se Agendo Correctamente la Cita')</script>"); } } } txtHoraCita.Enabled = true; DropDownList1.Enabled = true; } catch { Response.Write("<script LANGUAGE='JavaScript' >alert('Verifique Los Datos Ingresados')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { Response.Redirect("Principal.aspx"); } txtIdentificacion.Text = Session["cedula"].ToString(); int cedula = Convert.ToInt32(Session["cedula"]); txtNombre.Text = Session["user"].ToString(); ClinicaWebEntities db = new ClinicaWebEntities(); if (IsPostBack == false) { string apellido = (from c in db.Usuario where c.Cedula == cedula select c.ApellidoUsuario).FirstOrDefault(); txtApellidos.Text = apellido; int edad = (from c in db.Usuario where c.Cedula == cedula select c.Edad).FirstOrDefault(); txtEdad.Text = edad.ToString(); string direccion = (from c in db.Usuario where c.Cedula == cedula select c.Direccion).FirstOrDefault(); txtDireccion.Text = direccion; string telefono = (from c in db.Usuario where c.Cedula == cedula select c.Telefono).FirstOrDefault().ToString(); txtTelefono.Text = telefono; string username = (from c in db.Usuario where c.Cedula == cedula select c.Username).FirstOrDefault(); txtUserName.Text = username; string correo = (from c in db.Usuario where c.Cedula == cedula select c.Email).FirstOrDefault(); txtEmail.Text = correo; } //if (Session["pass"] != null) //{ // txtPass.Text = Session["pass"].ToString(); //} }
protected void btnIngresar_Click(object sender, EventArgs e) { string user = txtUsuario.Text; string pass = EncriptacionMD5(txtContrasenia.Text); ClinicaWebEntities db = new ClinicaWebEntities(); string query = (from n in db.Usuario where n.Username == user && n.contrasena == pass select n.NombreUsuario).FirstOrDefault(); int cedula = (from c in db.Usuario where c.Username == user && c.contrasena == pass select c.Cedula).FirstOrDefault(); int IdTipo = (from t in db.TipoUsuario where t.Cedula == cedula select t.IdTipoUsuario).FirstOrDefault(); if (query != null) { Session["cedula"] = cedula.ToString(); Session["tipousuario"] = IdTipo.ToString(); if (IdTipo == 1) { Session["user"] = query; Session["cedula"] = cedula; Response.Redirect("Principal.aspx"); } else { Session["user"] = query; Session["cedula"] = cedula; Response.Redirect("Principal.aspx"); } } else { lblMensaje.Text = "Usuario o Contraseña Incorrecto"; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { Response.Redirect("Principal.aspx"); } txtIdentificacion.Text = Session["cedula"].ToString(); int cedula = Convert.ToInt32(Session["cedula"]); txtNombre.Text = Session["user"].ToString(); ClinicaWebEntities db = new ClinicaWebEntities(); if (IsPostBack==false) { string apellido = (from c in db.Usuario where c.Cedula == cedula select c.ApellidoUsuario).FirstOrDefault(); txtApellidos.Text = apellido; int edad = (from c in db.Usuario where c.Cedula == cedula select c.Edad).FirstOrDefault(); txtEdad.Text = edad.ToString(); string direccion = (from c in db.Usuario where c.Cedula == cedula select c.Direccion).FirstOrDefault(); txtDireccion.Text = direccion; string telefono = (from c in db.Usuario where c.Cedula == cedula select c.Telefono).FirstOrDefault().ToString(); txtTelefono.Text = telefono; string username = (from c in db.Usuario where c.Cedula == cedula select c.Username).FirstOrDefault(); txtUserName.Text = username; string correo = (from c in db.Usuario where c.Cedula == cedula select c.Email).FirstOrDefault(); txtEmail.Text = correo; } //if (Session["pass"] != null) //{ // txtPass.Text = Session["pass"].ToString(); //} }