public static List <MissingPerson> getList() { MissingPersonListContext db = new MissingPersonListContext(); List <MissingPerson> MissingPersonList = db.MissingPersons.ToList(); return(MissingPersonList); }
public void addMissingPerson() { MissingPersonListContext db = new MissingPersonListContext(); db.MissingPersons.Add(this); db.SaveChanges(); }
public static List <User> getUserList() { MissingPersonListContext db = new MissingPersonListContext(); List <User> userList = db.Users.ToList(); return(userList); }
private void createUser() { MissingPersonListContext db = new MissingPersonListContext(); UserType = Int32.Parse(ConfigurationManager.AppSettings["NORMAL_USER"]); db.Users.Add(this); db.SaveChanges(); }
public static void changeUserActiveStatus(int userId) { MissingPersonListContext db = new MissingPersonListContext(); User user = db.Users.Single(u => u.Id == userId); String active = user.Active == true ? "0" : "1"; String query = "Update Users SET active = " + active + " WHERE Id = " + user.Id.ToString(); db.Database.ExecuteSqlCommand(query); db.SaveChanges(); }
public static void changeUserType(int userId) { MissingPersonListContext db = new MissingPersonListContext(); User user = db.Users.Single(u => u.Id == userId); int type = user.UserType == Int32.Parse(ConfigurationManager.AppSettings["ADMIN_USER"]) ? Int32.Parse(ConfigurationManager.AppSettings["NORMAL_USER"]) : Int32.Parse(ConfigurationManager.AppSettings["ADMIN_USER"]); String query = "Update Users SET UserType = " + type + " WHERE Id = " + user.Id.ToString(); Debug.WriteLine(query); db.Database.ExecuteSqlCommand(query); db.SaveChanges(); }
public static MissingPerson getPopUpInfo(int userId) { MissingPerson person; MissingPersonListContext db = new MissingPersonListContext(); try { person = db.MissingPersons.Single(u => u.Id == userId); } catch (InvalidOperationException e) { return(null); } return(person); }
public User authorize() { User user; String Password = new Crypt().hashString(PasswordString); MissingPersonListContext db = new MissingPersonListContext(); try { user = db.Users.Single(u => u.Login == Login && u.Password == Password); } catch (InvalidOperationException e) { return(null); } return(user); }