public List <User> GetUsersList() { using (PenggunaEntities1 entities = new PenggunaEntities1()) { return(entities.User.ToList()); } }
public void AddUser(string name, string email, string password) { using (PenggunaEntities1 entities = new PenggunaEntities1()) { User book = new User { name = name, email = email, password = password }; entities.User.Add(book); entities.SaveChanges(); } }
public void UpdateUser(UserComposite usr) { int UserId = Convert.ToInt32(usr.Id); using (PenggunaEntities1 entities = new PenggunaEntities1()) { User wow = entities.User.SingleOrDefault(b => b.id == UserId); wow.name = usr.Name; wow.email = usr.Email; wow.password = usr.Password; entities.SaveChanges(); } }
public User GetUserById(string id) { try { int UserId = Convert.ToInt32(id); using (PenggunaEntities1 entities = new PenggunaEntities1()) { 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 (PenggunaEntities1 entities = new PenggunaEntities1()) { User User = entities.User.SingleOrDefault(b => b.id == UserId); entities.User.Remove(User); entities.SaveChanges(); } } catch { throw new FaultException("Something went wrong"); } }
public bool IsValid(string em, string ps) { try { string UserName = em; string UserPass = ps; using (PenggunaEntities1 entities = new PenggunaEntities1()) { 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"); } }