public ActionResult Editar(TablaViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (refugioEntities db = new refugioEntities())
{
var gato = db.Gatos.Find(model.ID);
gato.NOMBRE = model.NOMBRE;
gato.RAZA = model.RAZA;
gato.EDAD = model.EDAD;
gato.CASTRADO = model.CASTRADO;
db.Entry(gato).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Tabla/Index"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Enter(string usuario, string pass)
{
string password = Encrypt.GetSHA256(pass);
string ePass = "******";
try
{
using (refugioEntities db = new refugioEntities())
{
var lst = from d in db.Adm
where d.USUARIO == usuario && d.PASS == password
select d;
var User = lst.First();
var ePASS = User.PASS;
if (User.PASS == ePass)
{
Session["User"] = lst.First();
return(Content("Logueado correctamente, Cambie su usuario y contraseña"));
}
else
{
Session["User"] = lst.First();
return(Content("Logueado correctamente!"));
}
}
}
catch (Exception)
{
return(Content("No hay un usuario registrado con esa cuenta"));
}
}
public ActionResult Nuevo(TablaViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (refugioEntities db = new refugioEntities())
{
var gato = new Gatos();
gato.NOMBRE = model.NOMBRE;
gato.RAZA = model.RAZA;
gato.EDAD = model.EDAD;
gato.CASTRADO = model.CASTRADO;
db.Gatos.Add(gato);
db.SaveChanges();
}
return(Redirect("~/Tabla/Index"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult SessionAdd(string user, string email, string pass)
{
string ePass = Encrypt.GetSHA256(pass);
try
{
using (refugioEntities db = new refugioEntities())
{
if (ModelState.IsValid)
{
var oUser = new Adm();
oUser.ID = 4;
oUser.USUARIO = user;
oUser.EMAIL = email;
oUser.PASS = ePass;
db.Adm.Add(oUser);
db.SaveChanges();
return(Content("Usuario Agregado"));
}
return(Content("~/Agregar/Index"));
}
}
catch (Exception ex)
{
return(Content("Ocurrio un error" + ex.Message));
}
}
public ActionResult Eliminar(int id)
{
using (refugioEntities db = new refugioEntities())
{
var gato = db.Gatos.Find(id);
db.Gatos.Remove(gato);
db.SaveChanges();
}
return(Redirect("~/Tabla/Index"));
}
public ActionResult SessionEnter(string pass, string passRepeat)
{
string ePass = Encrypt.GetSHA256(pass);
string ePassRepeat = Encrypt.GetSHA256(passRepeat);
string usuario = "admin";
string passVerify = null;
try
{
if (ePass == ePassRepeat)
{
passVerify = ePass;
}
else
{
return(Content("Contraseña invalida"));
}
if (passVerify == "8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918")
{
return(Content("La contraseña que quiere poner, no se puede"));
}
using (refugioEntities db = new refugioEntities())
{
if (ModelState.IsValid)
{
{
var oUser = db.Adm.Find(1);
oUser.PASS = passVerify;
db.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
var lst = from d in db.Adm
where d.USUARIO == usuario && d.PASS == ePass
select d;
if (lst.Count() > 0)
{
Session["User"] = lst.First();
return(Content("Logueado correctamente!"));
}
}
return(Redirect("~/Tabla/Index"));
}
}
catch (Exception ex)
{
return(Content("Ocurrio un error" + ex.Message));
}
}
public ActionResult RecoverPass(string email)
{
ListSession model = new ListSession();
string pass = "******";
string emailOrigen = "*****@*****.**";
string emailDestino = email;
string password = "******";
try
{
if (ModelState.IsValid)
{
using (refugioEntities db = new refugioEntities())
{
var user = db.Adm.Where(d => d.EMAIL == email).FirstOrDefault();
if (user != null)
{
user.PASS = pass;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MailMessage oEmail = new MailMessage(emailOrigen, emailDestino, "Hola", "Su nueva contraseña es admin");
oEmail.IsBodyHtml = true;
SmtpClient smtpClient = new SmtpClient("smtp.gmail.com");
smtpClient.EnableSsl = true;
smtpClient.UseDefaultCredentials = false;
//smtpClient.Host = "smtp.gmail.com";
smtpClient.Port = 587;
smtpClient.Credentials = new System.Net.NetworkCredential(emailOrigen, password);
smtpClient.Send(oEmail);
smtpClient.Dispose();
return(Content("Contraseña enviada"));
}
else
{
return(Content("El correo no es valido"));
}
}
}
return(Content("Ocurrio un errror"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// GET: Agregar
public ActionResult Index()
{
List <ListSession> list;
using (refugioEntities db = new refugioEntities())
{
list = (from d in db.Adm
select new ListSession
{
ID = d.ID,
USUARIO = d.USUARIO,
EMAIL = d.EMAIL,
}).ToList();
}
return(View(list));
}
public ActionResult Editar(int id)
{
TablaViewModel model = new TablaViewModel();
using (refugioEntities db = new refugioEntities())
{
var gato = db.Gatos.Find(id);
model.NOMBRE = gato.NOMBRE;
model.RAZA = gato.RAZA;
model.EDAD = gato.EDAD;
model.CASTRADO = gato.CASTRADO;
model.ID = gato.ID;
}
return(View(model));
}
public ActionResult ListCat()
{
List <ListTablaViewModel> list;
using (refugioEntities db = new refugioEntities())
{
list = (from d in db.Gatos
select new ListTablaViewModel
{
ID = d.ID,
NOMBRE = d.NOMBRE,
RAZA = d.RAZA,
EDAD = d.EDAD,
CASTRADO = d.CASTRADO,
}).ToList();
}
return(View(list));
}
