public ActionResult Delete(Ecosystem std)//consultar el estudainte q deseo borrar
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
//using para usar en este contexto
{
if (ModelState.IsValid)
{
var u = (from q in DBContext.EcosystemSet
where q.EcosystemId == std.EcosystemId
select q).FirstOrDefault();
DBContext.EcosystemSet.Remove(u);
try
{
DBContext.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError(" ", "El ecosistema tiene animales registrados");
}
}
return(View());
}
}
// GET: AnimalEcosystemDetail
public ActionResult Index()
{
EcoGameModelContainer DB = new EcoGameModelContainer();
List <AnimalVM> AnimalVMList = new List <AnimalVM>();
var AnimalList = (from Ani in DB.AnimalSet join Eco in DB.EcosystemSet on Ani.Ecosystem.EcosystemId equals Eco.EcosystemId
select new
{
Ani.AnimalId,
Ani.NameAnimal,
Ani.ImgAnimal,
Ani.SoundAnimal,
Ani.DescAnimal,
Eco.NameEcosystem
}
).ToList();
foreach (var item in AnimalList)
{
AnimalVM objcvm = new AnimalVM();
objcvm.AnimalId = item.AnimalId;
objcvm.NameAnimal = item.NameAnimal;
objcvm.ImgAnimal = item.ImgAnimal;
objcvm.SoundAnimal = item.SoundAnimal;
objcvm.DescAnimal = item.DescAnimal;
objcvm.NameEcosystem = item.NameEcosystem;
AnimalVMList.Add(objcvm);
}
return(View(AnimalVMList));
}
public ActionResult Edit(Ecosystem std)
{
if (ModelState.IsValid)
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
{
int currentAnimal = Convert.ToInt32(Request.Form["EcosystemId"]);//seleccion del combo
//consulta a la base
var u = (from q in DBContext.EcosystemSet
where q.EcosystemId == std.EcosystemId
select q).FirstOrDefault();
if (u != null)
{
u.NameEcosystem = std.NameEcosystem;
u.ImgEcosystem = std.ImgEcosystem;
u.DescEcosystem = std.DescEcosystem;
u.RegEcosystem = std.RegEcosystem;
}
DBContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(std));
}
public ActionResult Index(User std)
{
EcoGameModelContainer DBContext = new EcoGameModelContainer();
var currentAnimal = Request.Form["UserName"];
var objCustomer = (from q in DBContext.UserSet
where q.NameUser == std.NameUser
select q).FirstOrDefault();
if (ModelState.IsValid)
{
try
{
if (objCustomer.Perfil.ProfileId == 2)
{
return(RedirectToAction("Admin", "Login"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}catch (Exception ex)
{
ModelState.AddModelError("", "Usuario no registrado");
}
}
return(View());
}
public ActionResult Edit(Profile std)
{
if (ModelState.IsValid)
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
{
int currentUser = Convert.ToInt32(Request.Form["ProfileId"]);//seleccion del combo
//consulta a la base
var u = (from q in DBContext.ProfileSet
where q.ProfileId == std.ProfileId
select q).FirstOrDefault();
if (u != null)
{
u.NameProfile = std.NameProfile;
}
DBContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(std));
}
// GET: Profile
public ActionResult Index()
{
EcoGameModelContainer Db = new EcoGameModelContainer();
return(View(Db.ProfileSet));
}
public ActionResult Create(Ecosystem objOrder)
{
EcoGameModelContainer db = new EcoGameModelContainer();
db.EcosystemSet.Add(objOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void PopulateCustomers(object selectedUser = null)
{
EcoGameModelContainer db = new EcoGameModelContainer();
var customersQuery = from d in db.ProfileSet
orderby d.NameProfile
select d;
ViewBag.ProfileID = new SelectList(customersQuery, "ProfileId", "NameProfile", selectedUser);
}
private void PopulateCustomers(object selectedAnimal = null)
{
EcoGameModelContainer db = new EcoGameModelContainer();
var customersQuery = from d in db.EcosystemSet
orderby d.NameEcosystem
select d;
ViewBag.EcosystemID = new SelectList(customersQuery, "EcosystemId", "NameEcosystem", selectedAnimal);
}
public ActionResult Delete(int EcosystemId)//consultar el estudainte q deseo borrar
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
//using para usar en este contexto
{
var std = (from q in DBContext.EcosystemSet
where q.EcosystemId == EcosystemId
select q).FirstOrDefault();
return(View(std));
}
}
public ActionResult Edit(int?EcosystemId)
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
//using para usar en este contexto
{
var std = (from q in DBContext.EcosystemSet
where q.EcosystemId == EcosystemId
select q).FirstOrDefault();
return(View(std));
}
}
public ActionResult Edit(int?UserId)
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
//using para usar en este contexto
{
PopulateCustomers();
var std = (from q in DBContext.UserSet
where q.UserId == UserId
select q).FirstOrDefault();
return(View(std));
}
}
public ActionResult Delete(User std)//consultar el estudainte q deseo borrar
{
using (EcoGameModelContainer DBContext = new EcoGameModelContainer())
//using para usar en este contexto
{
var u = (from q in DBContext.UserSet
where q.UserId == std.UserId
select q).FirstOrDefault();
DBContext.UserSet.Remove(u);
DBContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(User objOrder)
{
EcoGameModelContainer db = new EcoGameModelContainer();
int currentUser = Convert.ToInt32(Request.Form["ProfileId"]);//seleccion del combo
//consulta a la base
var objCustomer = (from q in db.ProfileSet
where q.ProfileId == currentUser
select q).FirstOrDefault();
objOrder.Perfil = objCustomer;
db.UserSet.Add(objOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Animal objOrder)
{
EcoGameModelContainer db = new EcoGameModelContainer();
int currentAnimal = Convert.ToInt32(Request.Form["EcosystemId"]);//seleccion del combo
//consulta a la base
var objCustomer = (from q in db.EcosystemSet
where q.EcosystemId == currentAnimal
select q).FirstOrDefault();
objOrder.Ecosystem = objCustomer;
db.AnimalSet.Add(objOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public PlayApiController()
{
emd = new EcoGameModelContainer();
}
