public void editUser(E_user e_user) { using (var db = new Mapeo()) { E_user e_user2 = db.usuario.Where(x => x.Id == e_user.Id).First(); e_user2.Name = e_user.Name; e_user2.Last_name = e_user.Last_name; e_user2.User_name = e_user.User_name; e_user2.Pass = e_user.Pass; e_user2.Pasaporte_numero = e_user.Pasaporte_numero; e_user2.Activo = e_user.Activo; e_user2.Id_driver = e_user.Id_driver; e_user2.Mail = e_user.Mail; e_user2.LastModified = DateTime.Now; e_user2.Token = e_user.Token; e_user2.State_Id = e_user.State_Id; e_user2.EndToken = e_user.EndToken; e_user2.Sesion = e_user.Sesion; db.usuario.Attach(e_user2); var entry = db.Entry(e_user2); entry.State = EntityState.Modified; db.SaveChanges(); } }
public E_user compareUser(E_user user) { using (var db = new Mapping()) { return(db.votantes.Where(x => x.Cedula.Equals(user.Cedula) && x.Nacimiento.Equals(user.Nacimiento) && x.User_name.Equals(user.User_name) && x.User_lastname.Equals(user.User_lastname) && x.Expe.Equals(user.Expe)).FirstOrDefault()); } }
public void deleteUser(E_user e_User) { using (var db = new Mapping()) { E_audit_votante audit_votante = new E_audit_votante(); audit_votante.Nombre_old = e_User.User_name; audit_votante.Nombre_new = "Eliminado"; audit_votante.Apellido_old = e_User.User_lastname; audit_votante.Apellido_new = "Eliminado"; audit_votante.Cedula_old = e_User.Cedula; audit_votante.Cedula_new = "Eliminado"; audit_votante.Fechanac_old = e_User.Nacimiento; audit_votante.Fechanac_new = "Eliminado"; audit_votante.Fechaexp_old = e_User.Expe; audit_votante.Fechaexp_new = "Eliminado"; audit_votante.Correo_old = e_User.Mail; audit_votante.Correo_new = "Eliminado"; audit_votante.Fecha = DateTime.Now; db.audit_votante.Add(audit_votante); db.votantes.Attach(e_User); var entry = db.Entry(e_User); entry.State = EntityState.Deleted; db.SaveChanges(); } }
public E_user Login(E_user user) { using (var db = new Mapeo()) { return(db.usuario.Where(x => x.User_name.Equals(user.User_name) && x.Pass.Equals(user.Pass)).FirstOrDefault()); } }
public void addUser(E_user user) { using (var db = new Mapeo()) { db.usuario.Add(user); db.SaveChanges(); } }
public void save_votantes(E_user vot) { using (var db = new Mapping()) { db.votantes.Add(vot); db.SaveChanges(); } }
public void deleteUser(E_user e_user) { using (var db = new Mapeo()) { db.usuario.Attach(e_user); var entry = db.Entry(e_user); entry.State = EntityState.Deleted; db.SaveChanges(); } }
public void save_votado(E_user e_User) { using (var db = new Mapping()) { E_user e_user2 = db.votantes.Where(x => x.Id == e_User.Id).FirstOrDefault(); e_user2.Voto = e_User.Voto; db.votantes.Attach(e_user2); var entry = db.Entry(e_user2); entry.State = EntityState.Modified; db.SaveChanges(); } }
protected void B_Cambiar_Click(object sender, EventArgs e) { E_user e_user = (E_user)Session["user_id"]; e_user.Pass = Tb_Contraseña.Text; e_user.State_Id = 1; e_user.Token = null; e_user.EndToken = null; e_user.Sesion = e_user.User_name; new DAO_Admin().editUser(e_user); this.RegisterStartupScript("mensaje", "<script type='text/javascript'>alert('Su Contraseña ha sido actualizada.');window.location=\"PrimerFormulario.aspx\"</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["validUser"] != null && ((E_user)Session["validUser"]).Id_rol == 2) { } else { Response.Redirect("~/Login.aspx"); } E_user e_user = new E_user(); LB_Nombre.Text = ((E_user)Session["validUser"]).Name; LB_Apellido.Text = ((E_user)Session["validUser"]).Last_name; LB_PasDisponibles.Text = ((E_user)Session["validUser"]).Pasaporte_numero.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["validUser"] != null && ((E_user)Session["validUser"]).Id_rol == 3) { } else { Response.Redirect("~/View/Login.aspx"); } E_user e_user = new E_user(); string num = ((E_user)Session["validUser"]).Id_driver.ToString(); E_driver ps = new DAO_Admin().getNoPasaportes(int.Parse(num)); LB_Nombre.Text = ((E_user)Session["validUser"]).Name; LB_Apellido.Text = ((E_user)Session["validUser"]).Last_name; LB_Bonos.Text = ps.Total_pasaporte.ToString(); }
public void editPasaportes(E_user e_user) { using (var db = new Mapeo()) { E_user e_user2 = db.usuario.Where(x => x.Id == e_user.Id).First(); if (e_user.Pasaporte_numero <= 0) { e_user2.Pasaporte_numero = 0; } else { e_user2.Pasaporte_numero = e_user.Pasaporte_numero; } db.usuario.Attach(e_user2); var entry = db.Entry(e_user2); entry.State = EntityState.Modified; db.SaveChanges(); } }
protected void LoginButton_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user e_user = new E_user(); e_user.User_name = LG_Proyecto.UserName.ToString(); e_user.Pass = LG_Proyecto.Password.ToString(); e_user = new DAO_Login().Login(e_user); if (e_user == null) { ((Label)LG_Proyecto.FindControl("L_Mensaje")).Text = "Usuario o contraseña incorrecto"; } else if (e_user.State_Id == 2) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Su cuenta esta en espera de Recuperar Contraseña');</script>"); return; } else if (e_user.Id_rol == 1) { ((Label)LG_Proyecto.FindControl("L_Mensaje")).Text = "Bienvenido señor administrador"; Session["validUser"] = e_user; Connection(); Response.Redirect("AdminHome.aspx"); } else if (e_user.Id_rol == 2) { ((Label)LG_Proyecto.FindControl("L_Mensaje")).Text = "Bienvenido beneficiario"; Session["validUser"] = e_user; Connection(); Response.Redirect("UserHome.aspx"); } else if (e_user.Id_rol == 3) { ((Label)LG_Proyecto.FindControl("L_Mensaje")).Text = "Bienvenido conductor"; Session["validUser"] = e_user; Connection(); Response.Redirect("DriverHome.aspx"); } }
public void editUser(E_user e_User) { using (var db = new Mapping()) { E_user e_user2 = db.votantes.Where(x => x.Id == e_User.Id).FirstOrDefault(); E_audit_votante audit_votante = new E_audit_votante(); audit_votante.Nombre_old = e_user2.User_name; audit_votante.Nombre_new = e_User.User_name; audit_votante.Apellido_old = e_user2.User_lastname; audit_votante.Apellido_new = e_User.User_lastname; audit_votante.Cedula_old = e_user2.Cedula; audit_votante.Cedula_new = e_User.Cedula; audit_votante.Fechanac_old = e_user2.Nacimiento; audit_votante.Fechanac_new = e_User.Nacimiento; audit_votante.Fechaexp_old = e_user2.Expe; audit_votante.Fechaexp_new = e_User.Expe; audit_votante.Correo_old = e_user2.Mail; audit_votante.Correo_new = e_User.Mail; audit_votante.Fecha = DateTime.Now; e_user2.User_name = e_User.User_name; e_user2.User_lastname = e_User.User_lastname; e_user2.Cedula = e_User.Cedula; e_user2.Mail = e_User.Mail; e_user2.Nacimiento = e_User.Nacimiento; e_user2.Expe = e_User.Expe; db.audit_votante.Add(audit_votante); db.votantes.Attach(e_user2); var entry = db.Entry(e_user2); entry.State = EntityState.Modified; db.SaveChanges(); } }
protected void BT_Enviar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; string fileName = System.IO.Path.GetFileName(FU_Foto.PostedFile.FileName); string extension = System.IO.Path.GetExtension(FU_Foto.PostedFile.FileName); string saveLocation = Server.MapPath("~\\Images\\ProfilePictures\\") + DateTime.Now.ToFileTime().ToString() + extension; E_user e_user = new E_user(); e_user.Id_rol = 2; e_user.Name = TB_Nombre.Text; e_user.Last_name = TB_Apellido.Text; e_user.User_name = TB_User.Text; e_user.Pass = TB_Pass.Text; e_user.Mail = TB_Correo.Text; e_user.Id_ruta = int.Parse(DDL_NumRuta.SelectedValue); e_user.Activo = CB_Activo.Checked; e_user.Profile_pic = saveLocation; //---------------------------------// E_user euser = new DAO_Admin().getUserLogin(TB_User.Text); try { if (euser.User_name == TB_User.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ya existe');</script>"); return; } } catch (NullReferenceException) { } E_user euser_mail = new DAO_Admin().getMailUser(TB_Correo.Text); try { if (euser_mail.Mail == TB_Correo.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El correo ya existe');</script>"); return; } }catch (NullReferenceException) { } //---------------------------------// if (!(extension.Equals(".jpg") || extension.Equals(".jpeg") || extension.Equals(".png"))) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Tipo de archivo no valido o no subio archivo');</script>"); return; } if (System.IO.File.Exists(saveLocation)) { File.Delete(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ya existe un archivo en el servidor con ese nombre');</script>"); return; } try { FU_Foto.PostedFile.SaveAs(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El archivo ha sido cargado');</script>"); } catch (Exception exc) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Error: ');</script>"); return; } try { if (e_user.Profile_pic == " ") { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('No ha subido ninguna foto');</script>"); return; } } catch (NullReferenceException) { } //---------------------------------// e_user.LastModified = DateTime.Now; e_user.Sesion = ((E_user)Session["validUser"]).User_name; e_user.Pasaporte_numero = 0; //---------------------------------// //Generador de usuario ahora en User/QRCode.aspx.cs e_user.Qr_hash = RNG_Gen.RNG_gen(); Send_Mail mail = new Send_Mail(); mail.sendMail(e_user.Mail, e_user.Token, "Su usuario: " + e_user.User_name, "Su contraseña: " + e_user.Pass, "Bienvenido al programa."); new DAO_Admin().addUser(e_user); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ha sido registrado');</script>"); //-------------------------------// TB_Pass.Text = String.Empty; TB_Nombre.Text = String.Empty; TB_Correo.Text = String.Empty; TB_Apellido.Text = String.Empty; TB_User.Text = String.Empty; }
protected void button_enviar(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user user = new E_user(); string cedula = Page.Request.Form["cedula"].ToString(); int largoCedula = cedula.Length; int validate_cedula = 0; if (largoCedula < 5 || largoCedula > 10) { //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('el tamaño de la cédula es inconsistente');</script>"); ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('El tamaño de la cédula es inconsistente');window.open('add_votante.aspx','_self');", true); //Response.Redirect("~/View/add_votante.aspx"); } else { bool comprobation = int.TryParse(cedula, out validate_cedula); if (comprobation == true) { E_user checkUser = new DAO_User().GetVotanteCheck(cedula); if (checkUser == null) { string user_mail = Page.Request.Form["email"].ToString(); bool correoeoeo = false; if (user_mail.Contains("@hotmail") || user_mail.Contains("@gmail") || user_mail.Contains("@outlook") || user_mail.Contains("@yahoo")) { correoeoeo = true; } if (string.IsNullOrEmpty(user_mail) || correoeoeo == false) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Ingrese un correo valido');window.open('add_votante.aspx','_self');", true); } else { user.Mail = user_mail; } string user_name = Page.Request.Form["name"].ToString(); if (string.IsNullOrEmpty(user_name)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese el nombre');</script>"); } else { user.User_name = user_name; } string user_lastname = Page.Request.Form["lastname"].ToString(); if (string.IsNullOrEmpty(user_lastname)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese el apellido');</script>"); } else { user.User_lastname = user_lastname; } string date_nac = Page.Request.Form["date_nac"].ToString(); if (string.IsNullOrEmpty(date_nac)) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Ingrese su fecha de nacimiento');window.open('add_votante.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese su fecha de nacimiento');</script>"); } else { DateTime date_now = DateTime.Now; DateTime pruebaMeste = Convert.ToDateTime(date_nac); int year = date_now.Year - pruebaMeste.Year; int month = date_now.Month - pruebaMeste.Month; int day = date_now.Day - pruebaMeste.Day; if (month < 0) { year--; } else if (month == 0) { if (day <= 0) { year--; } } if (year < 18) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Es menor');window.open('add_votante.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese su fecha de nacimiento');</script>"); //Response.Redirect("~/View/add_votante.aspx"); } else { user.Nacimiento = date_nac; } //De la linea 71 a 96 se valida la edad por medio de una operación matemática } string date_exp = Page.Request.Form["date_e"].ToString(); if (string.IsNullOrEmpty(date_exp)) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Ingrese su fecha de expedicion');window.open('add_votante.aspx','_self');", true); } else { DateTime date_nac2 = Convert.ToDateTime(date_nac); DateTime pruebaMeste2 = Convert.ToDateTime(date_exp); int year = pruebaMeste2.Year - date_nac2.Year; int month = pruebaMeste2.Month - date_nac2.Month; int day = pruebaMeste2.Day - date_nac2.Day; if (month < 0) { year--; } else if (month == 0) { if (day <= 0) { year--; } } if (year < 18) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Usted es menor a 18 años');window.open('add_votante.aspx','_self');", true); return; //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese su fecha de nacimiento');</script>"); //Response.Redirect("~/View/add_votante.aspx"); } else if (year == 18 && month < 1 && month > -1) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Usted es menor a 18 años');window.open('add_votante.aspx','_self');", true); return; //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese su fecha de nacimiento');</script>"); //Response.Redirect("~/View/add_votante.aspx"); } else { user.Expe = date_exp; } } if (correoeoeo == false) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Su correo no es usable');window.open('add_votante.aspx','_self');", true); } else if (user.Expe == null) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Hubo un error con la fecha de expedicion, consulte a un administrador');window.open('admin_menu.aspx','_self');", true); } else { user.Cedula = cedula; user.Voto = false; new DAO_User().save_votantes(user); ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Ha sido registrado');window.open('admin_menu.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ha funcionado');</script>"); //Response.Redirect("~/View/admin_menu.aspx"); } } else if (checkUser.Cedula == cedula) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Cedula ya Registrada');</script>"); return; } } else { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Digite su cedula');window.open('add_votante.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Digite su cedula');</script>"); //Response.Redirect("~/View/admin_menu.aspx"); } } }
protected void button_enviar(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user user = new E_user(); string user_name = Page.Request.Form["name"].ToString(); if (string.IsNullOrEmpty(user_name)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese el nombre');</script>"); } else { user.User_name = user_name; } string user_lastname = Page.Request.Form["lastname"].ToString(); if (string.IsNullOrEmpty(user_lastname)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese el apellido');</script>"); } else { user.User_lastname = user_lastname; } string cedula = Page.Request.Form["cedula"].ToString(); int validate_cedula = 0; bool comprobation = int.TryParse(cedula, out validate_cedula); if (comprobation == true) { //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Funciona perro');</script>"); user.Cedula = cedula; } else { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Digite su cedula');window.open('Form.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Digite su cedula');</script>"); //Response.Redirect("~/View/admin_menu.aspx"); } string date_nac = Page.Request.Form["date_nac"].ToString(); if (string.IsNullOrEmpty(date_nac)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ingrese su fecha de nacimiento');</script>"); } else { DateTime date_now = DateTime.Now; DateTime pruebaMeste = Convert.ToDateTime(date_nac); int year = date_now.Year - pruebaMeste.Year; int month = date_now.Month - pruebaMeste.Month; int day = date_now.Day - pruebaMeste.Day; if (month < 0) { year--; } else if (month == 0) { //day <= 0 ? year : year - 1; if (day <= 0) { year--; } } if (year < 18) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Usuario Menor de edad');</script>"); } else { user.Nacimiento = date_nac; } } string date_exp = Page.Request.Form["date_e"].ToString(); if (string.IsNullOrEmpty(date_exp)) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Usuario Menor de Edad');</script>"); } else { user.Expe = date_exp; } Session["validUser"] = user; user = new DAO_User().compareUser(user); E_user pa = new DAO_User().getCandidatoVoto(cedula); if (user == null) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Esta persona no existe o no puede votar');</script>"); } else if (user.Cedula != cedula) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Esa cedula no existe');</script>"); } else if (pa.Voto == true) { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Usted ya realizo la votacion');window.open('index.aspx','_self');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Bienvenido, por favor vote a conciencia');window.open('selection_candidate.aspx','_self');", true); //cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Bienvenido');</script>"); //Response.Redirect("~/View/selection_candidate.aspx"); } }
protected void BT_Enviar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user e_user = new E_user(); e_user.Id_rol = 3; e_user.Name = TB_Nombre.Text; e_user.Last_name = TB_Apellido.Text; e_user.User_name = TB_User.Text; e_user.Pass = TB_Pass.Text; e_user.Mail = TB_Correo.Text; e_user.Id_ruta = int.Parse(DDL_NumRuta.SelectedValue); e_user.Id_driver = int.Parse(DDL_IdeConductor.SelectedValue); //---------------------------------// E_user euser = new DAO_Admin().getUserLogin(TB_User.Text); try { if (euser.User_name == TB_User.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ya existe');</script>"); return; } } catch (NullReferenceException) { } E_user euser_mail = new DAO_Admin().getMailUser(TB_Correo.Text); try { if (euser_mail.Mail == TB_Correo.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El correo ya existe');</script>"); return; } } catch (NullReferenceException) { } //----------------------------------// e_user.LastModified = DateTime.Now; e_user.Sesion = ((E_user)Session["validUser"]).User_name; //---------------------------------// Send_Mail mail = new Send_Mail(); mail.sendMail(e_user.Mail, e_user.Token, "Su usuario: " + e_user.User_name, "Su contraseña: " + e_user.Pass, "Bienvenido señor conductor al programa."); new DAO_Admin().addUser(e_user); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ha sido registrado');</script>"); //-------------------------------// TB_Pass.Text = String.Empty; TB_Nombre.Text = String.Empty; TB_Correo.Text = String.Empty; TB_Apellido.Text = String.Empty; TB_User.Text = String.Empty; }