private bool LoginUser() { using (BusinessManagementSystemEntities entities = new BusinessManagementSystemEntities()) { return (from user in entities.Users where (user.Username == Username && user.Password == Username ) select user).Any(); } }
private void SaveUser() { using (BusinessManagementSystemEntities entities = new BusinessManagementSystemEntities()) { User user; if (CurrentUser.Id == 0) { user = new User(); } else { user = entities.Users.SingleOrDefault(s => s.Id == CurrentUser.Id); } if (user != null) { user.FirstName = CurrentUser.FirstName; user.MiddleName = CurrentUser.MiddleName; user.LastName = CurrentUser.LastName; user.Gender = CurrentUser.Gender; user.BirthDate = Convert.ToDateTime(CurrentUser.BirthDateString); user.EmailAddress = CurrentUser.EmailAddress; user.Username = CurrentUser.Username; user.Password = CurrentUser.Password; if (CurrentUser.Id == 0) { entities.Users.Add(user); } entities.SaveChanges(); } } }
private List<UserModel> GetUsers() { using (BusinessManagementSystemEntities entities = new BusinessManagementSystemEntities()) { return (from user in entities.Users select new UserModel { Id = user.Id, FirstName = user.FirstName, MiddleName = user.MiddleName, LastName = user.LastName, BirthDate = user.BirthDate, Gender = user.Gender, Username =user.Username, EmailAddress=user.EmailAddress }).ToList(); } }