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 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 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 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 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 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();
//}
}