private static IList<UserDb> MapUsersFromDb(SqlDataReader sqlDataReader) { IList<UserDb> result = new List<UserDb>(); while (sqlDataReader.Read()) { int userId = (int)sqlDataReader["Id"]; Guid? verifyEmailCode = sqlDataReader.GetValueOrNull<Guid>("VerifyEmailCode"); var user = new UserDb() { Id = userId, Email = (string)sqlDataReader["Email"], Password = sqlDataReader.GetObjectOrNull<string>("Password"), FullName = sqlDataReader.GetObjectOrNull<string>("FullName"), CreatedDate = (DateTime)sqlDataReader["CreatedDate"], TimeStamp = (DateTime)sqlDataReader["UpdatedDate"], VerifyEmailCode = verifyEmailCode, IsVerified = !verifyEmailCode.HasValue }; result.Add(user); } return result; }
public UserDb UpdateUser(SqlTransaction transaction, UserDb user) { using (var cmd = new SqlCommand("[dbo].[spUpdateUser]", transaction.Connection, transaction)) { var updatedDate = DateTime.Now; cmd.Parameters.AddWithValue("userId", user.Id); cmd.Parameters.AddWithValue("password", Helper.ToSqlNullable(user.Password)); cmd.Parameters.AddWithValue("fullName", Helper.ToSqlNullable(user.FullName)); cmd.Parameters.AddWithValue("updatedDate", updatedDate); cmd.Parameters.AddWithValue("verifyEmailCode", Helper.ToSqlNullable(user.VerifyEmailCode)); cmd.CommandType = CommandType.StoredProcedure; return GetSingleUser(cmd); } }