예제 #1
0
        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());
            }
        }
예제 #2
0
        // 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));
        }
예제 #3
0
        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));
        }
예제 #4
0
        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());
        }
예제 #5
0
        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));
        }
예제 #6
0
        // GET: Profile
        public ActionResult Index()
        {
            EcoGameModelContainer Db = new EcoGameModelContainer();


            return(View(Db.ProfileSet));
        }
예제 #7
0
        public ActionResult Create(Ecosystem objOrder)
        {
            EcoGameModelContainer db = new EcoGameModelContainer();


            db.EcosystemSet.Add(objOrder);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #8
0
        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);
        }
예제 #9
0
        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);
        }
예제 #10
0
 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));
     }
 }
예제 #11
0
 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));
     }
 }
예제 #12
0
 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));
     }
 }
예제 #13
0
        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"));
        }
예제 #14
0
        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"));
        }
예제 #15
0
        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"));
        }
예제 #16
0
 public PlayApiController()
 {
     emd = new EcoGameModelContainer();
 }