public static MissingPerson findById(int Id)
        {
            MPDContext    db     = new MPDContext();
            MissingPerson person = db.MissingPersons.Single(u => u.PersonId == Id);

            return(person);
        }
 public ActionResult AddNewUser(User user)
 {
     if (ModelState.IsValid)
     {
         if (user.checkLoginIsset())
         {
             MPDContext db = new MPDContext();
             user.Role   = "user";
             user.Active = false;
             db.Users.Add(user);
             db.SaveChanges();
             ModelState.Clear();
             ViewBag.Message = user.Login + " został zarejestrowany. Aby wpełni korzystać z systemu, konto musi potwierdzić administrator.";
             return(View());
         }
         else
         {
             ViewBag.Message = "Podany login już istnieje w bazie";
             return(View("AddNewUser", user));
         }
     }
     else
     {
         return(View("AddNewUser", user));
     }
 }
        public static List <MissingPerson> FindAll()
        {
            MPDContext           db      = new MPDContext();
            List <MissingPerson> persons = db.MissingPersons.ToList();

            return(persons);
        }
 public ActionResult Login(User user)
 {
     if (user != null)
     {
         MPDContext db  = new MPDContext();
         User       usr = db.Users.Where(u => u.Login == user.Login && u.Password == user.Password).FirstOrDefault <User>();
         if (usr != null)
         {
             if (usr.Role != "admin" && !usr.Active)
             {
                 ViewBag.Message = "Twoje konto nie zostało zatwierdzone przez administratora! Nie możesz się zalogować.";
             }
             else
             {
                 Session["UserID"] = usr.UserId.ToString();
                 checkLogged();
                 return(RedirectToAction("LoggedIn"));
             }
         }
         else
         {
             ViewBag.Message = "Login lub hasło jest nieprawidłowe!";
         }
     }
     return(View());
 }
예제 #5
0
        public static List <User> FindAll()
        {
            MPDContext  db    = new MPDContext();
            List <User> users = db.Users.ToList();

            return(users);
        }
예제 #6
0
        public static User findById(int Id)
        {
            MPDContext db   = new MPDContext();
            User       user = db.Users.Single(u => u.UserId == Id);

            return(user);
        }
        public void delete()
        {
            deleteImage();
            MPDContext    db     = new MPDContext();
            MissingPerson person = db.MissingPersons.Single(u => u.PersonId == this.PersonId);

            db.MissingPersons.Remove(person);
            db.SaveChanges();
        }
예제 #8
0
        public bool checkLoginIsset()
        {
            MPDContext db  = new MPDContext();
            var        usr = db.Users.Where(u => u.Login == this.Login).FirstOrDefault <User>();

            if (usr != null)
            {
                return(false);
            }
            return(true);
        }
예제 #9
0
        public void changeAccountActive()
        {
            MPDContext db   = new MPDContext();
            User       user = db.Users.Single(u => u.UserId == this.UserId);

            if (user.Active)
            {
                user.Active = false;
            }
            else
            {
                user.Active = true;
            }
            db.SaveChanges();
        }
예제 #10
0
        public void changeRole()
        {
            MPDContext db   = new MPDContext();
            User       user = db.Users.Single(u => u.UserId == this.UserId);

            if (user.Role == "admin")
            {
                user.Role = "user";
            }
            else
            {
                user.Role = "admin";
            }
            db.SaveChanges();
        }
        public ActionResult PeopleList(string value)
        {
            checkLogged();
            List <MissingPerson> list = null;

            if (value == null)
            {
                list = MissingPerson.FindAll();
            }
            else
            {
                MPDContext db = new MPDContext();
                list = db.MissingPersons.Where(u => (u.Firstname.Contains(value)) || u.Lastname.Contains(value)).ToList();
            }
            ViewBag.MissingPeople = list;
            return(View());
        }
        public ActionResult EditPerson(MissingPerson newData)
        {
            checkLogged();
            MPDContext    db     = new MPDContext();
            MissingPerson person = MissingPerson.findById(newData.PersonId);

            person.Firstname   = newData.Firstname;
            person.Lastname    = newData.Lastname;
            person.Age         = newData.Age;
            person.Location    = newData.Location;
            person.Description = newData.Description;

            db.MissingPersons.AddOrUpdate(person);
            db.SaveChanges();
            ViewBag.formPerson = person;

            return(RedirectToAction("PersonDetails", new { id = person.PersonId }));
        }
 public ActionResult AddNew(MissingPerson person)
 {
     if (checkLogged())
     {
         person.addImage(person.ImageFile);
         person.UserId = loggedUser.UserId;
         MPDContext db = new MPDContext();
         db.MissingPersons.Add(person);
         db.SaveChanges();
         ModelState.Clear();
         ViewBag.Message = "Dodano zaginionego!";
         return(View());
     }
     else
     {
         ViewBag.Message = "Nie możesz dodać użytkownika, musisz się zalogować!";
         return(View(person));
     }
 }
 public AddressRepository(MPDContext dbContext) : base(dbContext)
 {
 }