public ActionResult Create(ImageFlyer model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
//Verificar si hay una imagen https://www.youtube.com/watch?v=XtjoCuE_J48
var pic = string.Empty;
var folder = "~/Content/img";
if (model.ImageFile == null)
{
return(View(model));
}
pic = FilesHelper.UploadPhoto(model.ImageFile, folder);
pic = string.Format("{0}/{1}", folder, pic);
using (var db = new DataBasesSGCEntities())
{
Flyer oFlyer = new Flyer();
oFlyer.description = model.Description;
oFlyer.name = model.Name;
oFlyer.imagen = model.Imagen;
oFlyer.imagen = pic;
db.Flyer.Add(oFlyer);
db.SaveChanges();
}
return(Redirect(Url.Content("~/Flyer/Index")));
}
public ActionResult Enter(string user, string pass)
{
try
{
using (DataBasesSGCEntities db = new DataBasesSGCEntities())
{
var list = from d in db.Admin
where d.email == user && d.password == pass
select d;
if (list.Count() > 0)
{
Session["User"] = list.First();
return(Content("1"));
}
else
{
return(Content("Usuario Invalido"));
}
}
}
catch (Exception ex)
{
return(Content("Ocurrio un error: " + ex.Message));
}
}
public ActionResult Delete(DeleteFlyerModel model)
{
using (var db = new DataBasesSGCEntities())
{
Flyer oFlyer = db.Flyer.Find(model.Id);
db.Flyer.Remove(oFlyer);
db.SaveChanges();
}
return(Redirect(Url.Content("~/Flyer/Index")));
}
public ActionResult Create(int Id)
{
if (Id == -1)
{
return(View());
}
DataBasesSGCEntities db = new DataBasesSGCEntities();
ViewBag.destino = db.Flyer.Find(Id).name;
return(View());
}
public ActionResult Delete(int Id)
{
DeleteFlyerModel model = new DeleteFlyerModel();
using (var db = new DataBasesSGCEntities())
{
var oFlyer = db.Flyer.Find(Id);
model.Description = oFlyer.description;
model.Imagen = oFlyer.imagen;
}
return(View(model));
}
public ActionResult Edit(int Id)
{
EditImageFlyer model = new EditImageFlyer();
using (var db = new DataBasesSGCEntities())
{
var oFlyer = db.Flyer.Find(Id);
model.Description = oFlyer.description;
model.Name = oFlyer.name;
model.Imagen = oFlyer.imagen;
model.Id = oFlyer.id;
}
return(View(model));
}
public ActionResult FlyerDetails(int Id)
{
FlyerModel model = new FlyerModel();
using (DataBasesSGCEntities db = new DataBasesSGCEntities())
{
var oFlyer = db.Flyer.Find(Id);
model.Id = oFlyer.id;
model.Imagen = oFlyer.imagen;
model.Description = oFlyer.description;
model.Name = oFlyer.name;
}
return(View(model));
}
public ActionResult Index()
{
List <FlyerModel> lst = null;
using (DataBasesSGCEntities db = new DataBasesSGCEntities())
{
lst = (from d in db.Flyer
select new FlyerModel
{
Id = d.id,
Name = d.name,
Description = d.description,
Imagen = d.imagen
}).ToList();
}
return(View(lst));
}
public ActionResult Edit(EditImageFlyer model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var pic = string.Empty;
var folder = "~/Content/img";
if (model.ImageFile != null)
{
pic = FilesHelper.UploadPhoto(model.ImageFile, folder);
pic = string.Format("{0}/{1}", folder, pic);
using (var db = new DataBasesSGCEntities())
{
var oFlyer = db.Flyer.Find(model.Id);
oFlyer.description = model.Description;
oFlyer.name = model.Name;
oFlyer.imagen = model.Imagen;
oFlyer.imagen = pic;
db.Entry(oFlyer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
else
{
using (var db = new DataBasesSGCEntities())
{
var oFlyer = db.Flyer.Find(model.Id);
oFlyer.description = model.Description;
oFlyer.name = model.Name;
db.Entry(oFlyer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return(Redirect(Url.Content("~/Flyer/Index")));
}
// GET: Admin
public ActionResult Index()
{
List <AdminModel> lst = null;
using (DataBasesSGCEntities db = new DataBasesSGCEntities())
{
lst = (from d in db.Admin
where d.email == "*****@*****.**"
orderby d.email
select new AdminModel
{
Id = d.id,
Email = d.email,
Password = d.password
}).ToList();
}
return(View(lst));
}
