/// <summary> /// Gets the user information by username and password. /// </summary> /// <param name="username">The username.</param> /// <param name="password">The password.</param> /// <returns></returns> public UserModel GetUserInfoByUsernameAndPassword(string username, string password) { using (var db = new SampleEntities()) { string encryptedPassword = EncryptionUtility.Encrypt(password, true); return db.Users.Where(w => w.Username == username && w.Password == encryptedPassword).Select(s => new UserModel { Id = s.Id, FirstName = s.FirstName, MiddleName = s.MiddleName, LastName = s.LastName, Email = s.Email, Phone = s.Phone, Username = s.Username, UserTypeId = s.UserTypeId }).SingleOrDefault(); } }
/// <summary> /// Gets the user information by user identifier. /// </summary> /// <param name="userId">The user identifier.</param> /// <returns></returns> public UserModel GetUserInfoByUserId(long userId) { using (var db = new SampleEntities()) { return db.Users.Where(w => w.Id == userId).Select(s => new UserModel { Id = s.Id, FirstName = s.FirstName, MiddleName = s.MiddleName, LastName = s.LastName, Email = s.Email, Phone = s.Phone, Username = s.Username, UserType = new UserTypeModel { Id = s.UserType.Id, Name = s.UserType.Name } }).SingleOrDefault(); } }