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);
}
