public ActionResult Add(string greska = "")
        {
            if (Request.Cookies["user"] == null)
            {
                return(RedirectToAction("Login", "User"));
            }
            string username = Logged_username();

            if (Set_TempData(username) != "admin")
            {
                return(RedirectToAction("Racun", "User"));
            }
            var dal                  = new Sport_services();
            var eventdal             = new Event_services();
            SingleSportModel  model  = new SingleSportModel();
            List <All_Events> events = eventdal.Event_list().Select(one => new All_Events
            {
                Event = one.Name, Checked = false
            }).ToList();

            model.Eventi = events;
            BindingList <Sport_type> vrste_sportova = dal.Sportski_tipovi();

            ViewBag.Tipovi     = vrste_sportova;
            TempData["Greska"] = greska;
            return(View(model));
        }
        public ActionResult Add(SingleSportModel model)
        {
            if (Request.Cookies["user"] == null)
            {
                return(RedirectToAction("Login", "User"));
            }
            string username = Logged_username();

            if (Set_TempData(username) != "admin")
            {
                return(RedirectToAction("Racun", "User"));
            }
            var dal = new Sport_services();

            if (model.Sport.Name == null)
            {
                return(RedirectToAction("Add", new { greska = "Unesite ime sporta!" }));
            }
            if (dal.Check_existing(model.Sport.Name) != null)
            {
                return(RedirectToAction("Add", new { greska = "Sport već postoji!" }));
            }
            dal.New_sport(model, Logged_username());
            return(RedirectToAction("Index", new { sportname = model.Sport.Name }));
        }
        public void New_sport(SingleSportModel model, string username)
        {
            using (var ctx = new Context())
            {
                Sport sport = new Sport();
                sport.Name       = model.Sport.Name;
                sport.Sport_type = ctx.Sport_types.FirstOrDefault(t => t.ID == model.Sport.Sport_type.ID);
                sport.User       = ctx.Users.FirstOrDefault(u => u.Username == username);
                ctx.Sports.Add(sport);
                ctx.SaveChanges();

                Sport_comment commentDB = new Sport_comment();
                commentDB.Comment = model.Comment;
                commentDB.Active  = true;
                commentDB.Date    = DateTime.UtcNow;
                commentDB.Sport   = sport;
                commentDB.User    = ctx.Users.FirstOrDefault(u => u.Username == username);
                ctx.Sport_comments.Add(commentDB);
                ctx.SaveChanges();

                foreach (All_Events one in model.Eventi)
                {
                    if (one.Checked)
                    {
                        Sport_event oneevent = new Sport_event();
                        oneevent.Sport      = sport;
                        oneevent.Event_list = ctx.Event_list.Single(e => e.Name == one.Event);
                        ctx.Sport_events.Add(oneevent);
                        ctx.SaveChanges();
                    }
                }
            }
        }