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;
}
