public List <Profiles> getRandomProfiles() { using (var context = new UserDBEntities()) { context.Database.Connection.Open(); List <Profiles> list = context.Profiles.ToList(); List <int> ids = new List <int>(); foreach (var i in list) { ids.Add(i.Id); } List <Profiles> filteredList = new List <Profiles>(); Random random = new Random(); List <int> ranNumbers = new List <int>(); int c = 0; while (c < 5) { int ran = ids[random.Next(ids.Count)]; if (!ranNumbers.Contains(ran)) { ranNumbers.Add(ran); filteredList.Add(getUserByID(ran)); c++; } } return(filteredList); } }
/// <summary> /// Hämtar alla användare /// </summary> public List <Profiles> fetchProfiles() { using (var context = new UserDBEntities()) { context.Database.Connection.Open(); return(context.Profiles.ToList()); } }
public bool getHide(int id) { using (var context = new UserDBEntities()) { var hide = (from a in context.SECURITY where (a.PID == id) select a.VISIBILITY).SingleOrDefault(); return(hide); } }
public Profiles getUserByID(int id) { Profiles user; using (var context = new UserDBEntities()) { user = context.Profiles.Find(id); } return(user); }
public string getName(int id) { using (var context = new UserDBEntities()) { var user = (from a in context.Profiles where (a.Id == id) select a).SingleOrDefault(); return(user.Firstname); } }
public string getPAboutById(int id) { using (var context = new UserDBEntities()) { var about = (from a in context.Profiles where (a.Id == id) select a.About).Single(); return(about); } }
/// <summary> /// Hämtar en user med viss id /// </summary> public List <Profiles> findProfilesByName(string name) { using (var context = new UserDBEntities()) { context.Database.Connection.Open(); List <Profiles> profile = (from a in context.Profiles where (a.Lastname.Contains(name) || a.Firstname.Contains(name)) select a).ToList(); return(profile); } }
public void UpdatePassword(int id, string newpass) { using (var context = new UserDBEntities()) { var user = (from a in context.SECURITY where (a.PID == id) select a).SingleOrDefault(); user.PASSWORD = newpass; context.SaveChanges(); } }
public void setPAboutById(int id, string about) { using (var context = new UserDBEntities()) { var user = (from a in context.Profiles where (a.Id == id) select a).SingleOrDefault(); user.About = about; context.SaveChanges(); } }
public void setPic(int id, string filename) { using (var context = new UserDBEntities()) { var user = (from a in context.Profiles where (a.Id == id) select a).SingleOrDefault(); user.Pic = filename; context.SaveChanges(); } }
public bool comparePassword(int id, string oldpass) { using (var context = new UserDBEntities()) { var user = (from a in context.SECURITY where (a.PID == id) select a).SingleOrDefault(); if (user.PASSWORD == oldpass) { return(true); } else { return(false); } } }
/// <summary> /// Lägger till en användare i databasen /// </summary> public void insertUser(Profiles profile, SECURITY security) { try { using (var context = new UserDBEntities()) { context.Database.Connection.Open(); context.Profiles.Add(profile); context.SaveChanges(); security.PID = profile.Id; context.SECURITY.Add(security); context.SaveChanges(); } } catch (Exception e) { } }
public SECURITY loginUser(SECURITY user) { using (var context = new UserDBEntities()) { context.Database.Connection.Open(); SECURITY usr = null; try { usr = context.SECURITY.Single(u => u.USERNAME == user.USERNAME && u.PASSWORD == user.PASSWORD); } catch { usr = null; } return(usr); } }
public void setHide(int id, bool choice) { using (var context = new UserDBEntities()) { var hide = (from a in context.SECURITY where (a.PID == id) select a).SingleOrDefault(); if (choice == true) { hide.VISIBILITY = true; } if (choice == false) { hide.VISIBILITY = false; } context.SaveChanges(); } }