public List <User> GetUserList() { using (UserEntities entities = new UserEntities()) { return(entities.User.ToList()); } }
public User GetUserById(string id) { try { int UserId = Convert.ToInt32(id); using (UserEntities entities = new UserEntities()) { return(entities.User.SingleOrDefault(User => User.id == UserId)); } } catch { throw new FaultException("Something went wrong"); } }
public void DeleteUser(string id) { try { int UserID = Convert.ToInt32(id); using (UserEntities entities = new UserEntities()) { User user = entities.User.SingleOrDefault(b => b.id == UserID); entities.User.Remove(user); } } catch { throw new FaultException("Something went wrong"); } }
public bool IsValid(string em, string ps) { try { using (UserEntities entities = new UserEntities()) { var query = (from c in entities.User where c.email == em && c.password == ps select c).Any(); return(query); } } catch { throw new FaultException("Something went wrong"); } }
public void AddUser(string Name, string Email, string Password) { using (UserEntities entities = new UserEntities()) { try { User user = new User { name = Name, email = Email, password = Password }; entities.User.Add(user); entities.SaveChanges(); } catch { throw new FaultException("Something went wrong"); } } }
//take all class on function public void UpdateUser(UserComposite usr) { try { int UserID = Convert.ToInt32(usr.Id); using (UserEntities entities = new UserEntities()) { User wow = entities.User.SingleOrDefault(b => b.id == UserID); wow.name = usr.Name; wow.email = usr.Email; wow.password = usr.Password; entities.SaveChanges(); } } catch { throw new FaultException("Something went wrong"); } }