public ActionResult convertirimagen(int id)
{
var db = new muestraEntities1();
var pers = db.personas.Find(id);
var s = db.imagenes.Where(x => x.id == pers.imagen_id).FirstOrDefault();
if (s != null)
{
return(File(s.imagen, "image/jpeg"));
}
else
{
return(File("~/Images/prueba.png", "image/jpeg"));
}
}
public ActionResult FileUpload(HttpPostedFileBase FileUpload1)
{
if (FileUpload1 != null)
{
var db = new muestraEntities1();
imagenes img = new imagenes();
using (BinaryReader reader = new BinaryReader(FileUpload1.InputStream))
{
byte[] image = reader.ReadBytes(FileUpload1.ContentLength);
img.imagen = image;
img.active = true;
db.imagenes.Add(img);
db.SaveChanges();
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Index(users model)
{
if (ModelState.IsValid)
{
muestraEntities1 db = new muestraEntities1();
users user = db.users.Where(x => x.correo == model.correo && x.pass == model.pass).FirstOrDefault();
if (user != null)
{
return(RedirectToAction("Index", "Home", new { user.id }));
}
else
{
ViewBag.Error = "Correo o contraseña invalido.";
}
}
// Si llegamos a este punto, es que se ha producido un error y volvemos a mostrar el formulario
return(View(model));
}
public ActionResult Index(int id)
{
//muestraEntities1 db = new muestraEntities1();
//users user = db.users.Find(id);
//var resultado = from t1 in db.users
// join t2 in db.personas on t1.id equals t2.users_id
// join t3 in db.imagenes on t2.imagen_id equals t3.id
// where t1.id == id
// select t2;
personas resultado = new personas();
using (var db = new muestraEntities1())
{
resultado = db.personas
.Where(x => x.users_id == id)
.Single();
}
ViewBag.nombre = resultado.nombre;
ViewBag.id = resultado.id;
return(View());
}
