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()); }
public static List <User> FindAll() { MPDContext db = new MPDContext(); List <User> users = db.Users.ToList(); return(users); }
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(); }
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); }
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(); }
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) { }